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.
Numbers · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Numbers · macOS app; Apple Mac documentation source checks on 4 November 2026 and editorial review on 5 November 2026. No running-app compatibility test is claimed.
- Keyboard and customization
- English-language Apple documentation. Modifier and punctuation keys may differ on other keyboard layouts.. Documented defaults, not a reading of your current menu. Check the app menu and custom App Shortcuts if a binding differs; focus and selected content can change its effect.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — primary-documentation and editorial review; no hands-on runtime test. These bindings were not tested in a running app for this guide.
Keyboard shortcuts for this task
| Action | Keys | Context |
|---|---|---|
| Cycle reference attributes forward | Command-K | Inside the Formula Editor, with the intended cell reference selected. Source ↗ |
| Cycle reference attributes backward | Shift-Command-K | Moves backward through the selected reference’s options. Source ↗ |
| Cycle range-endpoint attributes forward | Option-Command-K | For first and last cells of selected cell references in the Formula Editor. Source ↗ |
| Cycle range-endpoint attributes backward | Option-Shift-Command-K | Inspect both range endpoints after changing their attributes. Source ↗ |
Decide which references should move when copied
A calculation that refers to the row’s quantity should behave differently from one that always refers to a single tax-rate cell. Identify that intention before copying a formula across a table. The reference controls exist to express which parts stay fixed, but a keyboard shortcut cannot decide the business meaning of your inputs. Write down the expected result for one example before changing the reference attributes.
Work on the selected reference inside the formula
These keys are documented in the Formula Editor’s cell-reference context, not as general commands for the spreadsheet window. Select the reference you mean to adjust and inspect how its attributes change. A range can have distinct first and last endpoints, which is why Apple lists a separate Option-modified set of shortcuts. Do not assume a shortcut changes every reference in the expression at once.
Test a copied calculation against known inputs
Use a practice table with two quantities, two prices and one shared rate. Set the references deliberately, copy the calculation to the second row, and inspect its expression rather than only the total. Change the shared input and confirm the intended cells respond. If a copied result looks plausible but uses the wrong row, correct the reference structure before expanding the formula to more records.
Sources and corrections
- Keyboard shortcuts for Numbers on Mac — Apple Support — checked 2026-11-04
Found a mismatch? Email pashaseenainc@gmail.com with your app version, macOS version, keyboard layout and the command. Please leave personal document names out.
Keep going
Right there when you need it.
Keep a compact shortcut reference in your Mac’s menu bar.
Explore the native Mac app