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.
- Switch OS tabs for Windows, macOS, or Linux shortcuts.
- Use / to jump to search instantly.
- Use Compare mode when moving between machines.
- Print or save the page as a compact PDF cheat sheet.
Workbook & Files
5 shortcuts
Create new workbook
Ctrl+N
WinCtrl+N
Mac⌘N
Linux—
Open workbook
Ctrl+O
WinCtrl+O
Mac⌘O
Linux—
Save workbook
Ctrl+S
WinCtrl+S
Mac⌘S
Linux—
Print workbook
Ctrl+P
WinCtrl+P
Mac⌘P
Linux—
Close workbook
Ctrl+W
WinCtrl+W
Mac⌘W
Linux—
Navigation
7 shortcuts
Move one cell up
↑
Win↑
Mac↑
Linux—
Move one cell down
↓
Win↓
Mac↓
Linux—
Move to edge of data region
Ctrl+Arrow
WinCtrl+Arrow
Mac⌘Arrow
Linux—
Go to cell A1
Ctrl+Home
WinCtrl+Home
MacFn+Ctrl+←
Linux—
Go to last used cell
Ctrl+End
WinCtrl+End
MacFn+Ctrl+→
Linux—
Next worksheet
Ctrl+PageDown
WinCtrl+PageDown
MacFn+Ctrl+↓
Linux—
Previous worksheet
Ctrl+PageUp
WinCtrl+PageUp
MacFn+Ctrl+↑
Linux—
Editing
7 shortcuts
Edit active cell
F2
WinF2
MacCtrl+U
Linux—
Fill down
Ctrl+D
WinCtrl+D
Mac⌘D
Linux—
Fill right
Ctrl+R
WinCtrl+R
Mac⌘R
Linux—
Insert current date
Ctrl+;
WinCtrl+;
MacCtrl+;
Linux—
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;
Mac⌘;
Linux—
Undo
Ctrl+Z
WinCtrl+Z
Mac⌘Z
Linux—
Redo
Ctrl+Y
WinCtrl+Y
Mac⌘Y
Linux—
Formulas
5 shortcuts
Start formula
=
Win=
Mac=
Linux—
AutoSum
Alt+=
WinAlt+=
Mac⌘⇧T
Linux—
Show formulas
Ctrl+`
WinCtrl+`
MacCtrl+`
Linux—
Calculate worksheets
F9
WinF9
MacF9
Linux—
Insert function
Shift+F3
WinShift+F3
MacShift+F3
Linux—
Formatting
5 shortcuts
Bold
Ctrl+B
WinCtrl+B
Mac⌘B
Linux—
Italic
Ctrl+I
WinCtrl+I
Mac⌘I
Linux—
Underline
Ctrl+U
WinCtrl+U
Mac⌘U
Linux—
Format cells dialog
Ctrl+1
WinCtrl+1
Mac⌘1
Linux—
Apply percent format
Ctrl+Shift+%
WinCtrl+Shift+%
Mac⌃⇧%
Linux—
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.
Advertisement