Excel keyboard shortcuts (Windows and Mac)

File

Ctrl
N
N
Ctrl
O
O
Ctrl
S
S
F12
S
Ctrl
F4
W
Alt
F4
Q

General

F1
F1
Ctrl
Z
Z
Ctrl
Y
Y
Ctrl
Shift
L
F

Navigation

PgUp
Fn
PgDn
Fn
Alt
PgDn
Fn
Alt
PgUp
Fn
Ctrl
Backspace
Delete
Shift
Enter
Return
Enter
Return
Shift
Tab
Tab

Selection

Shift
Space
Space
Ctrl
Space
Space
Shift
click
click
Ctrl
Alt
Ctrl
Alt
Shift
F8
Fn
F8
Shift
Backspace
Delete
Shift
Enter
Return
Ctrl
Shift
Ctrl
Shift
Ctrl
Shift
Ctrl
Shift
Shift
PgUp
Fn
Shift
PgDn
Fn
Shift
Home
Fn
Ctrl
Shift
Home
Fn
Ctrl
Shift
End
Fn
Ctrl
Shift
*
Space
Ctrl
Shift
F3
F3

Advanced selection

Ctrl
Shift
O
Fn
O
Ctrl
/
/
Ctrl
\
\
Ctrl
Shift
|
|
Ctrl
Shift
{
{
Ctrl
Shift
}
}
Alt
;
Z

Copy, cut and paste

Ctrl
C
C
Ctrl
X
X
Ctrl
V
V
Ctrl
Alt
V
V
drag
drag
Ctrl
drag
drag
Shift
drag
drag
Ctrl
Shift
drag
drag
Ctrl
drag
drag

Editing cells

Esc
Esc
F2
U
Shift
F2
Fn
F2
Shift
Shift
Ctrl
Ctrl
Ctrl
Shift
Ctrl
Shift
Shift
Home
Fn
Shift
End
Fn
Ctrl
Delete
Delete
Backspace
Delete
Alt
Enter
Return

Entering data

Shift
Enter
Return
Shift
Tab
Tab
Ctrl
Enter
Return
Ctrl
K
K
Alt
Ctrl
E

Data formatting

Ctrl
Shift
~
~
Ctrl
Shift
$
$
Ctrl
Shift
%
%
Ctrl
Shift
^
^
Ctrl
Shift
!
!

Find and replace

Ctrl
F
F
Ctrl
H
H
Shift
F4
G
Ctrl
Shift
F4
G

Date and time

Ctrl
;
;
Ctrl
Shift
;
;
Ctrl
Shift
#
#
Ctrl
Shift
@
@

Dialog boxes

Shift
Tab
Tab
Ctrl
Tab
Tab
Ctrl
Shift
Tab
Tab
Enter
Return

Grid operations

Rows and columns

Ctrl
Shift
+
I
Ctrl
Shift
+
I
Ctrl
Shift
+
I
Ctrl
Ctrl
Ctrl
Ctrl
0
0
Ctrl
9
9
Ctrl
Shift
0
0
Ctrl
Shift
9
9
Alt
Shift
K
Alt
Shift
J
Alt
Shift
K
Alt
Shift
J

Table

Ctrl
T
T
Shift
Space
Space
Ctrl
Space
Ctrl
A
A

Visual formatting

Ctrl
B
B
Ctrl
I
I
Ctrl
U
U
Ctrl
5
X
Ctrl
Shift
&
0
Ctrl
Shift
_
_

Workbooks and worksheets

Shift
F11
F11
Ctrl
PgDn
Fn
Ctrl
PgUp
Fn
Shift
F6
F6
Ctrl
Tab
Tab
Ctrl
Shift
Tab
Tab
Shift
click
click
Ctrl
click
click

Pivot tables

Space
Space
Alt
Shift
K
Alt
Shift
J
Ctrl
Ctrl

Other

Shift
F7
F7
Alt
F8
Fn
F8
Alt
F11
Fn
F11
Alt
Ctrl
6
6
Alt
L
Shift
F10
Fn
F10
Alt
Space
?