Exceljet

Quick, clean, and to the point

222 Excel keyboard shortcuts for PC and Mac

Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. See also: The 54 Excel shortcuts you really should know and How to use Mac function keys with Excel.

File

CtrlN
N
CtrlO
O
CtrlS
S
F12
S
CtrlP
P
AltF4
Q

Ribbon

CtrlF1
R
Enter
Return

General

F1
/
CtrlZ
Z
CtrlY
Y
CtrlC
C
CtrlX
X
CtrlShiftF4
G
ShiftF4
G
AltF1
FnF1
CtrlShiftL
F
Alt
CtrlT
T
ShiftSpace
Space
CtrlSpace
Space
CtrlA
A

Drag and Drop

drag
drag
Ctrldrag
drag
Shiftdrag
drag
CtrlShiftdrag
drag
Altdrag
drag
Ctrldrag
drag

Navigation

AltPgDn
Fn
AltPgUp
Fn
PgUp
Fn
End
Fn

Selection

ShiftSpace
Space
CtrlSpace
Space

Active Cell

ShiftBackspace
Delete
CtrlBackspace
Delete
ShiftEnter
Return

Extend Selection

ShiftPgUp
Fn

Select Special

CtrlShiftO
FnO
CtrlShift|
|
CtrlShift{
{
CtrlShift}
}

Cell edit mode

ShiftF2
FnF2
Esc
Esc
Shift
Shift
Ctrl
Ctrl
CtrlShift
CtrlShift
ShiftHome
Fn
ShiftEnd
Fn
CtrlDelete
Delete
AltEnter
Return

Entering data

Enter
Return
ShiftEnter
Return
ShiftTab
Tab
CtrlEnter
Return
Ctrl;
;
CtrlShift:
:
CtrlShift"
"
CtrlK
K

Formatting

AltHAC
E
AltHAL
L
AltHAR
R
 
M
 
M

Number Formatting

CtrlShift~
~
CtrlShift$
$
CtrlShift%
%
CtrlShift^
^
CtrlShift#
#
CtrlShift@
@
CtrlShift!
!

Borders

CtrlShift&
0
AltL
AltT
CtrlShift_
_

Formulas

Alt=
T
CtrlShiftA
A
CtrlShiftEnter
Return
ShiftF9
FnF9
CtrlF3
L

Grid Operations

CtrlShift+
I
CtrlShift+
I
CtrlShift+
I
Ctrl-
-
Ctrl-
-
Ctrl-
-
Ctrl0
0
Ctrl9
9
CtrlShift9
9
CtrlShift0
0
AltShift
K
AltShift
J
AltShift
K
AltShift
J

Pivot Tables

AltShift
K
AltShift
J
Ctrl-
Ctrl-

Workbook

ShiftF11
F11
CtrlPgDn
Fn
CtrlPgUp
Fn
ShiftF6
F6
CtrlTab
Tab
CtrlShiftTab
Tab

Dialog boxes

ShiftTab
Tab
CtrlTab
Tab
CtrlShiftTab
Tab
Enter
Return
Space
Space

Other

AltF8
FnF9
AltF11
FnF11
CtrlD
D
Alt