How to use keyboard shortcuts in Numbers on Mac: rows, formulas, sheets and custom keys

Why shortcuts matter in a spreadsheet

Numbers is a spreadsheet app, and spreadsheets repeat small moves all day. You add a row, type a value, move to the next cell, then repeat. Each of those moves is faster with a key than with a trackpad. Superhuman's blog cites developer Bruno Michels. He estimates that people can waste about 134 hours a year, or 17 work days, by using the mouse instead of the keyboard. That figure rests on a method in a Medium post, so treat it as illustrative. The smaller number is easier to believe. Keyboard cut and paste can save up to five seconds each time, according to the same article.

You don't need to learn every shortcut. Apple's guide lists more than this page covers. Focus on the ones you repeat on every sheet. For most people that means adding rows, deleting rows, starting formulas and saving. Learn those four first, and the rest will come as you need them.

Versions and keys before you start

The shortcuts here come from Apple's Numbers for Mac keyboard guide, which is written for Numbers 15.4. MacRumors reports that Numbers 15.1 for Mac arrived on January 28, 2026, as part of the separate Apple Creator Studio editions. The older Mac app was updated to 14.5 only to say it no longer gets new features. If your version differs, check the About window before you assume a shortcut is wrong. The release notes for 15.4 were not available to check, so this page does not say what changed in that version.

Four symbols show up in almost every Numbers shortcut. ⌘ is Command, the key beside the space bar. ⌥ is Option. ⌃ is Control. ⇧ is Shift. Read a shortcut such as ⌥⌘⌫ from left to right. Hold the symbols first, then press the last key, which here is Delete.

The Numbers shortcuts you will use most

These are the shortcuts that save the most time when you build and edit a table. Each one comes from Apple's Numbers for Mac keyboard shortcut guide.

Rows, columns and sheets from the keyboard

Most table work follows a loop. You select, insert, type and move on. Click a cell in the row you want to copy the layout from. Press ⌥↓ to add a new row below it. Type in the first cell, then move across with the Tab key.

Adding a row with ⌥↑ puts it above the selection, not below. Use ⌥← to add a column to the left and ⌥→ to add one to the right. Before you delete anything, select only what you want to remove. The delete shortcut acts on the whole selection, so a stray selection can remove more than you meant.

Sheets follow a similar pattern. ⇧⌘N adds a new sheet. ⇧⌘{ moves to the previous sheet, and ⇧⌘} moves to the next one. On a US keyboard, the braces are the square bracket keys with Shift held down. If your workbook has several sheets, these keys save a lot of clicking back and forth.

Formulas and functions with shortcuts

Formulas are where shortcuts save the most effort. Press = in a cell to open an empty Formula Editor. Type your formula and press Return to finish. If the cell already holds a formula you want to change, select it and press ⌃= to open the editor for that cell.

A short example helps. Say you have a column of prices and want the total under it. Click the empty cell below the column, press =, then type SUM with the range of prices inside the brackets. Press Return. The total appears in that cell. Check the range before you trust the number, because the formula only adds the cells it points at.

Two more shortcuts help once formulas exist. ⌥Return edits a cell in place, so you can change its contents without leaving the table. ⇧⌘V pastes a formula result, so check what lands in the cell before you move on. Test both on a copy of your sheet first.

Find, spelling and word lookup

⌘F opens Find. Type what you want, and Numbers searches the sheet. ⌘E copies your current selection into the Find field, which saves retyping a word you already highlighted. ⌘J jumps to your selection, so you can return to the cell you were working on after a search. ⌘; runs a spelling and grammar check. ⌃⌘D looks up the word under the insertion point.

Merging and unmerging cells

Merged cells work well for a title that sits above a table. Select the cells you want to join, then press ⌃⌘M. To split them again, select the merged cell and press ⌃⇧⌘M. Merge after you enter your data, not before, so you can see what each cell holds. If the result looks wrong, press ⌘Z to undo.

Set your own shortcut in System Settings

Apple's guide says some shortcuts can be changed in System Settings and may not match its list. You can create shortcuts for existing menu commands. You cannot create one for a general task, such as opening Numbers. Type the menu title exactly as it appears in the app. Where a menu path has >, write ->. Where a title ends in an ellipsis, type three periods.

1. Open System Settings, then select Keyboard.
2. Click Keyboard Shortcuts, then select App Shortcuts.
3. Click Add (+). Choose Numbers as the application, or choose All Applications if you want the shortcut in every app.
4. Type the menu title exactly as it appears in Numbers, using -> in place of each > character.
5. Click the Keyboard shortcut field and press the keys you want.
6. Click Done. If the keys are already used, the new shortcut will not run, so pick another combination.

If you want a shortcut for something that is not a menu command, this method won't work. Use one of the shortcuts above, or find the command in the menu bar and note its keys.

When a shortcut does nothing

A shortcut that does nothing usually has one of three causes. Another command or app may already use the same keys. Some apps block custom shortcuts. Or the key combination differs from Apple's list because someone changed it in System Settings. Start by checking App Shortcuts for a custom entry with the same keys.

Forward Delete, and Option-Forward Delete, are not available on all keyboards. A shortcut that depends on them may do nothing on your keyboard. Check which keys your keyboard has before you assume the shortcut is broken.

Numbers for iCloud: keys that change

Numbers for iCloud runs in a browser at iCloud.com. Its shortcuts use Command on a Mac and Control on Windows, which matches most Mac apps. Several commands still differ, so the keys you learned in the Mac app may not carry over one for one. The table shows the main differences from Apple's iCloud shortcut page.

Apple's iCloud page is old. It says the image mask shortcut, ⌘⇧M on a Mac, works only in Safari on Mac. Test it in your browser before you rely on it. iCloud.com supports the latest versions of Safari, Firefox, Chrome, Edge and Opera. Web-only iCloud accounts get 1 GB of storage, so check your space before you move a large workbook.

Mistakes people make with Numbers shortcuts

• Reading Windows keys on a Mac. Redo is ⇧⌘Z on a Mac, not Control-Y. Pressing the wrong one does nothing.
• Assuming ⌥↑ adds a row below. It adds the row above. Use ⌥↓ for below.
• Deleting the wrong selection. ⌥⌘⌫ removes selected rows and ⌃⌘⌫ removes selected columns. Check the selection first.
• Trying to assign a shortcut to a task. System Settings only adds shortcuts for existing menu commands.
• Picking a key combination another command already uses. The new shortcut will not run if it duplicates one in use.

Build a short list that fits your work

You don't need every shortcut at once. Pick four or five that match your work, then use them for a week. People who build budgets will lean on formulas and Find. People who keep a class schedule will lean on rows, columns and merged headings. Write your list on paper or in a note until the keys feel automatic.

Where to go next

If a shortcut is your first step, the next step is usually the task it supports. Read how to add a formula in Numbers on Mac to see the formula steps in order. Then try how to sort a table in Numbers on Mac by column or how to filter a table in Numbers on Mac. For function names, see how to look up a function in Numbers on Mac.

Do you need a subscription for these shortcuts?

Apple's guide does not tie these keys to a subscription. MacRumors lists professional templates, the Content Hub and AI-generated images among features limited to Apple Creator Studio subscribers. The US price is $12.99 per month or $129 per year. Subscribe only if you want those features.