Apple Numbers Keyboard Shortcuts: Complete Mac & iPad List
Quick answer: The most-used Apple Numbers shortcut is Command-N to open the template chooser (start a new spreadsheet). To insert a row above a cell, press Option-Up Arrow; to open the Formula Editor in a cell, just press the Equals (=) key. Below you’ll find 150+ verified Numbers keyboard shortcuts for Mac and iPad, grouped by task, plus a free PDF cheat sheet.
What Are Apple Numbers Keyboard Shortcuts?
Apple Numbers keyboard shortcuts are key combinations that let you perform spreadsheet actions like creating a sheet, inserting rows, formatting text, or entering formulas without reaching for the mouse or trackpad. Numbers is Apple’s free spreadsheet app, launched in 2007 as part of the iWork suite alongside Pages and Keynote, and it runs on Mac, iPad, and iPhone.
Because Numbers follows standard macOS conventions, most shortcuts use the Command (⌘), Option (⌥), Shift (⇧), and Control (⌃) modifier keys. If you already know shortcuts from Pages, Keynote, or other Mac apps, you’ll recognize most of these instantly.
Modifier Key Symbol Legend
Apple’s official documentation uses symbols that confuse a lot of beginners. Here’s what each one means:
| Symbol | Key |
| ⌘ | Command |
| ⌥ | Option (Alt) |
| ⇧ | Shift |
| ⌃ | Control |
| ⏏ | Eject |
| ↩ | Return |
| ⇥ | Tab |
| fn | Function |
Throughout this guide we spell the keys out in plain English (for example, “Option-Up Arrow”) so there’s no guesswork.
Most-Used Apple Numbers Shortcuts
If you only memorize one section, make it this one. These cover roughly 80% of everyday spreadsheet work.
| Action | Shortcut |
| Open the template chooser (new spreadsheet) | Command-N |
| Open an existing spreadsheet | Command-O |
| Save a spreadsheet | Command-S |
| Save as | Option-Shift-Command-S |
| Print a spreadsheet | Command-P |
| Undo the last action | Command-Z |
| Redo the last action | Shift-Command-Z |
| Copy the selection | Command-C |
| Cut the selection | Command-X |
| Paste the selection | Command-V |
| Paste and match destination style | Option-Shift-Command-V |
| Find | Command-F |
| Select all | Command-A |
| Bold | Command-B |
| Italic | Command-I |
| Underline | Command-U |
| Open the empty Formula Editor | Equals (=) |
| Add a new sheet | Shift-Command-N |
| Quit Numbers | Command-Q |
General & File Management Shortcuts
Managing windows, sheets, files, and the app itself.
| Action | Shortcut |
| Start dictation | Fn-D |
| Open the template chooser | Command-N |
| Open template chooser with Language menu | Option-Command-N |
| Open an existing spreadsheet | Command-O |
| Close the template chooser | Esc |
| Save a spreadsheet | Command-S |
| Save as | Option-Shift-Command-S |
| Duplicate a spreadsheet | Shift-Command-S |
| Print a spreadsheet | Command-P |
| Preview a sheet or spreadsheet | Option-Command-P |
| Add a new sheet | Shift-Command-N |
| Switch to the previous sheet | Shift-Command-Left Brace ({) |
| Switch to the next sheet | Shift-Command-Right Brace (}) |
| Switch to the first sheet | Option-Shift-Command-{ |
| Switch to the last sheet | Option-Shift-Command-} |
| Select one of the first seven sheets | Command-1 through Command-7 |
| Open the Numbers User Guide | Shift-Command-Question Mark (?) |
| Close a window | Command-W |
| Close all windows | Option-Command-W |
| Minimize a window | Command-M |
| Minimize all windows | Option-Command-M |
| Enter full-screen view | Command-Control-F |
| Zoom in | Shift-Command-Right Angle Bracket (>) |
| Zoom out | Shift-Command-Left Angle Bracket (<) |
| Zoom to selection | Shift-Command-0 |
| Return to actual size | Command-0 |
| Show the Settings window | Command-Comma (,) |
| Show the spreadsheet rulers | Command-R |
| Show the Colors window | Shift-Command-C |
| Hide or show the toolbar | Option-Command-T |
| Hide or show the sidebar | Option-Command-I |
| Open the next tab of the sidebar | Control-grave (`) |
| Open the previous tab of the sidebar | Shift-Control-grave (`) |
| Hide Numbers | Command-H |
| Hide other windows | Option-Command-H |
| Undo | Command-Z |
| Redo | Shift-Command-Z |
| Quit Numbers | Command-Q |
| Quit Numbers and keep windows open | Option-Command-Q |
Navigation Shortcuts (Move Around a Spreadsheet)
| Action | Shortcut |
| Move one character left | Left Arrow |
| Move one character right | Right Arrow |
| Move to the line above | Up Arrow |
| Move to the line below | Down Arrow |
| Move to the beginning of the current/previous word | Option-Left Arrow |
| Move to the end of the current/next word | Option-Right Arrow |
| Move to the beginning of the current text area | Command-Up Arrow |
| Move to the bottom of the current text area | Command-Down Arrow |
| Move to the beginning of the current line | Command-Left Arrow |
| Move to the end of the current line | Command-Right Arrow |
| Move to the beginning of the current paragraph | Option-Up Arrow |
| Move to the end of the current paragraph | Option-Down Arrow |
| Jump to a selection in a spreadsheet | Command-J |
| Scroll up the sheet | Page Up |
| Scroll down the sheet | Page Down |
| Scroll to the beginning of the sheet | Home or Fn-Up Arrow |
| Scroll to the end of the sheet | End or Fn-Down Arrow |
Cell, Row & Column Shortcuts
This is the section most spreadsheet users actually need and the one most guides leave out.
| Action | Shortcut |
| Add a row above the selected cells | Option-Up Arrow |
| Add a row below the selected cells | Option-Down Arrow |
| Add a column to the right of selected cells | Option-Right Arrow |
| Add a column to the left of selected cells | Option-Left Arrow |
| Insert a row at the bottom of the table | Select a cell in the bottom row, then press Return |
| Insert a column on the right of the table | Select a cell in the right-most column, then press Tab |
| Delete selected rows | Option-Command-Delete |
| Delete selected columns | Control-Command-Delete |
| Select all content in a table | Command-A |
| Select additional rows | Shift-Up Arrow or Shift-Down Arrow |
| Select additional columns | Shift-Right Arrow or Shift-Left Arrow |
| Select the next cell (or add a column if last cell) | Tab |
| Select the previous cell | Shift-Tab |
| Select the cell below | Return |
| Select the cell above | Shift-Return |
| Extend the cell selection by one cell | Shift + an arrow key |
| Select the first populated cell in the current row | Option-Command-Left Arrow |
| Select the last populated cell in the current row | Option-Command-Right Arrow |
| Select the first populated cell in the current column | Option-Command-Up Arrow |
| Select the last populated cell in the current column | Option-Command-Down Arrow |
| Merge selected cells | Control-Command-M |
| Unmerge selected cells | Control-Shift-Command-M |
| Edit a cell | Option-Return |
| Stop editing the cell and select the cell | Command-Return |
| Auto-align cell content | Option-Command-U |
| Copy cell style | Option-Command-C |
| Paste cell style | Option-Command-V |
| Add/remove top border | Control-Option-Command-Up Arrow |
| Add/remove bottom border | Control-Option-Command-Down Arrow |
| Add/remove right border | Control-Option-Command-Right Arrow |
| Add/remove left border | Control-Option-Command-Left Arrow |
Table Editing & Data Shortcuts
| Action | Shortcut |
| Turn on autofill mode | Command-Backslash () |
| Autofill from the column before | Control-Command-Backslash () |
| Autofill from the row above | Option-Command-Backslash () |
| Turn Filters on or off | Option-Command-F |
| Apply sorting rules | Shift-Command-R |
| Collapse selected category groups | Command-8 |
| Expand selected category groups | Command-9 |
| Select all rows intersecting the selection | Option-Command-Return |
| Select all columns intersecting the selection | Control-Command-Return |
| Select a table from a cell selection | Command-Return |
| Open a pop-up menu in a selected cell | Space bar |
| Check or uncheck a checkbox in a cell | Space bar, Y, or N |
| Set stars for a star-rating cell | 0, 1, 2, 3, 4, or 5 |
Formula & Function Shortcuts
The fastest way to start calculating in Numbers.
| Action | Shortcut |
| Open the empty Formula Editor | Equals (=) |
| Open the Formula Editor with the cell’s contents | Control-Equals (=) |
| Convert a formula to text | Control-Equals (=) |
| Open the Formula Editor for a cell with a formula | Double-click or Option-Return |
| Insert an equation | Option-Command-E |
| Save changes in the Formula Editor | Return or Tab |
| Discard changes in the Formula Editor | Esc |
| Paste formula results (values only) | Shift-Command-V |
| Navigate to and select a single cell (in a formula) | Option + an arrow key |
| Extend or shrink a selected cell reference | Option-Shift + an arrow key |
| Cycle absolute/relative reference attributes | Command-K or Shift-Command-K |
Text Formatting & Editing Shortcuts
| Action | Shortcut |
| Show the Fonts window | Command-T |
| Bold | Command-B |
| Italic | Command-I |
| Underline | Command-U |
| Make the font size bigger | Command-Plus (+) |
| Make the font size smaller | Command-Minus (-) |
| Superscript | Control-Command-Plus (+) |
| Subscript | Control-Command-Minus (-) |
| Increase indent level | Command-Right Bracket (]) |
| Decrease indent level | Command-Left Bracket ([) |
| Turn text or an object into a link | Command-K |
| Cut | Command-X |
| Copy | Command-C |
| Paste | Command-V |
| Paste and match destination style | Option-Shift-Command-V |
| Insert a nonbreaking space | Option-Space bar |
| Insert a line break (soft return) | Shift-Return |
| Insert a paragraph break | Option-Return |
| Insert special characters | Control-Command-Space bar |
| Insert the current date | Control-Shift-Command-D |
| Insert the current time | Control-Shift-Command-T |
| Delete the word before the insertion point | Option-Delete |
Text Selection Shortcuts
| Action | Shortcut |
| Select a word | Double-click the word |
| Select a paragraph | Triple-click in the paragraph |
| Select all objects and text | Command-A |
| Deselect all objects and text | Shift-Command-A |
| Extend selection one character right | Shift-Right Arrow |
| Extend selection one character left | Shift-Left Arrow |
| Extend selection to end of word | Option-Shift-Right Arrow |
| Extend selection to beginning of word | Option-Shift-Left Arrow |
| Extend selection to end of line | Shift-Command-Right Arrow |
| Extend selection to beginning of line | Shift-Command-Left Arrow |
| Extend selection one line up | Shift-Up Arrow |
| Extend selection one line down | Shift-Down Arrow |
| Extend selection to beginning of text | Shift-Command-Up Arrow or Shift-Home |
| Extend selection to end of text | Shift-Command-Down Arrow or Shift-End |
Find, Replace & Spelling Shortcuts
| Action | Shortcut |
| Find | Command-F |
| Find next | Command-G |
| Find previous | Shift-Command-G |
| Place selected text in Find & Replace field | Command-E |
| Hide the Find window | Esc |
| Look up the word at the insertion point | Control-Command-D |
| Check spelling and grammar | Command-Semicolon (;) |
| Show the Spelling and Grammar window | Shift-Command-Colon (:) |
| Open a new comment | Shift-Command-K |
| Save a comment | Command-Return |
| Show the next comment | Option-Command-K |
| Show the previous comment | Option-Shift-Command-K |
Object, Shape & Chart Shortcuts
| Action | Shortcut |
| Group selected objects | Option-Command-G |
| Ungroup selected objects | Option-Shift-Command-G |
| Lock selected objects | Command-L |
| Unlock selected objects | Option-Command-L |
| Duplicate the object | Command-D |
| Send object to the back | Shift-Command-B |
| Send object one layer back | Option-Shift-Command-B |
| Bring object to the front | Shift-Command-F |
| Bring object one layer forward | Option-Shift-Command-F |
| Move the selected object one point | An arrow key |
| Move the selected object ten points | Shift + an arrow key |
| Mask or unmask the object | Shift-Command-M |
| Exit text editing and select the object | Command-Return |
| Draw a custom shape with the Pen tool | Option-Shift-Command-P |
| Edit chart data references | Shift-Command-D |
Mac vs iPad vs iPhone: Quick Comparison
| Aspect | Mac | iPad | iPhone |
| Keyboard needed | Built-in | External / Magic Keyboard | External Bluetooth keyboard |
| See all shortcuts live | Check menus | Press and hold Command | Press and hold Command |
| Modifier keys | ⌘ ⌥ ⇧ ⌃ | ⌘ ⌥ ⇧ ⌃ | ⌘ ⌥ ⇧ ⌃ |
| Most shortcuts identical to Mac? | — | Yes | Yes |
| Touch gestures replace some keys | No | Yes | Yes |
On iPad and iPhone, the trick most people miss: press and hold the Command key with an external keyboard connected, and Numbers shows a live overlay of every shortcut available for whatever you’ve selected.
How to Create a Custom Shortcut in Numbers
You can assign your own F1–F8 keys to paragraph, character, or list styles:
- Open the Numbers app on your Mac and open a spreadsheet.
- Click any text, then in the Format sidebar click the Text tab.
- Click the Style button near the top of the sidebar.
- Move the pointer over the style name you want, then click the arrow that appears.
- Choose a shortcut key (F1–F8) from the menu.
- To use it later, press Fn plus your chosen function key.
To remove an assignment, repeat the steps and choose None from the Shortcut menu.
Free Apple Numbers Shortcuts PDF Cheat Sheet
Want every shortcut on one printable page? Download the Apple Numbers Shortcuts PDF and keep it next to your desk.
Frequently Asked Questions
What is the shortcut to insert a row in Apple Numbers?
Select a cell, then press Option-Up Arrow to add a row above it or Option-Down Arrow to add a row below. To add a row at the very bottom of a table, click a cell in the last row and press Return.
What is the shortcut to insert a column in Numbers?
Press Option-Right Arrow to add a column to the right of the selected cells, or Option-Left Arrow to add one to the left. Pressing Tab in the last cell of the right-most column also adds a new column.
How do I open the formula editor in Numbers?
Select a cell and press the Equals (=) key to open an empty Formula Editor. To edit an existing formula, double-click the cell or press Option-Return.
How do I see all keyboard shortcuts in Numbers?
On a Mac, the shortcuts appear next to commands in the menu bar. On iPad or iPhone with an external keyboard connected, press and hold the Command key to display a live list of available shortcuts.
Do Apple Numbers shortcuts work on iPad?
Yes. When you connect an external or Magic Keyboard to an iPad or iPhone, nearly all the Mac shortcuts work identically. Press and hold Command to confirm what’s available for your current selection.
What is the shortcut to autofill cells in Numbers?
Press Command-Backslash () to turn on autofill mode. To fill from the row above, use Option-Command-Backslash, and to fill from the column before, use Control-Command-Backslash.
How do I merge cells in Numbers with a shortcut?
Select the cells you want to merge and press Control-Command-M. To reverse it, press Control-Shift-Command-M.
Why doesn’t my shortcut match this list?
Some macOS shortcuts can be reassigned in System Settings > Keyboard, so a few may differ from the defaults shown here. You can always check or reset them there.
Can I change or create my own shortcuts in Numbers?
Yes, you can assign F1–F8 keys to paragraph, character, and list styles using the Format sidebar (see the custom shortcut steps above). Other shortcuts are managed system-wide in macOS keyboard settings.
READ NEXT:
