Excel Shortcut Reference

All 66 shortcuts · Mac/Windows

Complete coverage from Ctrl+C, Ctrl+V, F2 to advanced shortcuts. Boost your Excel efficiency.

Pair shortcut learning with formulas usingfunction listandfunction practice mode.

New Workbook

Ctrl+N
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Create a new Excel workbook.

Open Workbook

Ctrl+O
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Open an existing workbook.

Save

Ctrl+S
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Save the current workbook.

Save As

F12
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Save a copy with a new file name.

Print

Ctrl+P
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Open the print preview and print settings.

Close Workbook

Ctrl+W
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Close the current workbook.

Copy

Ctrl+C
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Copy the selected cells or range.

Cut

Ctrl+X
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Cut the selected cells or range.

Paste

Ctrl+V
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Paste the copied or cut content.

Paste Special

Ctrl+Alt+V
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Choose whether to paste values, formulas, formats, and more.

Fill Down

Ctrl+D
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Copy the cell above downward.

Fill Right

Ctrl+R
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Copy the cell on the left to the right.

Flash Fill

Ctrl+E
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Fill values automatically based on a detected pattern.

Undo

Ctrl+Z
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Undo the last action.

Redo

Ctrl+Y
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Redo an action that was undone.

Insert Current Date

Ctrl+;
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert the current date.

Edit Cell

F2
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Edit the active cell in place.

Clear Cell Contents

Delete
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Remove values or formulas while keeping the formatting.

AutoSum

Alt+=
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert a SUM formula automatically.

New Line in Cell

Alt+Enter
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert a line break within the same cell.

Insert/Edit Comment

Shift+F2
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert or edit a note/comment.

Repeat Last Action

F4
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Repeat the last action.

Insert Hyperlink

Ctrl+K
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert a hyperlink into the selected cell.

Insert Current Time

Ctrl+Shift+;
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert the current time.

Copy Formula

Ctrl+'
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Copy the formula from the cell above.

Toggle Formula View

Ctrl+`
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Toggle between values and displayed formulas.

Toggle Reference Type

F4
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Toggle relative and absolute references inside a formula.

Bold

Ctrl+B
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply bold formatting.

Italic

Ctrl+I
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply italic formatting.

Underline

Ctrl+U
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Underline text.

Format Cells Dialog

Ctrl+1
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Open the Format Cells dialog.

Number Format

Ctrl+Shift+1
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Number format.

Time Format

Ctrl+Shift+2
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Time format.

Date Format

Ctrl+Shift+3
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Date format.

Currency Format

Ctrl+Shift+4
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Currency format.

Percentage Format

Ctrl+Shift+5
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Percentage format.

Exponential Format

Ctrl+Shift+6
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Apply the Exponential format.

Insert Cells/Rows/Columns

Ctrl+Shift++
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert cells, rows, or columns at the selection.

Delete Cells/Rows/Columns

Ctrl+-
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Delete selected cells, rows, or columns.

Hide Row

Ctrl+9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Hide the selected row.

Hide Column

Ctrl+0
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Hide the selected column.

Unhide Row

Ctrl+Shift+9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Reveal hidden rows.

Unhide Column

Ctrl+Shift+0
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Reveal hidden columns.

Toggle AutoFilter

Ctrl+Shift+L
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Toggle AutoFilter on the current range.

Create Table

Ctrl+T
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Convert the selected range into an Excel table.

Open Filter Menu

Alt+
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Open a filter dropdown from the keyboard.

Select Current Region or Entire Sheet

Ctrl+A
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Select the current region, then the whole sheet when pressed again.

Move to Edge of Data

Ctrl+
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Jump to the edge of a contiguous data range.

Select to Edge of Data

Ctrl+Shift+
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Extend the selection to the edge of a contiguous range.

Select Entire Column

Ctrl+Space
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Select the entire column of the active cell.

Select Entire Row

Shift+Space
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Select the entire row of the active cell.

Move to Next Sheet

Ctrl+PgDn
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Move to the next worksheet tab.

Move to Previous Sheet

Ctrl+PgUp
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Move to the previous worksheet tab.

Extend Selection to Next Sheet

Ctrl+Shift+PgDn
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Extend the sheet selection to the next worksheet.

Extend Selection to Previous Sheet

Ctrl+Shift+PgUp
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Extend the sheet selection to the previous worksheet.

Go To

F5
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Jump to a specific cell or named range.

Find

Ctrl+F
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Search for text or values in the worksheet.

Replace

Ctrl+H
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Replace text or values in bulk.

Move Up Within Selection

Shift+Enter
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Move one cell up within the active selection.

Move Left Within Selection

Shift+Tab
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Move one cell left within the active selection.

Go to A1

Ctrl+Home
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Jump to cell A1.

Go to Last Used Cell

Ctrl+End
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Jump to the bottom-right cell of the used range.

Extend Selection to A1

Ctrl+Shift+Home
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Extend the selection from the active cell back to A1.

Extend Selection to Last Used Cell

Ctrl+Shift+End
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Extend the selection to the bottom-right of the used range.

Insert New Worksheet

Shift+F11
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Insert a new worksheet into the workbook.

Recalculate Workbook

F9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Recalculate the entire workbook.

Recalculate Sheet

Shift+F9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Recalculate the active worksheet.

Refresh All

Ctrl+Alt+F5
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Refresh all data connections and queries.

Create Embedded Chart

Alt+F1
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Z
X
C
V
B
N
M
,
.
/
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Del
PgUp
PgDn

Create an embedded chart from the selection.

Alt Techniques Common in Consulting and Banking

These Alt sequences are access keys rather than true shortcuts, but they show up constantly in real modeling work. They can change with ribbon configuration or Excel version.

Paste Values

Access Key

Strip formulas and keep only the visible values.

Primary sequence

Alt, E, S, V, Enter

Alternative

Ctrl+Alt+V, V, Enter

Where it helps: A default move before reviews, handoffs, and breaking external links.

Related shortcutsPaste SpecialPasteCopy

Paste Formulas

Access Key

Move formulas without bringing over the source formatting.

Primary sequence

Alt, E, S, F, Enter

Alternative

Ctrl+Alt+V, F, Enter

Where it helps: Useful when the destination already has the right layout and formatting.

Paste Formats

Access Key

Transfer formatting only while keeping destination values and formulas intact.

Primary sequence

Alt, E, S, T, Enter

Alternative

Ctrl+Alt+V, T, Enter

Where it helps: A fast way to standardize layout before sharing or reviewing a model.

AutoFit Column Width

Access Key

Resize selected columns to fit their contents instantly.

Primary sequence

Alt, H, O, I

Where it helps: A core clean-up move when making wide models review-ready.

AutoFit Row Height

Access Key

Quickly fix row height after wrapped text or notes change the layout.

Primary sequence

Alt, H, O, A

Where it helps: Especially useful for note-heavy schedules and comment columns.

Related shortcutsFormat Cells Dialog

Freeze Panes

Access Key

Keep key headers or columns visible while scrolling through large models.

Primary sequence

Alt, W, F, F

Where it helps: Makes review passes faster because context does not disappear while you scroll.

Related shortcutsToggle AutoFilterGo To

Insert Row

Access Key

Add rows without breaking flow or reaching for the mouse.

Primary sequence

Alt, I, R

Alternative

Ctrl+Shift++

Where it helps: Common when adding bridge rows, assumptions, or sensitivity blocks.

Insert Column

Access Key

Insert comparison or helper columns quickly from the keyboard.

Primary sequence

Alt, I, C

Alternative

Ctrl+Shift++

Where it helps: Useful when adding prior-year, variance, or notes columns.

Group Rows or Columns

Access Key

Collapse detail sections so reviewers can move between summary and detail quickly.

Primary sequence

Alt, D, G, G

Where it helps: Great for hiding support schedules while keeping the summary visible.

Ungroup Rows or Columns

Access Key

Remove outline groups when the structure has become noisy or outdated.

Primary sequence

Alt, D, G, U

Where it helps: Useful during cleanup after review cycles or model rebuilds.

Workflow habits worth adopting

Prefer Center Across Selection over Merge Cells

Merged cells often break sorting, references, and model maintenance.

  • Use `Ctrl+1` and alignment settings to keep the layout clean without breaking structure.
  • It is safer for later aggregation, lookups, and filters.
  • The difference matters more as more people review the workbook.

Default to Paste Values before handoff

Leaving live links in place invites broken references and accidental updates.

  • Before review, emailing, or deck export, decide whether the range should become values.
  • Separating formula ranges from value-only ranges reduces avoidable mistakes.
  • `Paste Special` is one of the highest-leverage habits to automate early.

Combine Freeze, AutoFit, and Group for review-ready sheets

A good model is not only correct; it is easy to review without friction.

  • Freeze headers so context stays visible while scrolling.
  • AutoFit away clipped columns before someone else reviews the sheet.
  • Use Group to switch cleanly between summary view and detail view.

Goal-Based Shortcut Paths

Whether you want to review shortcuts first or jump straight into drills, this page keeps both paths simple and immediate.

excel shortcut listexcel keyboard shortcutsexcel productivityexcel practice