Danh sách phím tắt Excel

Tất cả 66 phím tắt · Mac/Windows

Bao phủ đầy đủ từ Ctrl+C, Ctrl+V, F2 đến các phím tắt nâng cao. Tăng hiệu suất làm việc với Excel.

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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
PgUp
PgDn

Insert a hyperlink into the selected cell.

Insert Current Time

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
Home
Del
End
PgUp
PgDn

Insert the current time.

Copy Formula from Cell Above

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
Home
Del
End
PgUp
PgDn

Copy the formula from the cell directly above into the active cell.

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
Home
Del
End
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
Home
Del
End
PgUp
PgDn

Toggle relative and absolute references inside a formula.

Insert Function

Shift+F3
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
Home
Del
End
PgUp
PgDn

Open the Insert Function dialog to search for and enter a function.

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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
PgUp
PgDn

Open the Format Cells dialog.

Apply Comma Style

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
Home
Del
End
PgUp
PgDn

Apply comma-separated number formatting to the selected cells.

Copy Value from Cell Above

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
Home
Del
End
PgUp
PgDn

Copy only the value from the cell above into the active cell.

Apply 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
Home
Del
End
PgUp
PgDn

Apply date formatting to the selected cells.

Apply 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
Home
Del
End
PgUp
PgDn

Apply currency formatting to the selected cells.

Apply 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
Home
Del
End
PgUp
PgDn

Apply percentage formatting to the selected cells.

Apply Outside Border

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
Home
Del
End
PgUp
PgDn

Apply an outside border to the selected range.

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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
PgUp
PgDn

Open a filter dropdown from the keyboard.

Select Visible Cells Only

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
Home
Del
End
PgUp
PgDn

Select only visible cells, excluding rows hidden by filters or grouping.

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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
PgUp
PgDn

Jump to cell A1.

Go to Last Row and Column 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
Home
Del
End
PgUp
PgDn

Jump to the cell at the last used row and last used column.

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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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
Home
Del
End
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

Apply All Borders

Access Key

Apply borders to every cell in the selected range for a clearer table structure.

Primary sequence

Alt, H, B, A

Where it helps: Useful for transfer tables, comparison grids, and checklists that need to become review-ready quickly.

Related shortcutsFormat Cells Dialog

Top and Thick Bottom Border

Access Key

Apply a top border and thick bottom border to emphasize totals and subtotals.

Primary sequence

Alt, H, B, C

Where it helps: Best for total rows, section endings, and financial model lines that should stop the reviewer’s eye.

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

View Excel Side by Side

Access Key

Place workbooks or workbook windows side by side for comparison and reference entry.

Primary sequence

Alt, W, N -> Win+Left / Win+Right

Alternative

Alt, W, B

Where it helps: For one workbook in two views, create a new window with Alt, W, N, then snap with Windows+Left/Right. For separate workbooks, View Side by Side with Alt, W, B is also useful.

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.

Lo trinh phim tat theo muc tieu

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