Numbers keyboard shortcuts for Mac
Navigate cells, edit formulas and organize tables without confusing text and cell selection.
Documentation reviewed 2026-11-05 · 6 task guides · Mac bindings and focus notes
What do you want to do?
Change absolute and relative formula references in Numbers
While editing a Numbers formula, Command-K and Shift-Command-K cycle reference attributes. Option-Command-K variants adjust the first and last cells of a selected range.
Steps, keys and context ↗Open, save or cancel a Numbers formula edit
The Equals key opens an empty Formula Editor in Numbers. Return or Tab saves an edit in that editor; Escape discards the current edit.
Steps, keys and context ↗Enter data and move between cells in Numbers on Mac
In Numbers tables, Tab moves to the next cell and Return moves down. Option-Return edits a selected cell. Edge-cell navigation can add a column or row.
Steps, keys and context ↗Filter, sort and collapse categories in Numbers
Option-Command-F toggles Numbers filters, Shift-Command-R applies sorting rules, and Command-8 or Command-9 collapses or expands selected category groups.
Steps, keys and context ↗Insert and delete Numbers rows or columns precisely
Option-arrow inserts rows or columns around selected cells in Numbers. Option-Command-Delete deletes selected rows; Control-Command-Delete deletes selected columns.
Steps, keys and context ↗Paste Numbers styles or formula results deliberately
Shift-Command-V pastes formula results in Numbers. Option-Command-V pastes copied cell style, while Option-Shift-Command-V preserves the destination style when pasting.
Steps, keys and context ↗
Quick reference
Selected bindings from the linked task guides. Check the context before pressing a key: the focused control, app version and your custom settings can change what it does. This is a documentation reference, not an exhaustive live menu reading.
| Action | Keys | Context |
|---|---|---|
| Cycle reference attributes forward | Command-K | Inside the Formula Editor, with the intended cell reference selected. Source ↗Read the task guide → |
| Open empty Formula Editor | Equals (=) | Use with the intended result cell selected. Source ↗Read the task guide → |
| Next cell | Tab | Moves through a table; at the row’s last cell it can add a column. Source ↗Read the task guide → |
| Toggle filters | Option-Command-F | Enables or disables configured table filtering. Source ↗Read the task guide → |
| Row above | Option-Up Arrow | Inserts above selected cells; inspect the intended row position. Source ↗Read the task guide → |
| Paste formula results | Shift-Command-V | Use when the destination should receive results rather than the formula relationship. Source ↗Read the task guide → |
| Cycle reference attributes backward | Shift-Command-K | Moves backward through the selected reference’s options. Source ↗Read the task guide → |
| Edit an existing formula | Option-Return | For a cell containing a formula or formatted number; inspect the editor that opens. Source ↗Read the task guide → |
| Previous cell | Shift-Tab | Moves backward through cell selection. Source ↗Read the task guide → |
| Apply sorting rules | Shift-Command-R | Uses the table’s sorting rules; inspect those rules first. Source ↗Read the task guide → |
| Row below | Option-Down Arrow | Inserts below the selection. Source ↗Read the task guide → |
| Copy cell style | Option-Command-C | Copies styling from the current cell context. Source ↗Read the task guide → |
| Cycle range-endpoint attributes forward | Option-Command-K | For first and last cells of selected cell references in the Formula Editor. Source ↗Read the task guide → |
| Save formula edit | Return or Tab | While the Formula Editor is active. Source ↗Read the task guide → |
| Cell below | Return | Moves down; from a bottom-row cell it can add a row. Source ↗Read the task guide → |
| Collapse selected category groups | Command-8 | Changes visible group detail when categories are in use. Source ↗Read the task guide → |
| Column to the right | Option-Right Arrow | Adds a field to the right of selected cells. Source ↗Read the task guide → |
| Paste cell style | Option-Command-V | Applies copied style rather than serving as the formula-result command. Source ↗Read the task guide → |
When a shortcut behaves differently
- Confirm you are using the Mac binding, and check whether the guide describes a desktop app or its web version.
- Put focus in the control named in the guide. Editing text, selecting an object and navigating a sidebar can use different keys.
- Look up the command in the app's menu or shortcut settings. Customized keys and non-US keyboard layouts can differ from documented defaults.
The cited documentation was checked for these guides; a documentation review is separate from testing your particular running app. How we verify and update guides →
Official sources
- Keyboard shortcuts for Numbers on Mac — Apple Support — checked 2026-11-04