Skip to content

↑↓ moveEnter openEsc close

Excel keyboard shortcuts for Windows

Excel Microsoft 365 · 119 shortcuts · checked Nov 2026 · Source: Microsoft docs

119 default Excel shortcuts on Windows, grouped by task.

119 shortcuts
Keys:

Frequently used

29 shortcuts
ActionKeys
Close a workbookCtrlW
Open a workbookCtrlO
Create a new workbookCtrlN
Save a workbookCtrlS
Save AsF12
PrintCtrlP
Copy selectionCtrlC
Cut selectionCtrlX
Paste selectionCtrlV
Open the Paste Special dialogCtrlAltV
Undo the last actionCtrlZ
Redo the last action, or repeat itCtrlYorF4
Remove cell contentsDelete
Apply or remove boldCtrlBorCtrl2
Apply or remove italicCtrlIorCtrl3
Apply or remove underlineCtrlUorCtrl4
Apply or remove strikethroughCtrl5
Center align cell contentsAltH,A,C
Open the context menuShiftF10
Hide the selected rowsCtrl9
Hide the selected columnsCtrl0
Unhide hidden rows within the selectionCtrlShift9
Unhide hidden columns within the selectionCtrlShift0
Open the Find dialogCtrlForShiftF5
Open the Find and Replace dialog on the Replace tabCtrlH
Find nextShiftF4
Check spellingF7
Create a table from the selected rangeCtrlTorCtrlL

Navigate

16 shortcuts
ActionKeys
Move to the previous cell in a worksheet or the previous option in a dialogShiftTab
Move one cell to the rightTab
Move to the edge of the current data regionCtrl→
Move to the last cell on a worksheet (lowest used row, rightmost used column)CtrlEnd
Move to the beginning of a worksheetCtrlHome
Move to the beginning of the rowHome
Move one screen downPageDown
Move one screen upPageUp
Move one screen to the rightAltPageDown
Move one screen to the leftAltPageUp
Move to the next sheet in a workbookCtrlPageDown
Move to the previous sheet in a workbookCtrlPageUp
Open the Go To dialogCtrlGorF5
Switch between the worksheet, ribbon, task pane and zoom controlsF6
Open the list of validation choices on a cell that has oneAlt↓
Move to the Name BoxAltF3

Select

17 shortcuts
ActionKeys
Select the entire worksheetCtrlA
Select the current region around the active cellCtrlShift8
Select the entire columnCtrlSpace
Select the entire rowShiftSpace
Extend the selection by one cellShift→
Extend the selection to the last nonblank cell in the same row or columnCtrlShift→
Extend the selection to the beginning of the rowShiftHome
Extend the selection to the beginning of the worksheetCtrlShiftHome
Extend the selection to the last used cell on the worksheetCtrlShiftEnd
Extend the selection down one screenShiftPageDown
Turn extend mode on or off (use arrow keys to extend the selection)F8
Add a nonadjacent cell or range to the selectionShiftF8
Select the current arrayCtrl/
Select only the visible cells in the current selectionAlt;
Select cells in a row that don't match the active cellCtrl\
Select cells directly referred to by the formula in the active cellCtrl[
Select cells that contain formulas referring directly to the active cellCtrl]

Format cells

16 shortcuts
ActionKeys
Open the Format Cells dialogCtrl1
Apply the General number formatCtrlShift`
Apply the Currency format with two decimal placesCtrlShift4
Apply the Percentage format with no decimal placesCtrlShift5
Apply the Scientific number format with two decimal placesCtrlShift6
Apply the Date format with day, month and yearCtrlShift3
Apply the Time format with hour, minute and AM or PMCtrlShift2
Apply the Number format with two decimal places, thousands separator and minus signCtrlShift1
Apply an outline border to the selected cellsCtrlShift7
Remove the outline border from the selected cellsCtrlShift-
Switch between hiding objects, displaying objects and displaying placeholdersCtrl6
Display or hide the outline symbolsCtrl8
Open the Insert dialog to insert blank cellsCtrlShift+
Open the Delete dialog to delete selected cellsCtrl-
Group the selected rows or columnsAltShift→
Ungroup the selected rows or columnsAltShift←
ActionKeys
Edit the active cell and put the insertion point at the end of its contentsF2
Start a new line in the same cellAltEnter
Fill the selected cell range with the current entryCtrlEnter
Complete a cell entry and select the cell aboveShiftEnter
Cancel an entry in the cell or formula barEsc
Insert or edit a noteShiftF2
Enter the current dateCtrl;
Enter the current timeCtrlShift;
Switch between displaying cell values and displaying formulasCtrl`
Copy the formula from the cell above into the active cell or formula barCtrl'
Fill Down: copy the top cell of the selection into the cells belowCtrlD
Fill Right: copy the leftmost cell of the selection into the cells to the rightCtrlR
Use Flash Fill to recognize patterns and fill the columnCtrlE
Open the Insert Function dialogShiftF3
Insert the AutoSum formulaAlt=
Cycle through absolute and relative references in a formulaEditing a cell referenceF4
Expand or collapse the formula barCtrlShiftU
Calculate all worksheets in all open workbooksF9
Calculate the active worksheetShiftF9
Enter a formula as an array formulaCtrlShiftEnter
Insert argument names and parentheses when the insertion point is right of a function nameCtrlShiftA
Define a name for the selectionCtrlF3
Create names from row and column labelsCtrlShiftF3
Paste a defined name into a formulaF3
ActionKeys
Turn AutoFilter on or off for the selected rangeCtrlShiftL
Open the Quick Analysis options for selected cellsCtrlQ
Insert a new worksheetShiftF11
Create a chart of the data in the current range in a separate chart sheetF11
Create an embedded chart of the data in the current rangeAltF1
Freeze panesAltW,F,F
Open the Macro dialogAltF8
Open the Visual Basic for Applications editorAltF11
Select all objects on a worksheet when an object is selectedCtrlShiftSpace
ActionKeys
Switch to the next workbook windowCtrlF6orCtrlTab
Switch to the previous workbook windowCtrlShiftF6orCtrlShiftTab
Minimize the workbook windowCtrlF9
Maximize or restore the workbook windowCtrlF10
Toggle full screenCtrlShiftF1
Go to the Home tab on the ribbonAltH
Open the Help paneF1

These are the default Microsoft Excel key bindings on Windows, from Microsoft's official list for version Microsoft 365. Shortcuts that exist only on another system are left out here; the all-systems view shows every binding side by side.

Other systems: Excel shortcuts for Mac. Or print the Excel cheat sheet.