Excel shortcuts · printable
Excel shortcuts cheat sheet: Windows and Mac
114 shortcuts that work on both Windows and Mac, the most useful first in each group. Windows keys first, Mac second. Mac keys: Cmd ⌘, Option ⌥, Control ⌃. Laptops may need Fn for F-keys.
Ctrl+P (Cmd+P on a Mac), then "Save as PDF" for a file.
Essentials
- Find and replaceWindows: Ctrl+HMac: Control+H
- Go to a cell or range (Go To)Windows: Ctrl+GMac: Control+G
- Copy the selectionWindows: Ctrl+CMac: Command+C
- Cut the selectionWindows: Ctrl+XMac: Command+X
- PasteWindows: Ctrl+VMac: Command+V
- Undo the last actionWindows: Ctrl+ZMac: Command+Z
- RedoWindows: Ctrl+YMac: Command+Y
- Save the workbookWindows: Ctrl+SMac: Command+S
- FindWindows: Ctrl+FMac: Control+F
- Clear contents (keep formats)Windows: DeleteMac: Delete
- Open the right-click (context) menuWindows: Shift+F10Mac: Shift+F10
- Open a workbookWindows: Ctrl+OMac: Command+O
- Create a new blank workbookWindows: Ctrl+NMac: Command+N
- Close the workbook windowWindows: Ctrl+WMac: Command+W
- Print or preview the workbookWindows: Ctrl+PMac: Command+P
Navigating
- Jump to the edge of the dataWindows: Ctrl+an arrow keyMac: Command+an arrow key
- Go to the last used cell on the sheetWindows: Ctrl+EndMac: Control+End
- Go to the next sheetWindows: Ctrl+Page DownMac: Control+Page Down
- Go to the beginning of the sheet (A1)Windows: Ctrl+HomeMac: Control+Home
- Go to the previous sheetWindows: Ctrl+Page UpMac: Control+Page Up
- Move one cell up, down, left or rightWindows: an arrow keyMac: an arrow key
- Go to the beginning of the rowWindows: HomeMac: Home
- Move one screen downWindows: Page DownMac: Page Down
- Move one screen upWindows: Page UpMac: Page Up
- Move one screen to the rightWindows: Alt+Page DownMac: Option+Page Down
- Move one screen to the leftWindows: Alt+Page UpMac: Option+Page Up
- Move between unlocked cells on a protected sheetWindows: TabMac: Tab
- Scroll sideways with the mouse wheelWindows: Ctrl+ShiftMac: Shift
Selecting
- Select to the edge of the dataWindows: Ctrl+Shift+an arrow keyMac: Shift+Command+an arrow key
- Select the entire columnWindows: Ctrl+SpaceMac: Control+Space
- Select the entire rowWindows: Shift+SpaceMac: Shift+Space
- Select region, then sheetWindows: Ctrl+AMac: Command+A
- Extend the selection by one cellWindows: Shift+an arrow keyMac: Shift+an arrow key
- Turn extend mode on or off (arrows extend the selection)Windows: F8Mac: F8
- Add another range to the selectionWindows: Shift+F8Mac: Shift+F8
- Extend the selection to the beginning of the sheetWindows: Ctrl+Shift+HomeMac: Control+Shift+Home
- Extend the selection to the last used cellWindows: Ctrl+Shift+EndMac: Control+Shift+End
Editing cells
- Edit the active cellWindows: F2Mac: F2
- Start a new line inside the cellWindows: Alt+EnterMac: Option+Return
- Cancel the entryWindows: EscMac: Esc
- Insert or edit a noteWindows: Shift+F2Mac: Shift+F2
- Threaded commentWindows: Ctrl+Shift+F2Mac: Command+Shift+F2
- Delete the character to the left (or clear the cell and start editing)Windows: BackspaceMac: Delete
- While editing, delete the character to the rightWindows: DeleteMac: Forward Delete
- Insert a hyperlinkWindows: Ctrl+KMac: Command+K
- Post the comment you typedWindows: Ctrl+EnterMac: Command+Return
- Check spellingWindows: F7Mac: F7
Entering data and filling
- Same entry in every selected cellWindows: Ctrl+EnterMac: Command+Return
- Fill down from the cell aboveWindows: Ctrl+DMac: Command+D
- Fill right from the cell to the leftWindows: Ctrl+RMac: Command+R
- Flash FillWindows: Ctrl+EMac: Control+E
- Enter today's dateWindows: Ctrl+;Mac: Control+;
- Confirm the entry and move downWindows: EnterMac: Return
- Enter the current timeWindows: Ctrl+Shift+;Mac: Command+;
- Confirm the entry and move upWindows: Shift+EnterMac: Shift+Return
- Confirm the entry and move rightWindows: TabMac: Tab
- Confirm the entry and move leftWindows: Shift+TabMac: Shift+Tab
- Copy the formula from the cell above, unchangedWindows: Ctrl+'Mac: Control+'
- Copy the value from the cell aboveWindows: Ctrl+Shift+"Mac: Control+Shift+"
Formulas and references
- Cycle the $ signs in a referenceWindows: F4Mac: Command+T
- AutoSum the cells above or to the leftWindows: Alt+=Mac: Shift+Command+T
- Show formulasWindows: Ctrl+`Mac: Control+`
- Insert a functionWindows: Shift+F3Mac: Shift+F3
- Calculate all open workbooksWindows: F9Mac: F9
- After typing a function name, open its argumentsWindows: Ctrl+AMac: Control+A
- Enter a legacy array formula (CSE)Windows: Ctrl+Shift+EnterMac: Shift+Command+Return
- Calculate the active sheetWindows: Shift+F9Mac: Shift+F9
- Calculate everything, changed or notWindows: Ctrl+Alt+F9Mac: Control+Option+F9
- Recheck dependent formulas, then calculate every cellWindows: Ctrl+Alt+Shift+F9Mac: Control+Option+Shift+F9
- Turn formula-checking tooltips on or offWindows: Ctrl+Alt+PMac: Control+Option+P
- Expand or collapse the formula barWindows: Ctrl+Shift+UMac: Control+Shift+U
- Define a nameWindows: Alt+M, M, DMac: Control+L
- Create names from the labels in a selectionWindows: Ctrl+Shift+F3Mac: Command+Shift+F3
Formatting
- Open Format CellsWindows: Ctrl+1Mac: Command+1
- BoldWindows: Ctrl+BMac: Command+B
- ItalicWindows: Ctrl+IMac: Command+I
- UnderlineWindows: Ctrl+UMac: Command+U
- StrikethroughWindows: Ctrl+5Mac: Shift+Command+X
- Number format (1,234.50)Windows: Ctrl+Shift+!Mac: Control+Shift+!
- Currency format with 2 decimalsWindows: Ctrl+Shift+$Mac: Control+Shift+$
- Percentage format with no decimalsWindows: Ctrl+Shift+%Mac: Control+Shift+%
- Date format with day, month and yearWindows: Ctrl+Shift+#Mac: Control+Shift+#
- Add an outline border around the selectionWindows: Ctrl+Shift+&Mac: Command+Option+0
- Remove the outline borderWindows: Ctrl+Shift+_Mac: Command+Option+-
- Center the cell contentsWindows: Alt+H, A, CMac: Command+E
- General number formatWindows: Ctrl+Shift+~Mac: Control+Shift+~
- Time format with hour, minute and AM/PMWindows: Ctrl+Shift+@Mac: Control+Shift+@
- Scientific format with 2 decimalsWindows: Ctrl+Shift+^Mac: Control+Shift+^
Rows, columns and sheets
- Insert cells, rows or columnsWindows: Ctrl+Shift+PlusMac: Control+Shift+=
- Delete cells, rows or columnsWindows: Ctrl+-Mac: Command+-
- Hide the selected rowsWindows: Ctrl+9Mac: Control+9
- Hide the selected columnsWindows: Ctrl+0Mac: Control+0
- Insert a new sheetWindows: Shift+F11Mac: Shift+F11
- Show or hide the outline symbolsWindows: Ctrl+8Mac: Control+8
- Move cells and insert them, instead of overwritingWindows: ShiftMac: Shift
Data, filters, tables and pivots
- Turn filters on or offWindows: Ctrl+Shift+LMac: Command+Shift+F
- Create a tableWindows: Ctrl+TMac: Command+T
- Open a drop-down or filter menuWindows: Alt+Down arrowMac: Option+Down arrow
- Open the Sort dialogWindows: Alt+A, S, SMac: Command+Shift+R
- Create a chart of the current data on its own chart sheetWindows: F11Mac: F11
- Open the Power Query EditorWindows: Alt+F12Mac: Option+F12
Dialogs and Paste Special
- Open Paste SpecialWindows: Ctrl+Alt+VMac: Command+Control+V
Workbooks, windows and panes
- Save AsWindows: F12Mac: Command+Shift+S
- Show or hide the ribbonWindows: Ctrl+F1Mac: Command+Option+R
- Switch panesWindows: F6Mac: F6
- Quit ExcelWindows: Alt+F4Mac: Command+Q
- Open Excel HelpWindows: F1Mac: F1
- Full screenWindows: Ctrl+Shift+F1Mac: Command+Control+F
- Minimize the workbook windowWindows: Ctrl+F9Mac: Control+F9
- Maximize or restore the workbook windowWindows: Ctrl+F10Mac: Control+F10
- Move between the panes in reverse orderWindows: Shift+F6Mac: Shift+F6
- Hide objects, show them, or show placeholdersWindows: Ctrl+6Mac: Control+6
- Open the Macro dialog (run, edit or delete macros)Windows: Alt+F8Mac: Option+F8
- Open the Visual Basic editorWindows: Alt+F11Mac: Option+F11
cellwise.app/excel-shortcuts · All 295 shortcuts, function keys, Ctrl A to Z and fixes online. Checked against Microsoft's lists on 2026-11-05.