Keyboard shortcuts are the fastest way to level up your Excel productivity. Memorising even 10 of these will save you hours every week. Here are the 30 most impactful shortcuts, grouped by category.
Navigation
Shortcut
Action
Ctrl+Home
Jump to cell A1
Ctrl+End
Jump to last used cell
Ctrl+Arrow
Jump to edge of data region
Ctrl+G
Go To — navigate to specific cell or range
Ctrl+Page Up/Down
Switch between worksheet tabs
Selection
Shortcut
Action
Ctrl+Shift+Arrow
Select to edge of data region
Ctrl+Space
Select entire column
Shift+Space
Select entire row
Ctrl+A
Select all (or current data region)
Ctrl+Shift+End
Select from current cell to last used cell
Editing
Shortcut
Action
F2
Edit active cell
Ctrl+D
Fill down (copy cell above)
Ctrl+R
Fill right (copy cell to the left)
Ctrl+Enter
Enter value in all selected cells
Ctrl+Z / Ctrl+Y
Undo / Redo
Ctrl+;/code>
Insert today's date
Ctrl+Shift+;
Insert current time
Formatting
Shortcut
Action
Ctrl+1
Open Format Cells dialog
Ctrl+B / I / U
Bold / Italic / Underline
Ctrl+Shift+$
Currency format
Ctrl+Shift+%
Percentage format
Alt+H+O+I
Auto-fit column width
Formulas
Shortcut
Action
F4
Toggle absolute/relative reference ($)
Ctrl+`
Show/hide all formulas
Alt+=
Auto-SUM selected range
Ctrl+Shift+Enter
Enter array formula (legacy)
Tab
Accept formula autocomplete suggestion
Workbook & Data
Shortcut
Action
Ctrl+T
Create Table from selection
Ctrl+E
Flash Fill
Alt+F5
Refresh pivot tables and data connections
How to Memorise These
Don't try to learn all 30 at once. Pick 5 that match your daily workflow, use them for a week until they're muscle memory, then add 5 more. In six weeks, you'll be noticeably faster.
Liked this? Get better.
The Excel Guide with AI Integration takes you from formulas to production-grade projects.
