Excel on macOS moves fast when your fingers stay on the keyboard. Use these shortcuts to navigate, format, and build functions and formulas without breaking your flow.
Navigation essentials
| Action | Shortcut |
|---|
| Move one cell right | Tab |
| Move one cell left | ⇧ + Tab |
| Move one row down | Return |
| Move one row up | ⇧ + Return |
| Jump to edge of data region | ⌘ + Arrow |
| Select to edge of data region | ⌘ + ⇧ + Arrow |
| Go to a specific cell | ⌃ + G |
| Last used cell in worksheet | Fn + ⌃ + → |
Selection shortcuts
| Action | Shortcut |
|---|
| Select entire column | ⌃ + Space |
| Select entire row | ⇧ + Space |
| Select current region | ⌘ + A |
| Select entire sheet | ⌘ + A (press twice) |
| Extend selection by one cell | ⇧ + Arrow |
Editing and data entry
| Action | Shortcut |
|---|
| Edit active cell | ⌃ + U |
| Copy | ⌘ + C |
| Cut | ⌘ + X |
| Paste | ⌘ + V |
| Paste Special | ⌃ + ⌘ + V |
| Undo | ⌘ + Z |
| Redo | ⇧ + ⌘ + Z |
| Fill Down | ⌃ + D |
| Fill Right | ⌃ + R |
| Insert line break in a cell | ⌃ + ⌥ + Return |
| Insert current date | ⌘ + ; |
| Insert current time | ⌘ + ⇧ + ; |
Tip: On Macs where function keys control media, use Fn + F2 as an alternative to edit a cell.
Formatting essentials
| Action | Shortcut |
|---|
| Format Cells dialog | ⌘ + 1 |
| Bold | ⌘ + B |
| Italic | ⌘ + I |
| Underline | ⌘ + U |
| Apply Number format | ⌘ + ⇧ + ! |
| Apply Time format | ⌘ + ⇧ + @ |
| Apply Date format | ⌘ + ⇧ + # |
| Apply Currency format | ⌘ + ⇧ + $ |
| Apply Percent format | ⌘ + ⇧ + % |
Functions and formulas
| Action | Shortcut |
|---|
| AutoSum | ⌘ + ⇧ + T |
| Insert Function (pick SUM, AVERAGE, COUNT, MAX, MIN) | ⇧ + F3 |
| Toggle absolute/relative references | ⌘ + T |
| Show/Hide formulas | ⌃ + ` |
Excel for Mac does not include default one-off shortcuts for every individual function, but the Insert Function dialog is the fastest way to add the most-used ones from the keyboard.
Rows, columns, and sheets
| Action | Shortcut |
|---|
| Insert row/column | ⌘ + ⇧ + + |
| Delete row/column | ⌘ + - |
| Hide row | ⌘ + 9 |
| Unhide row | ⌘ + ⇧ + 9 |
| Hide column | ⌘ + 0 |
| Unhide column | ⌘ + ⇧ + 0 |
| New worksheet | ⇧ + F11 |
| Move to next/previous worksheet | ⌃ + Page Down / ⌃ + Page Up |
Find and replace
| Action | Shortcut |
|---|
| Find | ⌘ + F |
| Replace | ⌘ + H |
| Find next | ⌘ + G |
| Find previous | ⌘ + ⇧ + G |
Customize your shortcuts
Excel shortcuts can be customized from Tools → Customize Keyboard. You can also add app-specific shortcuts in System Settings → Keyboard → Keyboard Shortcuts → App Shortcuts.
Show your shortcuts on screen
Teaching a spreadsheet workflow? KeyScreen displays your keystrokes beautifully on screen so your audience always knows which Excel shortcuts you used.