Skip to content

↑↓ moveEnter openEsc close

Excel for Mac keyboard shortcuts

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

109 default Excel shortcuts on Mac, grouped by task.

109 shortcuts
Keys:

Frequently used

29 shortcuts
ActionKeys
Close a workbookCmdW
Open a workbookCmdO
Create a new workbookCmdN
Save a workbookCmdS
Save AsShiftCmdS
PrintCmdP
Copy selectionCmdC
Cut selectionCmdX
Paste selectionCmdV
Open the Paste Special dialogCtrlCmdV
Undo the last actionCmdZ
Redo the last action, or repeat itCmdY
Remove cell contentsDelete
Apply or remove boldCmdB
Apply or remove italicCmdI
Apply or remove underlineCmdU
Apply or remove strikethroughShiftCmdX
Center align cell contentsCmdE
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 dialogCmdF
Open the Find and Replace dialog on the Replace tabCtrlH
Find nextCmdG
Check spellingF7
Create a table from the selected rangeCmdT

Navigate

15 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 rightOptionPageDown
Move one screen to the leftOptionPageUp
Move to the next sheet in a workbookCtrlPageDownorOption→
Move to the previous sheet in a workbookCtrlPageUporOption←
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 oneOption↓

Select

17 shortcuts
ActionKeys
Select the entire worksheetCmdA
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 columnShiftCmd→
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 selectionShiftCmdZ
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 dialogCmd1
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 cellsOptionCmd0
Remove the outline border from the selected cellsOptionCmd-
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 cellsCmd-
Group the selected rows or columnsShiftCmdK
Ungroup the selected rows or columnsShiftCmdJ
ActionKeys
Edit the active cell and put the insertion point at the end of its contentsCtrlUorF2
Start a new line in the same cellCtrlOptionEnterorOptionCmdEnter
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 timeCmd;
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 belowCmdD
Fill Right: copy the leftmost cell of the selection into the cells to the rightCmdR
Open the Insert Function dialogShiftF3
Insert the AutoSum formulaShiftCmdT
Cycle through absolute and relative references in a formulaEditing a cell referenceCmdTorF4
Expand or collapse the formula barCtrlShiftU
Calculate all worksheets in all open workbooksCmd=orF9
Calculate the active worksheetShiftCmd=orShiftF9
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
ActionKeys
Turn AutoFilter on or off for the selected rangeShiftCmdF
Insert a new worksheetShiftF11
Create a chart of the data in the current range in a separate chart sheetF11
Open the Macro dialogOptionF8
Open the Visual Basic for Applications editorOptionF11
Select all objects on a worksheet when an object is selectedShiftCmdSpace
ActionKeys
Switch to the next workbook windowCmd`
Switch to the previous workbook windowShiftCmd`
Minimize the workbook windowCmdM
Toggle full screenCtrlCmdF

These are the default Microsoft Excel key bindings on Mac, 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 Windows. Or print the Excel cheat sheet.