Excel shortcut keys

Excel shortcut keys can greatly improve your speed when conducting analysis. But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel.

To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. No platform confusion, no unintelligible symbols — just a clear list of shortcuts to make you faster. Happy Exceling!

Working with files
Function	Windows	Mac
New file	Ctrl + N	⌘ + N
Open	Ctrl + O	⌘ + O
Save	Ctrl + S	⌘ + S
Save as	Ctrl + Shift + S	⌘ + Shift + S
Print	Ctrl + P	⌘ + P
Print preview	Ctrl + F2
Close workbook	Ctrl + W	⌘ + W
Close Excel	Ctrl + Q	⌘ + Q

Working with data
Function	Windows	Mac
Copy	Ctrl + C	⌘ + C
Cut	Ctrl + X	⌘ + X
Paste	Ctrl + V	⌘ + V
Paste special	Ctrl + Alt + V	Control + ⌘ + V
Undo	Ctrl + Z	⌘ + Z
Redo	Ctrl + Y	⌘ + Y
Find	Ctrl + F	⌘ + F
Find previous	Ctrl + Shift + F4	⌘ + Shift + G
Find next	Shift + F4	⌘ + G
Find and replace	Ctrl + H	Control + H

Moving within a workbook
Function	Windows	Mac
Move right
Move left
Move up
Move down
Move right to next full cell	Ctrl +	Control +
Move left to next full cell	Ctrl +	Control +
Move up to next full cell	Ctrl +	Control +
Move down to next full cell	Ctrl +	Control +
Move to beginning of row	Home	Fn +
Move to last cell	Ctrl + End	Fn + Control +
Move to first cell	Ctrl + Home	Fn + Control +
Scroll right one screen	Alt + PgDn	Fn + Option +
Scroll left one screen	Alt + PgUp	Fn + Option +
Scroll up one screen	PgUp	Fn +
Scroll down one screen	PgDn	Fn +
End mode	End	Fn +

Selecting cells
Function	Windows	Mac
Go to cell	Ctrl + G	Control + G
Select all	Ctrl + A	⌘ + A
Select row	Shift + Space	Shift + Space
Select column	Ctrl + Space	Control + Space
Select current region	Ctrl + Shift + *	Shift + Control + Space
Select current array	Ctrl + /	Control + /
Select all precedents	Ctrl + Shift + {	Control + Shift + {
Select direct dependents	Ctrl + ]	Control + ]
Select all dependents	Ctrl + Shift + }	Control + Shift + }
Select only visible cells	Alt + ;	⌘ + Shift + Z
Add cell range to selection	Shift + Click	Shift + Click
Add one-off cells to selection	Ctrl + Click	⌘ + Click
Move active cell right to non-adjacent selection	Ctrl + Alt +	Control + Option +
Move active cell left to non-adjacent selection	Ctrl + Alt +	Control + Option +
Move selection one column left		Option + Tab
Move selection one column right		Option + Shift + Tab
Toggle selection add mode	Shift + F8	Fn + Shift + F8
Clear selection	Esc	Esc
Expand selection to the right	Shift +	Shift +
Expand selection to the left	Shift +	Shift +
Expand selection up	Shift +	Shift +
Expand selection down	Shift +	Shift +
Expand selection to last full cell to the right	Ctrl + Shift +	⌘ + Shift +
Expand selection to last full cell to the left	Ctrl + Shift +	⌘ + Shift +
Expand selection to last full cell up	Ctrl + Shift +	⌘ + Shift +
Expand selection to last full cell down	Ctrl + Shift +	⌘ + Shift +
Expand selection up full screen	Shift + PgUp	Fn + Shift +
Expand selection down full screen	Shift + PgDn	Fn + Shift +
Expand selection to beginning of row	Shift + Home	Fn + Shift +
Expand selection to first worksheet cell	Ctrl + Shift + Home	Fn + Control + Shift +
Expand selection to last worksheet cell	Ctrl + Shift + End	Fn + Control + Shift +
Toggle extend selection mode	F8	Fn + F8
Select only cells with comments	Ctrl + Shift + O	Fn + Control + Shift + O
Select row differences	Ctrl + \	Control + \
Select column differences	Ctrl + Shift + |	Control + Shift + |
Select direct precedents	Ctrl + [	Control + [

Working with active cells
Function	Windows	Mac
Only select active cell	Shift + Backspace	Shift + Delete
Show active cell	Ctrl + Backspace	⌘ + Delete
Move active cell clockwise	Ctrl + .	Control + .
Move active cell down	Enter	Return
Move active cell up	Shift + Enter	Shift + Return
Move active cell right	Tab	Tab
Move active cell left	Shift + Tab	Shift + Tab

Editing formulas
Function	Windows	Mac
Edit active cell	F2	Control + U
Cancel entry	Esc	Esc
Delete to end of line	Ctrl + Delete	Control + Delete
Delete character in back of cursor	Backspace	Backspace
Delete character in front of cursor	Delete	Fn + Delete
New line within cell	Alt + Enter	Control + Option + Return
Add character to the right to selection	Shift +	Shift +
Add character to the left to selection	Shift +	Shift +
Move one word right	Ctrl +	Control +
Move one word left	Ctrl +	Control +
Add word to right to selection	Ctrl + Shift +	Control + Shift +
Add word to left to selection	Ctrl + Shift +	Control + Shift +
Select from beginning of cell to current position	Shift + Home	Fn + Shift +
Select from current position to end of cell	Shift + End	Fn + Shift +
Insert comment	Shift + F2	Fn + Shift + F2

Entering data
Function	Windows	Mac
Commit and move down	Enter	Return
Commit and move up	Shift + Enter	Shift + Return
Commit and move right	Tab	Tab
Commit and move left	Shift + Tab	Shift + Tab
Commit and stay in same cell	Ctrl + Enter	Control + Return
Enter data in multiple cells	Ctrl + Enter	Control + Return
Insert current date	Ctrl + ;	Control + ;
Insert current time	Ctrl + Shift + :	Control + Shift + :
Fill from cell above	Ctrl + D	Control + D
Fill from cell to left	Ctrl + R	Control + R
Fill formula from cell above	Ctrl + '	Control + '
Hyperlink	Ctrl + K	⌘ + K
Display Autocomplete	Alt +	Option +

Using the Ribbon
Function	Windows	Mac
Show / hide Ribbon	Ctrl + F1	⌘ + Option + R
Enter Windows hotkey combination	Alt
Help	F1

Formatting cells
Function	Windows	Mac
Open format dialogue	Ctrl + 1	⌘ + 1
Re-apply format	F4	Control + Y
Align center	Alt + H + A + C	⌘ + E
Align left	Alt + H + A + L	⌘ + L
Align right	Alt + H + A + R	⌘ + R
Indent	Alt + H + 6	Control + Option + Tab
Un-indent	Alt + H + 5	Control + Option + Shift + Tab
Increase font size	Alt + H + FG	⌘ + Shift + >
Decrease font size	Alt + H + FK	⌘ + Shift + <
Format as general	Ctrl + Shift + ~	Control + Shift + ~
Format as currency	Ctrl + Shift + $	Control + Shift + $
Format as percentage	Ctrl + Shift + %	Control + Shift + %
Format as scientific	Ctrl + Shift + ^	Control + Shift + ^
Format as date	Ctrl + Shift + #	Control + Shift + #
Format as time	Ctrl + Shift + @	Control + Shift + @
Format as number	Ctrl + Shift + !	Control + Shift + !
Bold	Ctrl + B	⌘ + B
Italic	Ctrl + I	⌘ + I
Underline	Ctrl + U	⌘ + U
Strikethrough	Ctrl + 5	⌘ + Shift + X
Add shadow		⌘ + Shift + W
Add outline		⌘ + Shift + D
Border all	Ctrl + Shift + &	⌘ + Option +
Border right	Alt + R	⌘ + Option +
Border left	Alt + L	⌘ + Option +
Border top	Alt + T	⌘ + Option +
Border bottom	Alt + B	⌘ + Option +
Border interior horizontal	Alt + H
Border interior vertical	Alt + V
Remove borders	Ctrl + Shift + _	⌘ + Option + _

Calculations
Function	Windows	Mac
Toggle reference (relative vs. absolute)	F4	⌘ + T
Calculate all sheets	F9	Fn + F9
Calculate only active sheet	Shift + F9	Fn + Shift + F9
Autosum	Alt + =	⌘ + Shift + T
Insert function	Shift + F3	Fn + Shift + F3
Show function arguments	Ctrl + Shift + A	Control + Shift + A
Commit array formula	Ctrl + Shift + Enter	Control + Shift + Return
Evaluate part of formula	F9	Fn + F9
Toggle formula bar	Ctrl + Shift + U	Control + Shift + U
Show formula builder	Ctrl + A	Control + A
Define name	Ctrl + F3	Control + L
Create name	Ctrl + Shift + F3	Control + Shift + F3
Paste name into formula	F3

Worksheets and workbooks
Function	Windows	Mac
New worksheet	Shift + F11	Shift + F11
Next worksheet	Ctrl + PgDn	Fn + Control +
Previous worksheet	Ctrl + PgUp	Fn + Control +
Next workbook	Ctrl + Tab	Control + Tab
Previous workbook	Ctrl + Shift + Tab	Control + Shift + Tab
Next pane	F6	F6
Previous pane	Shift + F6	Shift + F6
Minimize window	Ctrl + F9	⌘ + M
Maximize window	Ctrl + F1
Select multiple worksheets	Shift + Click	Shift + Click
Select one-off single worksheets	Ctrl + Click	⌘ + Click

Rows and columns
Function	Windows	Mac
Insert rows / columns dialogue	Ctrl + Shift + +	Control + I
Insert rows	Ctrl + Shift + +	Control + I
Insert columns	Ctrl + Shift + +	Control + I
Delete dialog	Ctrl + -	Control + -
Delete rows	Ctrl + -	Control + -
Delete columns	Ctrl + -	Control + -
Delete cells	Ctrl + -	Control + -
Clear cells	Delete	Fn + Delete
Group	Alt + Shift +	⌘ + Shift + K
Ungroup	Alt + Shift +	⌘ + Shift + J
Group dialog	Alt + Shift +	⌘ + Shift + K
Ungroup dialog	Alt + Shift +	⌘ + Shift + J
Hide columns	Ctrl +	Control +
Hide rows	Ctrl + 9	Control + 9
Unhide rows	Ctrl + Shift + 9	Control + Shift + 9
Unhide columns	Ctrl + Shift +	Control + Shift +
Toggle outline symbols	Ctrl + 8	Control + 8

Charts, filters, and pivots
Function	Windows	Mac
Create chart	Alt + F1	Fn + Option + F1
Create chart (new sheet)	F11	Fn + F11
Autofilter	Ctrl + Shift + L	⌘ + Shift + F
Open filters	Alt +	Option +
Insert table	Ctrl + T	Control + T
Group pivot table items	Alt + Shift +	⌘ + Shift + K
Ungroup pivot table items	Alt + Shift +	⌘ + Shift + J
Hide pivot table item	Ctrl + -	Ctrl + -
Create pivot chart	Alt + F1
Create pivot chart on new sheet	F11	Fn + F11
Pivot table wizard	Alt + D + P	⌘ + Option + P

Helper modules
Function	Windows	Mac
Spell check	F7	F7
Thesaurus	Shift + F7	Shift + F7
VBA editor	Alt + F11	Fn + Option + F11
Macros	Alt + F8	Fn + Option + F8
Hide or show	Ctrl + 6	Control + 6
Duplicate	Ctrl + D	⌘ + D
Modify cell style	Alt + '	⌘ + Shift + L
Control menu	Alt + Space	?
Shortcut menu	Shift + F1	Fn + Shift + F1

Comments