Excel Windows Shortcuts

114 shortcuts · View all OS →

WindowsmacOSCompare all
Excel Windows keyboard shortcuts
ActionWindows Shortcut
Workbook & Files
Create new workbookCtrlN
Open workbookCtrlO
Save workbookCtrlS
Print workbookCtrlP
Close workbookCtrlW
Open workbook statisticsCtrlShiftG
Open the macro managerAltF8
Open the VBA editorAltF11
Navigation
Move one cell up↑
Move one cell down↓
Move to edge of data regionCtrlArrow
Go to cell A1CtrlHome
Go to last used cellCtrlEnd
Next worksheetCtrlPageDown
Previous worksheetCtrlPageUp
Move to the previous cell or controlShiftTab
Move one cell left←
Move one cell right→
Select through the last used cellCtrlShiftEnd
Scroll down one screenPageDown
Scroll right one screenAltPageDown
Scroll up one screenPageUp
Scroll left one screenAltPageUp
Move to the next cell or controlTab
Leave floating-shape navigationEsc
Zoom in on the worksheetCtrlAlt=
Zoom out on the worksheetCtrlAlt-
Cycle object display modesCtrl6
Show or hide outline symbolsCtrl8
Add the next worksheet to the selectionCtrlShiftPageDown
Add the previous worksheet to the selectionCtrlShiftPageUp
Toggle extend-selection modeF8
Add a separate range to the selectionShiftF8
Select the entire columnCtrlSpace
Select the entire rowShiftSpace
Select all worksheet objectsCtrlShiftSpace
Select through the start of the worksheetCtrlShiftHome
Select the current data regionCtrlShift8
Editing
Edit active cellF2
Fill downCtrlD
Fill rightCtrlR
Insert current dateCtrl;
Insert current timeCtrlShift;
UndoCtrlZ
RedoCtrlY
Cut selected cellsCtrlX
Copy selected cellsCtrlC
Paste into selected cellsCtrlV
Open cell validation choicesAlt↓
Add or edit a cell noteShiftF2
Add or reply to a threaded commentCtrlShiftF2
Insert blank cellsCtrlShift+
Delete selected cellsCtrl-
Open Paste SpecialCtrlAltV
Insert a hyperlinkCtrlK
Check worksheet spellingF7
Open Quick Analysis for selected cellsCtrlQ
Create a table from cellsCtrlL
Paste Special dialog: all content and formattingA
Paste Special dialog: formulas onlyF
Paste Special dialog: values onlyV
Paste Special dialog: formatting onlyT
Paste Special dialog: comments and notesC
Paste Special dialog: validation settingsN
Paste Special dialog: all except bordersX
Paste Special dialog: column widthsW
Paste Special dialog: formulas and number formatsR
Paste Special dialog: values and number formatsU
Insert a line break inside a cellAltEnter
Fill the selection with the current entryCtrlEnter
Finish entry and move to the cell aboveShiftEnter
Cancel the current cell entryEsc
Finish entry and move to the cell belowEnter
Run Flash Fill for the current columnCtrlE
Copy the value from the cell aboveCtrlShift'
Create a chart inside the worksheetAltF1
Create a separate chart sheetF11
Open the Power Query editorAltF12
Stop an external-data refreshEsc
Refresh external data in this worksheetCtrlF5
Refresh external data in the workbookCtrlAltF5
Formulas
Start formula=
AutoSumAlt=
Show formulasCtrl`
Calculate worksheetsF9
Insert functionShiftF3
Copy the formula from the cell aboveCtrl'
Toggle formula-checking tipsCtrlAltP
Expand or collapse the formula barCtrlShiftU
Move to the end of formula-bar textCtrlEnd
Select formula-bar text through the endCtrlShiftEnd
Calculate only the active worksheetShiftF9
Force calculation of all open workbooksCtrlAltF9
Recheck dependencies and recalculate all cellsCtrlAltShiftF9
Open the formula-error options menuAltShiftF10
Open function arguments after a function nameCtrlA
Insert function argument namesCtrlShiftA
Cycle absolute and relative formula referencesF4
Open the list of defined namesF3
Formatting
BoldCtrlB
ItalicCtrlI
UnderlineCtrlU
Format cells dialogCtrl1
Apply percent formatCtrlShift%
Open font settings for cellsCtrlShiftF
Toggle strikethrough in cellsCtrl5
Add an outside cell borderCtrlShift7
Remove outside cell bordersCtrlShift-
Apply General number formattingCtrlShift`
Apply currency formattingCtrlShift4
Apply scientific number formattingCtrlShift6
Apply date formattingCtrlShift3
Apply time formattingCtrlShift2
Apply a two-decimal number formatCtrlShift1