Apple Numbers keyboard shortcuts for Mac

Keyboard shortcuts for Numbers on the Mac, as listed in Apple's Numbers User Guide for Mac (Numbers 15.4): spreadsheets and sheets, text, objects, tables, cells, formulas and charts, plus the modifier-click and modifier-drag gestures Apple prints beside them. The iPhone, iPad and iCloud editions of Numbers are not included. Tables are objects on a sheet, so Cmd + Return steps outward from cell text to the cell and then to the table, while Option + Return starts editing the selected cell.

266 shortcuts in 15 sections. Checked row by row against Apple Support on . Edited by Jay.

Spreadsheets and sheets 19

Some of these shortcuts can be reassigned in System Settings, so a particular Mac may not match the table.

ActionMac
Open the template chooserLists the templates a new spreadsheet can start from.Cmd+N
Template chooser with languagesSame chooser, with the Language pop-up menu displayed.Option+Cmd+N
Open a spreadsheetCmd+O
Close the template chooserEsc
Save the spreadsheetCmd+S
Save AsApple lists it beside Duplicate, which uses the same keys without Option.Option+Shift+Cmd+S
Duplicate the spreadsheetShift+Cmd+S
Confirm a new nameFinishes renaming the spreadsheet or a sheet and keeps what you typed.Return
Cancel renamingLeaves name editing and puts the earlier spreadsheet or sheet name back.Esc
Print the spreadsheetCmd+P
Open print previewPreviews a single sheet or the whole spreadsheet.Option+Cmd+P
Previous page in print previewPage Up
Next page in print previewPage Down
Add a sheetShift+Cmd+N
Go to the previous sheetShift+Cmd+{
Go to the next sheetShift+Cmd+}
Go to the first sheetOption+Shift+Cmd+{
Go to the last sheetOption+Shift+Cmd+}
Go to a sheet by numberCovers sheets one to seven; the digit 2, for instance, picks the second sheet.Cmd+1-7

Windows and view 27

ActionMac
Close the windowCmd+W
Close all windowsOption+Cmd+W
Minimize the windowCmd+M
Minimize all windowsOption+Cmd+M
Enter full screenCmd+Ctrl+F
Zoom inShift+Cmd+>
Zoom outShift+Cmd+<
Zoom to selectionShift+Cmd+0
Return to actual sizeCmd+0
Zoom by scrollingRequires a trackpad or a Magic Mouse.Option+Cmd+Scroll
Show the rulersCmd+R
Show or hide the toolbarOption+Cmd+T
Rearrange a toolbar itemDrag the item along the toolbar with the key held.Cmd+Drag
Remove a toolbar itemDrag the item off the toolbar with the key held.Cmd+Drag
Show or hide the sidebarOption+Cmd+I
Next sidebar tabCtrl+`
Previous sidebar tabShift+Ctrl+`
Show the Colors windowShift+Cmd+C
Open SettingsCmd+,
Open the user guideShift+Cmd+?
Start dictationDictation options are under Keyboard in System Settings.Fn+D
UndoCmd+Z
RedoShift+Cmd+Z
Hide NumbersCmd+H
Hide other windowsOption+Cmd+H
Quit NumbersCmd+Q
Quit and keep windows openOption+Cmd+Q

Text navigation and scrolling 20

ActionMac
Move left one characterLeft
Move right one characterRight
Move back one characterFollows the direction of the text, whether it runs left-to-right or right-to-left.Ctrl+B
Move forward one characterLike Ctrl + B, it respects the writing direction of the text.Ctrl+F
Move up one lineUp
Move down one lineDown
Jump to word startInside a word it stops at that word's beginning; otherwise it goes to the preceding word.Option+LeftorCtrl+Option+B
Jump to word endInside a word it stops where that word finishes; otherwise it goes on through the following word.Option+RightorCtrl+Option+F
Go to start of lineCmd+Left
Go to end of lineCmd+Right
Go to start of paragraphOption+Up
Go to end of paragraphOption+Down
Go to start of text areaCmd+Up
Go to end of text areaCmd+Down
Center the insertion pointScrolls so the insertion point sits in the middle of the Numbers window.Ctrl+L
Move down a pageCtrl+V
Scroll the sheet upPage Up
Scroll the sheet downPage Down
Scroll to top of sheetHomeorFn+Up
Scroll to end of sheetEndorFn+Down

Selecting text 18

ActionMac
Select a wordDouble-click
Select a paragraphTriple-click
Select allTakes in every object and all text; start from one selected object to get only objects.Cmd+A
Deselect allShift+Cmd+A
Extend selection to a clickClick once to set the start, then hold Shift and click where it should end.Shift+Click
Add or remove a rangeAdds a stretch of text to what is selected, or takes it out again.Shift+DragorCmd+Drag
Extend selection right one characterShift+Right
Extend selection left one characterShift+Left
Extend selection to word endPress again to take in the following words one at a time.Option+Shift+Right
Extend selection to word startOption+Shift+Left
Extend selection to line endShift+Cmd+Right
Extend selection to line startShift+Cmd+Left
Extend selection up one lineShift+Up
Extend selection down one lineShift+Down
Extend selection to paragraph startOption+Shift+Up
Extend selection to paragraph endOption+Shift+Down
Extend selection to start of textShift+Cmd+UporShift+Home
Extend selection to end of textShift+Cmd+DownorShift+End

Formatting text 17

ActionMac
Show the Fonts windowCmd+T
Apply boldCmd+B
Apply italicCmd+I
Apply underlineCmd+U
Increase font sizeCmd++
Decrease font sizeCmd+-
Tighten character spacingNarrows the gaps between the characters you have selected.Option+Cmd+[
Loosen character spacingWidens the gaps between the characters you have selected.Option+Cmd+]
Make text superscriptCtrl+Cmd++
Make text subscriptCtrl+Cmd+-
Decrease indent levelWorks on a text block as well as on a list item.Cmd+[
Increase indent levelPushes a text block or a list item one level further in.Cmd+]
Outdent a list itemMoves a list item or a headline up one indent level.Shift+Tab
Indent a list itemMoves a list item or a headline one indent level deeper.Tab
Add a linkMakes a link out of the selected text or object.Cmd+K
Copy paragraph styleOption+Cmd+C
Paste paragraph styleOption+Cmd+V

Editing and inserting text 18

Forward Delete is a separate key that some keyboards lack; Fn + Delete does the same job.

ActionMac
Delete previous characterWith something selected, it removes the selection instead.DeleteorCtrl+H
Delete next characterThe Forward Delete key is not present on every keyboard.Ctrl+DorForward Delete
Forward delete with FnDoes the job of the Forward Delete key on keyboards that lack one.Fn+Delete
Delete previous wordOption+Delete
Delete next wordNeeds a keyboard that has a Forward Delete key.Option+Forward Delete
Delete to end of paragraphRemoves everything from the insertion point up to the following paragraph break.Ctrl+K
Cut the selectionCmd+X
Copy the selectionCmd+C
PasteCmd+V
Paste and Match StyleThe pasted text takes on the formatting of the text it lands in.Option+Shift+Cmd+V
Insert a nonbreaking spaceOption+Space
Insert a line breakApple also calls this a soft return.Shift+Return
Insert a paragraph breakOption+Return
Insert a line after the cursorCtrl+O
Enter special charactersCtrl+Cmd+Space
Transpose two charactersSwaps the characters on each side of the insertion point.Ctrl+T
Insert the current timeCtrl+Shift+Cmd+T
Insert the current dateCtrl+Shift+Cmd+D

Find, spelling and comments 15

ActionMac
Open the Find windowCmd+F
Find nextWorks while the Find window is open.Cmd+G
Find previousSteps back to the earlier match while the Find window is open.Shift+Cmd+G
Use selection for FindPuts the highlighted text into the search field of Find & Replace.Cmd+E
Replace textReturn
Jump to the selectionScrolls the window until the selected text or object is in view.Cmd+J
Hide the Find windowEsc
Look up a wordUses the word the insertion point is in.Ctrl+Cmd+D
Show word completionsLists words that would complete the one you have selected.Option+Esc
Check spelling and grammarCmd+;
Show Spelling and Grammar windowShift+Cmd+:
Add a commentThe comment attaches to whichever text, object or cell is selected.Shift+Cmd+K
Save a commentCmd+Return
Go to next commentOption+Cmd+K
Go to previous commentOption+Shift+Cmd+K

Selecting and layering objects 24

ActionMac
Select the next objectCycles through the objects on the sheet or, inside a group, through its members.Tab
Select the previous objectRuns through the sheet's objects, or a group's members, in reverse order.Shift+Tab
Select or deselect more objectsEach click adds an object to the selection or takes it out.Cmd+ClickorShift+Click
Add or remove objects by draggingCmd+Drag
Drag-select outwardThe selection area grows in every direction from where the drag begins.Option+Drag
Select one grouped objectDouble-click
Select the object's groupWith a grouped object selected, stops editing it and selects the whole group.Cmd+Return
Stop editing text in an objectLeaves the text and selects the object that contains it.Cmd+Return
Open the shortcut menuShows the context menu for the item you click.Ctrl+Click
Copy graphic styleOption+Cmd+C
Paste graphic styleOption+Cmd+V
Apply shape style onlyHold the key while choosing a style in the sidebar; the object's text style stays as it is.Option+Click
Send to backShift+Cmd+B
Send backwardMoves the object down by a single layer.Option+Shift+Cmd+B
Bring to frontShift+Cmd+F
Bring forwardMoves the object up by a single layer.Option+Shift+Cmd+F
Group the selected objectsOption+Cmd+G
Ungroup the selected objectsOption+Shift+Cmd+G
Lock the selected objectsCmd+L
Unlock the selected objectsOption+Cmd+L
Toggle the object's maskShift+Cmd+M
Show mask controlsDouble-click the image that carries the mask.Double-click
Hide mask controlsReturnorEnterorDouble-click
Define as media placeholderCtrl+Option+Cmd+I

Moving, resizing and reshaping objects 18

ActionMac
Nudge the selected objectEach press shifts it one point, which Apple's table also describes as a single screen pixel.Arrow keys
Nudge the object ten pointsApple's table also gives this distance as ten screen pixels.Shift+Arrow keys
Duplicate the objectCmd+DorOption+Drag
Constrain movement to 45°Limits the direction of the drag to 45-degree steps.Shift+Drag
Turn off alignment guidesWorks while moving an object and also while resizing it.Cmd+Drag
Resize from the centerDrag a selection handle with the key held down.Option+Drag
Resize keeping proportionsDrag a selection handle; the aspect ratio stays fixed.Shift+Drag
Resize from center, keep proportionsBoth constraints at once: the aspect ratio holds and the middle stays put.Option+Shift+Drag
Rotate the objectDrag one of the selection handles while holding Cmd.Cmd+Drag
Rotate in 45° stepsAdd Shift to the Cmd-drag used for rotating.Shift+Cmd+Drag
Rotate around the opposite handleThe object turns about the handle across from the one you drag, not about its middle.Option+Cmd+Drag
Rotate 45° around opposite handleSame pivot on the far handle, with the angle limited to 45° steps.Option+Shift+Cmd+Drag
Draw with the Pen toolSwitches to the Pen tool for drawing a shape of your own.Option+Shift+Cmd+P
Make a shape editableThe double-click goes on the outline of the custom shape.Double-click
Delete a shape pointClick the point of the editable shape first, then press the key.Delete
Insert a sharp pointStart the drag on the midpoint of a line of the shape.Cmd+Drag
Insert a Bézier pointStart the drag on the midpoint of one of the shape's lines.Option+Drag
Convert curve point to cornerDouble-click the curved point of an editable shape.Double-click

Rows, columns and table layout 21

ActionMac
Insert row aboveOption+Up
Insert row belowOption+Down
Insert column on the rightOption+Right
Insert column on the leftOption+Left
Append a rowHappens when the selected cell is in the table's last row.Return
Append a columnHappens when the selected cell is in the right-most column.Tab
Drag to add or remove rowsUse the button at the table's lower-right corner; rows and columns holding content are included.Option+Drag
Delete selected rowsOption+Cmd+Delete
Delete selected columnsCtrl+Cmd+Delete
Cancel a row or column movePress it while still dragging the rows or columns being reordered.Esc
Merge the selected cellsCtrl+Cmd+M
Unmerge the selected cellsCtrl+Shift+Cmd+M
Toggle the top borderCtrl+Option+Cmd+Up
Toggle the bottom borderCtrl+Option+Cmd+Down
Toggle the right borderCtrl+Option+Cmd+Right
Toggle the left borderCtrl+Option+Cmd+Left
Delete table or cell contentsRemoves the whole table when it is selected, otherwise empties the selected cells.Delete
Nudge the selected tableEach press moves the table by a single point.Arrow keys
Nudge the table ten pointsShift+Arrow keys
Constrain table movementThe table also snaps to guides while you drag it.Shift+Drag
Resize columns proportionatelySelect the table, then drag one of its resize handles with Shift held.Shift+Drag

Selecting cells and tables 28

Cmd + Return selects the parent of whatever is selected: from text being edited to its cell, from a cell selection to its table.

ActionMac
Select an adjacent cellStarts from a selected cell and moves one cell in the arrow's direction.Arrow keys
Extend the cell selectionGrows the selection by a single cell per press.Shift+Arrow keys
Select the next cellAt the end of a row it adds a new column instead.Tab
Select the previous cellShift+Tab
Select the cell belowReturn
Select the cell aboveShift+Return
Select a cell with the mouseOne click is enough in a selected table; an unselected table needs a double-click.ClickorDouble-click
Select additional cellsShift+Click
Add or remove one cellClicking a selected cell takes it out of the selection; an unselected one joins it.Cmd+Click
Select additional rowsShift+UporShift+Down
Select additional columnsShift+RightorShift+Left
Select entire rowsTakes every row that the present selection touches.Option+Cmd+Return
Select entire columnsTakes every column that the present selection touches.Ctrl+Cmd+Return
Select body cells onlyDouble-click a column's letter or a row's number.Double-click
Jump to row's first filled cellOption+Cmd+Left
Jump to row's last filled cellOption+Cmd+Right
Jump to column's first filled cellOption+Cmd+Up
Jump to column's last filled cellOption+Cmd+Down
Extend to row's first filled cellOption+Shift+Cmd+Left
Extend to row's last filled cellOption+Shift+Cmd+Right
Extend to column's first filled cellOption+Shift+Cmd+Up
Extend to column's last filled cellOption+Shift+Cmd+Down
Select the tableGoes from a cell selection to the table that holds it.Cmd+Return
Select the parentSteps out one level from whatever is selected.Cmd+Return
Select the table's first cellWorks when the table itself is selected.Option+Return
Select all table contentCmd+A
Select the table nameShift+Tab
Highlight a cell's row and columnHold the key while moving the pointer across the cells.Option

Editing cells 16

ActionMac
Edit a cellOption+Return
Finish editing the cellLeaves editing with that same cell still selected.Cmd+Return
Leave editing and select tableThe first press selects the cell being edited, the second its table.Cmd+ReturnthenCmd+Return
Insert a tab in a cellFor text or a formula being edited, where plain Tab would move to another cell.Option+Tab
Line break in a cellA soft return inside the cell text you are editing.Shift+Option+Return
Paragraph break in a cellA hard return inside the cell text you are editing.Option+Return
Copy a cell by draggingDrops a copy of the selected cell's contents into the cell you drag to.Option+Drag
Copy cell styleOption+Cmd+C
Paste cell styleOption+Cmd+V
Paste keeping destination styleThe pasted content takes the style of the cell it lands in.Option+Shift+Cmd+V
Auto-align cell contentOption+Cmd+U
Open a cell's pop-up menuWorks on a selected cell that contains a pop-up menu.Space
Choose a pop-up menu valueReturnorSpace
Toggle a checkboxApplies to a selected cell that holds a checkbox.SpaceorYorN
Set a star ratingType how many stars the selected rating cell should show.0or1or2or3or4or5
Insert an equationOption+Cmd+E

Formulas and cell references 15

Ctrl + = does two jobs: on a selected cell it opens the Formula Editor with the cell's contents, and in an open Formula Editor it turns the formula into text.

ActionMac
Start a new formulaTyping the equal sign opens the Formula Editor empty.=
Open the Formula EditorOpens it with whatever the selected cell already contains.Ctrl+=
Convert formula to textApplies to the formula in the Formula Editor while it is open.Ctrl+=
Edit a formula cellOpens the Formula Editor on a cell that holds a formula or a formatted number.Double-clickorOption+Return
Save formula changesConfirms the edits made in the Formula Editor.ReturnorTab
Discard formula changesLeaves the Formula Editor without keeping the edits.Esc
Paste formula resultsPastes what the formulas calculated, not the formulas themselves.Shift+Cmd+V
Pick a cell for a referenceWhile building a formula, moves to one cell and selects it as the reference.Option+Arrow keys
Resize a cell referenceMakes the selected reference larger or smaller, one arrow press at a time.Option+Shift+Arrow keys
Reference the outermost nonheader cellJumps along the row or column to its first or last cell that is not a header.Option+Cmd+Arrow keys
Line break in a formulaOption+Return
Cycle reference type forwardSteps through the absolute and relative options for the selected cell references.Cmd+K
Cycle reference type backwardSteps through the same absolute and relative options in reverse order.Shift+Cmd+K
Cycle range-end types forwardChanges absolute or relative on the start and end cells of the selected references.Option+Cmd+K
Cycle range-end types backwardGoes back through the options for the start and end cells of the references.Option+Shift+Cmd+K

Filtering, sorting and autofill 7

ActionMac
Toggle filtersOption+Cmd+F
Apply sorting rulesShift+Cmd+R
Collapse category groupsCmd+8
Expand category groupsCmd+9
Turn on autofill modeCmd+\
Autofill from preceding columnCtrl+Cmd+\
Autofill from row aboveOption+Cmd+\

Charts 3

ActionMac
Edit chart data referencesShift+Cmd+D
Nudge the chart legendSelect the legend first; each press moves it one point.Arrow keys
Nudge the legend ten pointsWith the legend selected, hold Shift while pressing an arrow key.Shift+Arrow keys

Notes

Moving and entering

Tab selects the next cell and Return the cell below; adding Shift reverses each. At the edges the same keys grow the table: Tab in the right-most column adds a column, and Return in the bottom row adds a row. Option + Tab types a tab inside the cell instead of moving on. Option + Down and Option + Right insert a row below or a column to the right of the selected cells. Option + Return starts editing the selected cell, and Cmd + Return ends editing with the cell still selected.

Formulas and formatting

Typing = in a selected cell opens an empty Formula Editor, and Ctrl + = opens it with what the cell already holds; Return or Tab saves the formula and Esc discards the changes. Shift + Cmd + V pastes formula results. Cmd + K turns selected text into a link, but in a formula it steps through the absolute and relative options of the selected cell references. Cell text takes the usual trio — bold Cmd + B, italic Cmd + I, underline Cmd + U. Apple's list has no keys for number formats or for inserting a sum.

Filled cells, whole rows and cell controls

Option + Cmd + Left and Option + Cmd + Right jump to the first and last populated cell of the current row, and Option + Cmd + Up and Option + Cmd + Down do the same within the column; with Shift held as well, the selection stretches to that cell instead. While a cell reference is being picked in a formula, Option + Cmd with an arrow key goes to the first or last nonheader cell of the row or column. Option + Cmd + Return selects every row that crosses the selection and Ctrl + Cmd + Return every such column. Cells with controls take plain keys: Space opens a pop-up menu, Space / Y / N checks or unchecks a checkbox, and a digit from 0 to 5 sets the stars of a rating cell.

Questions

Which key opens the Formula Editor in Numbers?

Typing = in a selected cell opens an empty Formula Editor, and Ctrl + = opens it with the contents of the selected cell. Return or Tab saves the formula; Esc discards the changes.

Does Numbers have a keyboard shortcut for AutoSum?

Apple's keyboard shortcut list for Numbers on Mac has no key for inserting a sum. A formula starts with =, which opens the Formula Editor.

Which keys insert or delete rows and columns in a Numbers table?

With cells selected, the Option-arrow keys insert next to them: Option + Up a row above, Option + Down a row below, Option + Left a column to the left and Option + Right a column to the right. Selecting a cell in the last row and pressing Return, or in the right-most column and pressing Tab, also grows the table. Option + Cmd + Delete removes the selected rows and Ctrl + Cmd + Delete the selected columns.

Which shortcut puts a Numbers cell into edit mode?

Select the cell and press Option + Return. Cmd + Return stops editing and leaves the cell selected; pressing it twice selects the table.

Is there an autofill shortcut in Numbers for Mac?

Cmd + \ turns on autofill mode. Ctrl + Cmd + \ autofills from the column before, and Option + Cmd + \ from the row above.

Sources and checks

Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.

7 rows from the earlier version of this page were removed in that check: duplicates, and bindings the documentation does not list or lists differently.

Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.