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 with 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
Shift
+
Control
Shift
+
Delete selected column or row
Ctrl

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
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

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

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

Free Course – Excel Efficiency Essentials