Excel keyboard shortcuts for Mac
60 shortcuts · Updated
These are the default Microsoft Excel keyboard shortcuts on macOS, curated from the Mac section of Microsoft's official reference - Windows bindings differ, so don't mix them up. Excel for Mac also accepts many Windows-style Ctrl combos alongside the Cmd versions shown here. On a MacBook keyboard, Home, End, and the Page keys are Fn plus an arrow, and the function-key shortcuts (F2, F9) may need Fn unless you enable standard function keys in System Settings.
Nothing matches - try fewer letters, or an action word like "close" or "split".
Or stop looking them up. Super Shortcuts puts the Excel commands you actually use one hyper key away: hold it, see every command for the app you're in, release a key to run it. No memorizing - the cheat sheet is the shortcut.
Get Super ShortcutsFrequently used10
| Shortcut | Action |
|---|---|
| Command S⌘S | Save the workbook |
| Command Z⌘Z | Undo the last action |
| Command Y⌘Y | Redo the last action |
| Command Control V⌘⌃V | Open the Paste Special dialog |
| Command F⌘F | Search in the sheet |
| Control H⌃H | Open the Replace dialog |
| Command 1⌘1 | Open the Format Cells dialog |
| Control G⌃G | Open the Go To dialog |
| Command A⌘A | Select the current region or the entire sheet |
| Command Shift F⌘⇧F | Add or remove a filter |
Navigation7
| Shortcut | Action |
|---|---|
| Command Down Arrow⌘↓ | Jump to the edge of the current data region (works with any arrow) |
| Control Home⌃↖ | Move to the beginning of the sheet |
| Control End⌃↘ | Move to the last used cell on the sheet |
| Page Down⇟ | Move down one screen |
| Page Up⇞ | Move up one screen |
| Control Page Down⌃⇟ | Move to the next sheet (Opt Right also works) |
| Control Page Up⌃⇞ | Move to the previous sheet (Opt Left also works) |
Selection6
| Shortcut | Action |
|---|---|
| Shift Down Arrow⇧↓ | Extend the selection by one cell (works with any arrow) |
| Command Shift Down Arrow⌘⇧↓ | Extend the selection to the last nonblank cell (works with any arrow) |
| Control Space⌃Space | Select the entire column |
| Shift Space⇧Space | Select the entire row |
| Control Shift Home⌃⇧↖ | Extend the selection to the beginning of the sheet |
| Control Shift End⌃⇧↘ | Extend the selection to the last used cell |
Entering & editing data12
| Shortcut | Action |
|---|---|
| F2F2 | Edit the selected cell |
| Return↩ | Complete the entry and move down |
| Shift Return⇧↩ | Complete the entry and move up |
| Tab⇥ | Complete the entry and move right |
| Shift Tab⇧⇥ | Complete the entry and move left |
| Escape⎋ | Cancel the cell entry |
| Option Return⌥↩ | Start a new line inside the same cell |
| Command Return⌘↩ | Fill the selected range with the current entry |
| Control D⌃D | Fill down |
| Control R⌃R | Fill right |
| Control ;⌃; | Enter today's date |
| Command ;⌘; | Enter the current time |
Formulas8
| Shortcut | Action |
|---|---|
| == | Start a formula |
| F4F4 | Toggle absolute and relative references in a formula |
| Command Shift T⌘⇧T | Insert the AutoSum formula |
| Shift F3⇧F3 | Open the Formula Builder |
| Control `⌃` | Toggle between showing cell values and formulas |
| F9F9 | Calculate all open workbooks (Cmd = also works) |
| Shift F9⇧F9 | Calculate the active sheet |
| Command Shift Return⌘⇧↩ | Enter the formula as an array formula |
Formatting9
| Shortcut | Action |
|---|---|
| Command B⌘B | Apply or remove bold |
| Command I⌘I | Apply or remove italic |
| Command U⌘U | Apply or remove underline |
| Command Shift X⌘⇧X | Apply or remove strikethrough |
| Control Shift $⌃⇧$ | Apply the currency format with two decimal places |
| Control Shift %⌃⇧% | Apply the percentage format with no decimal places |
| Control Shift #⌃⇧# | Apply the date format (day, month, year) |
| Control Shift @⌃⇧@ | Apply the time format (hour, minute, AM/PM) |
| Control Shift !⌃⇧! | Apply the number format with two decimals and a thousands separator |
Rows & columns8
| Shortcut | Action |
|---|---|
| Control Shift =⌃⇧= | Insert cells |
| Command -⌘- | Delete cells |
| Control 9⌃9 | Hide the selected rows |
| Control Shift (⌃⇧( | Unhide the selected rows |
| Control 0⌃0 | Hide the selected columns |
| Control Shift )⌃⇧) | Unhide the selected columns |
| Command Shift K⌘⇧K | Group the selected cells |
| Command Shift J⌘⇧J | Ungroup the selected cells |
Curated from the official Microsoft Office support: keyboard shortcuts in Excel (Mac section). Defaults only - shortcuts you've remapped will differ.
Frequently asked questions
Why don't F2 and other function keys work in Excel for Mac?
macOS reserves the top row for brightness and media by default. Either hold Fn with the function key, or turn on Use F1, F2, etc. keys as standard function keys in System Settings → Keyboard so Excel gets them directly.
Can I customize keyboard shortcuts in Excel for Mac?
Yes - go to Tools → Customize Keyboard in Excel to assign or change shortcuts for any command. Excel warns you if the combination is already in use.
What is the most important Excel shortcut to learn first?
Learn ⌘ arrow and ⌘⇧ arrow to jump to and select the edges of a data range - they replace endless scrolling. After that, ⌘1 (Format Cells) and ⌘⇧T (AutoSum) pay off daily.