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
ShiftF4
G
CtrlShiftF4
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
ShiftClick
Click

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
CtrlE

Formatting

AltHAC
E
AltHAL
L
AltHAR
R
AltH6
Tab
AltH5
Tab

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

Workbook

ShiftF11
F11
CtrlPgDn
Fn
CtrlPgUp
Fn
ShiftF6
F6
CtrlTab
Tab
CtrlShiftTab
Tab
ShiftClick
Click
CtrlClick
Click

Dialog boxes

ShiftTab
Tab
CtrlTab
Tab
CtrlShiftTab
Tab
Enter
Return
Space
Space

Other

AltF8
FnF8
AltF11
FnF11
CtrlD
D
Alt
ShiftF10
FnF10
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel 101 basic training video course
Excel formulas and functions video training course