219 Excel keyboard shortcuts for PC and Mac

Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. On Macs, you generally need to use the Fn key for certain shortcuts, as shown below.

Displaying 1 - 219 of 219

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:
:
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
CtrlAltF9
F9
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

Laminated quick-reference cards

Excel has a ton of shortcuts that can save you time. These quick reference cards are printed in color and list over 200 Excel shortcuts for both Windows and Mac.

  • Printed in color on 10 pt. card stock with a matte finish
  • Laminated and non-laminated versions available
  • Color-coded, with Windows and Mac side-by-side
  • No batteries or WIFI required

Learn more