Excel shortcuts for Mac
For ease of viewing, shortcut keys for Excel for Mac are listed by usage. Mac cannot use the access keys available for Windows. Clicking on the To do this link will take you to a detailed page of the selected content.
Shortcut keys for Excel for Windows are available on a separate page.
Mac shortcut key list
| To do this | Mac key |
|---|---|
| Fill down | command + D |
| Insert cells | command + shift + + (plus) |
| Insert cut cells | command + shift + + (plus) |
| Cut value | command + X |
| Delete the characters of the active cell | delete |
| Delete character to the left | delete |
| Delete character to the right | fn + delete |
| Shift cells up | command + – (minus) |
| Open file | command + O |
| Close Excel | command + Q |
| Close active book | command + W |
| Row | |
| Insert row | command + shift + + (plus) |
| Insert multiple rows | command + shift + + (plus) |
| Insert row above | command + shift + + (plus) |
| Delete row | command + – (minus) |
| Delete blank row | command + – (minus) |
| Get the bottom of current row | command + ↓ (down arrow key) |
| Select by one cell to the left or right | shift + ← (left arrow) shift + → (right arrow) |
| Select entire row | shift + space |
| Extend select to start of row | command + shift + ← (left arrow) |
| Extend select to end of row | command + shift + → (right arrow) |
| Hide row | command + 9 |
| Unhide row | command + shift + 9 |
| Column | |
| Insert column | command + shift + + (plus) |
| Delete column | command + – (minus) |
| Select by one cell to the above or below | shift + ↑ (up arrow key) shift + ↓ (down arrow key) |
| Select to end of column | command + shift + ↓ (down arrow) |
| Select entire column with data | command + shift + ↑ (up arrow) command + shift + ↓ (down arrow) |
| Column selection by one screen | fn + ↑ (up arrow key) fn + ↓ (down arrow key) |
| Select cells that do not match the active cell | control + shift + | (vertical bar) |
| Hide column | command + 0 (zero) |
| Unhide column | command + shift + 0 (zero) |
| Unhide data in the same column | option + ↓ (down arrow key) |
| Sheet | |
| New sheet | shift + F11 |
| Select entire sheet | command + A |
| Select the current and previous sheet | shift + option + ← (left arrow) |
| Select the current and next sheet | shift + option + → (right arrow) |
| Switch sheet | option + ← (left arrow) option + → (right arrow) |
| Next sheet | option + → (right arrow) |
| Close all sheets | command + W |
| Move | |
| Move to other cells | ↑ or ↓ or → or ← (Arrow key) |
| Move to the cell on the edge of the data | command + ↑ or ↓ or → or ← (Arrow key) |
| Format | |
| Bold | command + B |
| Strikethrough | control + 5 |
| Left alignment | command + L |
| Center alignment | command + E |
| Format cell | command + 1 |
| Font tab | control + shift + P |
| Increase font size | command + shift + > |
| Set any font size | control + shift + P |
| Bottom border | command + option + ↓ (down arrow key) |
| Top border | command + option + ↑ (up arrow key) |
| Left border | command + option + ← (left arrow key) |
| Right border | command + option + → (right arrow key) |
| No border | command + option + – (minus) |
| Outside border | command + option + 0 (zero) |
| Number format | command + shift + 1 |
| Time format | control + shift + @ |
| Current time | command + : (colon) |
| Date Format | control + shift + # |
| Today’s date | control + ; (semicolon) |
| Apply currency format | control + shift + $ |
| Apply percentage format | control + shift + % |
| Apply scientific format | control + shift + ^ (caret) |
| Apply general format | control + shift + ~ (tilde) |
| Superscript | control + shift + P |
| Subscript | control + shift + P |
| Format Cells dialog box | command + 1 |
| Formula/Function | |
| Cursor to formula bar | control + U Setup required |
| Edit formula | control + U |
| Drag formula | command + return |
| Formula bar wider | control + shift + U |
| Show formula | control + shift + ` (grave accent) |
| Copy formula down | command + D |
| Multiply formula | option + command + V |
| Remove formula | option + command + V |
| Absolute reference | command + T |
| Insert argument names into formula | control + shift + A |
| Select cells that are directly referenced in a formula | control + [ |
| Select cells with formulas that directly reference the cell | control + ] |
| Insert function | shift + F3 |
| AutoSum | command + shift + T |
| Macro/VBA | |
| Open Macro | option + F8 |
| Open VBA | option + F11 |
| Others | |
| Select all cells from the current cell to A1 | control + shift + fn + ← (Left Arrow key) |
| Select only the active cell when multiple cells are selected | shift + backspace |
| Hide ribbon | command + F1 |
| Unhide ribbon | command + option + R |
| Get the bottom cell | control + end |
| Search | control + F |
| Find next | command + G |
| Find previous | command + shift + G |
| Remove newline | control + H Operation required |
| Select all cells with Notes | control + shift + O |
| Insert notes | shift + F2 |
| Insert comment | command + shift + F2 |
| Hide object | command + 6 |
| Flash fill | control + E |