Keyboard Shortcuts Reference
Master Your Keyboard
Stop reaching for the mouse. These essential shortcuts will save you hours every week.
Navigation
Ctrl+Home
Go to cell A1Ctrl+End
Go to last used cellCtrl+→
Jump to right edge of dataCtrl+←
Jump to left edge of dataCtrl+↑
Jump to top edge of dataCtrl+↓
Jump to bottom edge of dataCtrl+Page Up
Go to previous worksheetCtrl+Page Down
Go to next worksheetCtrl+G
Go to dialog (or F5)Selection
Ctrl+Shift+End
Select to last used cellCtrl+Shift+Home
Select to beginningShift+Space
Select entire rowCtrl+Space
Select entire columnCtrl+A
Select all (data region or sheet)Ctrl+Shift+→
Extend selection to right edgeCtrl+*
Select current region around active cellEditing
F2
Edit active cellEsc
Cancel editEnter
Confirm and move downTab
Confirm and move rightCtrl+Enter
Fill all selected cells with entryCtrl+D
Fill down (copy from above)Ctrl+R
Fill right (copy from left)Alt+Enter
New line within cellCtrl+Z
UndoCtrl+Y
RedoFormatting
Ctrl+B
BoldCtrl+I
ItalicCtrl+U
UnderlineCtrl+1
Format Cells dialogCtrl+Shift+$
Currency formatCtrl+Shift+%
Percentage formatCtrl+Shift+#
Date formatCtrl+Shift+@
Time formatCtrl+Shift+~
General formatAlt+H+O+I
Auto-fit column widthFormulas
F4
Toggle absolute/relative referenceCtrl+`
Show/hide formulasAlt+=
AutoSumCtrl+Shift+Enter
Array formula (legacy)Tab
Accept autocomplete suggestionCtrl+[
Go to precedent cellsCtrl+]
Go to dependent cellsF9
Calculate all workbooksData
Ctrl+T
Create TableCtrl+Shift+L
Toggle AutoFilterAlt+A+S+S
Sort ascendingAlt+A+S+D
Sort descendingAlt+N+V
Insert PivotTableCtrl+-
Delete cells/rows/columnsCtrl++
Insert cells/rows/columnsWorkbook
Ctrl+N
New workbookCtrl+O
Open workbookCtrl+S
SaveF12
Save AsCtrl+W
Close current workbookCtrl+P
PrintShift+F11
Insert new worksheetPro Tip: Build Muscle Memory
Pick 2-3 shortcuts to focus on each week. Every time you reach for the mouse, stop and use the shortcut instead. Within a month, they'll become second nature.
Explore More Tips