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.
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 |
|---|---|---|
| Open empty Formula Editor | Equals (=) | Use with the intended result cell selected. Source ↗ |
| Edit an existing formula | Option-Return | For a cell containing a formula or formatted number; inspect the editor that opens. Source ↗ |
| Save formula edit | Return or Tab | While the Formula Editor is active. Source ↗ |
| Discard formula edit | Escape | While editing a formula; abandons the current uncommitted changes. Source ↗ |
| Open editor with cell contents | Control-Equals (=) | Apple documents a separate editor operation using the selected cell’s contents. Source ↗ |
Use a formula editor when you mean to calculate
Before starting, select the cell that should contain the result and identify the input cells. Typing an equals sign opens an empty formula workflow rather than ordinary text entry. For an existing formula, Apple also documents Option-Return or a double-click to open its editor. Look at the expression itself before changing it; the displayed result does not reveal every reference or operation.
Choose save or discard deliberately
Return and Tab commit changes while the Formula Editor is open. Escape discards those current edits. Check the editor’s focus before relying on the key: Return has other meanings in table navigation and cell editing. If you are experimenting with a formula, use a spare result cell or a practice copy rather than altering the only calculation you trust.
Check both the expression and the result
Make a small table with two known amounts and a result cell. Open the empty editor, build a simple addition from those inputs, and save. Reopen the formula, change one part, then discard that edit with Escape. Finally inspect the expression and result again. A successful save only means the edit was accepted; it does not independently prove that the formula matches the question you wanted to answer.
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