Excel Shortcuts for Mac and Windows
October 1, 2020
If you want to master financial modeling, practicing Excel shortcuts is a must. They help to make us more efficient and precise when using the program, minimizing errors. We strongly recommend using Windows for Excel, however, we recognize that some people are long-term Apple users and only have access to a Mac. It’s important to note that shortcuts differ between the two, so make sure you become accustomed to the right key combinations for your software.
We’ve picked our favorite shortcuts below. Learn these and watch your productivity levels soar!
Columns and Rows
| Shortcut Name | Windows Keys | Mac Keys |
| Open the options window |
Alt
> F
> T
|
⌘
,
|
| Select column |
Ctrl
Space
|
|
| Select row |
Shift
Space
|
Shift
Space
|
| Insert selected column or row |
Ctrl
+
|
Control
Shift
+
|
| Delete selected column or row |
Ctrl
–
|
⌘
–
|
Move between cells |
Arrows
|
Arrows
|
| Go to cell A1 |
Ctrl
Home
|
Fn
Ctrl
Left
|
| Go to beginning of row |
Ctrl
Home
|
Fn
Ctrl
Left
|
| Select column |
Ctrl
Space
|
Ctrl
Space
|
| Select row |
Shift
Space
|
Shift
Space
|
| Select all to the last cell used in the sheet |
Ctrl
Shift
End
|
Ctrl
Shift
End
|
| Select all to the last cell used in the row/column |
Ctrl
Arrow
|
Ctrl
Arrow
|
Paste Shortcuts
| Shortcut Name | Windows Keys | Mac Keys |
| Paste Special formats |
Ctrl
Alt
V
T
|
Ctrl
⌘
V
T
|
| Paste Special values |
Ctrl
Alt
V
V
|
Ctrl
⌘
V
V
|
| Paste Special formulas |
Ctrl
Alt
V
F
|
Ctrl
⌘
V
F
|
| Paste Special comments |
Ctrl
Alt
V
C
|
Ctrl
⌘
V
C
|
Clear Shortcuts
| Shortcut Name | Windows Keys | Mac Keys |
| Clear cell data |
Delete
|
Delete
|
| Clear cell formats |
Alt
H
E
F
|
|
| Clear cell comments |
Alt
H
E
M
|
|
| Clear all (data, formats, comments) |
Alt
H
E
A
|
Data
| Shortcut Name | Windows Keys | Mac Keys |
| Toggle filters |
Ctrl
Shift
L
|
⌘
⇧
F
|
| Insert sheet |
Shift
F11
|
Shift
fn
F11
|
| Delete sheet |
Alt
> E
> L
|
|
| Delete character to left |
Backspace
|
Delete
|
Delete character to right |
Delete
|
Fn
Delete
|
| Search |
Ctrl
F
|
⌘
F
|
| Replace |
Ctrl
H
|
⌘
Shift
H
|
| Add decimal place |
Alt
> H
> 0
|
|
| Remove decimal place |
Alt
> H
> 9
|
|
| Add a non-adjacent cell or range to a selection of cells by using the arrow keys |
Shift
F8
|
|
| Enter multiple lines in a cell |
Alt
Enter
|
Control
⌘
Enter
|
| Fill down |
Ctrl
D
|
Ctrl
D
|
| Fill right |
Ctrl
R
|
Ctrl
R
|
| Show all constants |
F5
Alt
S
O
|
|
| Highlight cells with comments |
F5
Alt
S
C
|
View
| Shortcut Name | Windows Keys | Mac Keys |
| Normal view |
Alt
> W
> L
|
|
| Page break preview |
Alt
> W
> I
|
|
| Toggle freeze panes |
Alt
> W
> F
> F
|
|
| Select zoom level |
Alt
> W
> Q
|
|
| Zoom to 100% |
Alt
> W
> J
|
|
| Jump to active cell if off-screen |
Ctrl
Backspace
|
Formulas
| Shortcut Name | Windows Keys | Mac Keys |
| Toggle reveal formulas |
Alt
> M
> H
|
|
| Accept function with AutoComplete |
Tab
|
⇩
Tab
|
| Toggle large formula bar |
Ctrl
Shift
U
|
Control
Shift
U
|
| AutoSum (checks for values above then left) |
Alt
=
|
⌘
Shift
T
|
| Enter date |
Ctrl
;
|
Ctrl
;
|
Enter date |
Ctrl
Shift
:
|
Ctrl
Shift
:
|
F Keys
| Shortcut Name | Windows Keys | Mac Keys |
| Help |
F1
|
⌘
/
|
| Go To |
F5
|
fn
F5
|
| Calculate workbook |
F9
|
fn
F9
|
| Add/edit comment |
Shift
F2
|
fn
Shift
F2
|
| Edit active cell |
F2
|
Control
U
|
| Cycle backwards through panes |
Shift
F6
|
fn
F6
|
| Show context menu |
Shift
F10
|
|
| Show key tips |
F10
|
|
| Paste Name |
F13
|
|
| Check spelling |
F7
|
fn
F7
|
| Create chart sheet for selection |
F11
|
fn
F11
|
| Cycle cell reference |
F4
|
⌘
T
|
| Toggle extend mode |
F8
|
fn
F8
|
| Save as |
F12
|
⌘
Shift
S
|