Cheat sheet guide
Excel shortcuts worth learning first
This page collects 29 searchable Excel keyboard shortcuts across 5 categories. Start with the shortcuts for Workbook & Files, Navigation, Editing, Formulas, then print the cheat sheet once the important ones are worth keeping nearby.
- Create new workbookCtrlN
- Move one cell up↑
- Edit active cellF2
- Start formula=
- BoldCtrlB
- Open workbookCtrlO
Workbook & Files
5 shortcuts
Create new workbook
CtrlN
WinCtrlNMac⌘N
Open workbook
CtrlO
WinCtrlOMac⌘O
Save workbook
CtrlS
WinCtrlSMac⌘S
Print workbook
CtrlP
WinCtrlPMac⌘P
Close workbook
CtrlW
WinCtrlWMac⌘W
Navigation
7 shortcuts
Move one cell up
↑
Win↑Mac↑
Move one cell down
↓
Win↓Mac↓
Move to edge of data region
CtrlArrow
WinCtrlArrowMac⌘Arrow
Go to cell A1
CtrlHome
WinCtrlHomeMacFnCtrl←
Go to last used cell
CtrlEnd
WinCtrlEndMacFnCtrl→
Next worksheet
CtrlPageDown
WinCtrlPageDownMacFnCtrl↓
Previous worksheet
CtrlPageUp
WinCtrlPageUpMacFnCtrl↑
Editing
7 shortcuts
Edit active cell
F2
WinF2MacCtrlU
Fill down
CtrlD
WinCtrlDMac⌘D
Fill right
CtrlR
WinCtrlRMac⌘R
Insert current date
Ctrl;
WinCtrl;MacCtrl;
Insert current time
CtrlShift;
WinCtrlShift;Mac⌘;
Undo
CtrlZ
WinCtrlZMac⌘Z
Redo
CtrlY
WinCtrlYMac⌘Y
Formulas
5 shortcuts
Start formula
=
Win=Mac=
AutoSum
Alt=
WinAlt=Mac⌘⇧T
Show formulas
Ctrl`
WinCtrl`MacCtrl`
Calculate worksheets
F9
WinF9MacF9
Insert function
ShiftF3
WinShiftF3MacShiftF3
Formatting
5 shortcuts
Bold
CtrlB
WinCtrlBMac⌘B
Italic
CtrlI
WinCtrlIMac⌘I
Underline
CtrlU
WinCtrlUMac⌘U
Format cells dialog
Ctrl1
WinCtrl1Mac⌘1
Apply percent format
CtrlShift%
WinCtrlShift%Mac⌃⇧%
Frequently asked questions
What is the fastest way to find Excel shortcuts on this page?
Use the search box or press /, then type an action such as create new workbook.
Can I print this Excel shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for Excel?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, Create new workbook is Ctrl+N on Windows and ⌘N on macOS where available.
