Spreadsheets and sheets 19
Some of these shortcuts can be reassigned in System Settings, so a particular Mac may not match the table.
| Action | Mac |
|---|---|
| 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 spreadsheet | Cmd+O |
| Close the template chooser | Esc |
| Save the spreadsheet | Cmd+S |
| Save AsApple lists it beside Duplicate, which uses the same keys without Option. | Option+Shift+Cmd+S |
| Duplicate the spreadsheet | Shift+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 spreadsheet | Cmd+P |
| Open print previewPreviews a single sheet or the whole spreadsheet. | Option+Cmd+P |
| Previous page in print preview | Page Up |
| Next page in print preview | Page Down |
| Add a sheet | Shift+Cmd+N |
| Go to the previous sheet | Shift+Cmd+{ |
| Go to the next sheet | Shift+Cmd+} |
| Go to the first sheet | Option+Shift+Cmd+{ |
| Go to the last sheet | Option+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
| Action | Mac |
|---|---|
| Close the window | Cmd+W |
| Close all windows | Option+Cmd+W |
| Minimize the window | Cmd+M |
| Minimize all windows | Option+Cmd+M |
| Enter full screen | Cmd+Ctrl+F |
| Zoom in | Shift+Cmd+> |
| Zoom out | Shift+Cmd+< |
| Zoom to selection | Shift+Cmd+0 |
| Return to actual size | Cmd+0 |
| Zoom by scrollingRequires a trackpad or a Magic Mouse. | Option+Cmd+Scroll |
| Show the rulers | Cmd+R |
| Show or hide the toolbar | Option+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 sidebar | Option+Cmd+I |
| Next sidebar tab | Ctrl+` |
| Previous sidebar tab | Shift+Ctrl+` |
| Show the Colors window | Shift+Cmd+C |
| Open Settings | Cmd+, |
| Open the user guide | Shift+Cmd+? |
| Start dictationDictation options are under Keyboard in System Settings. | Fn+D |
| Undo | Cmd+Z |
| Redo | Shift+Cmd+Z |
| Hide Numbers | Cmd+H |
| Hide other windows | Option+Cmd+H |
| Quit Numbers | Cmd+Q |
| Quit and keep windows open | Option+Cmd+Q |
Selecting text 18
| Action | Mac |
|---|---|
| Select a word | Double-click |
| Select a paragraph | Triple-click |
| Select allTakes in every object and all text; start from one selected object to get only objects. | Cmd+A |
| Deselect all | Shift+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 character | Shift+Right |
| Extend selection left one character | Shift+Left |
| Extend selection to word endPress again to take in the following words one at a time. | Option+Shift+Right |
| Extend selection to word start | Option+Shift+Left |
| Extend selection to line end | Shift+Cmd+Right |
| Extend selection to line start | Shift+Cmd+Left |
| Extend selection up one line | Shift+Up |
| Extend selection down one line | Shift+Down |
| Extend selection to paragraph start | Option+Shift+Up |
| Extend selection to paragraph end | Option+Shift+Down |
| Extend selection to start of text | Shift+Cmd+UporShift+Home |
| Extend selection to end of text | Shift+Cmd+DownorShift+End |
Formatting text 17
| Action | Mac |
|---|---|
| Show the Fonts window | Cmd+T |
| Apply bold | Cmd+B |
| Apply italic | Cmd+I |
| Apply underline | Cmd+U |
| Increase font size | Cmd++ |
| Decrease font size | Cmd+- |
| 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 superscript | Ctrl+Cmd++ |
| Make text subscript | Ctrl+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 style | Option+Cmd+C |
| Paste paragraph style | Option+Cmd+V |
Editing and inserting text 18
Forward Delete is a separate key that some keyboards lack; Fn + Delete does the same job.
| Action | Mac |
|---|---|
| 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 word | Option+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 selection | Cmd+X |
| Copy the selection | Cmd+C |
| Paste | Cmd+V |
| Paste and Match StyleThe pasted text takes on the formatting of the text it lands in. | Option+Shift+Cmd+V |
| Insert a nonbreaking space | Option+Space |
| Insert a line breakApple also calls this a soft return. | Shift+Return |
| Insert a paragraph break | Option+Return |
| Insert a line after the cursor | Ctrl+O |
| Enter special characters | Ctrl+Cmd+Space |
| Transpose two charactersSwaps the characters on each side of the insertion point. | Ctrl+T |
| Insert the current time | Ctrl+Shift+Cmd+T |
| Insert the current date | Ctrl+Shift+Cmd+D |
Find, spelling and comments 15
| Action | Mac |
|---|---|
| Open the Find window | Cmd+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 text | Return |
| Jump to the selectionScrolls the window until the selected text or object is in view. | Cmd+J |
| Hide the Find window | Esc |
| 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 grammar | Cmd+; |
| Show Spelling and Grammar window | Shift+Cmd+: |
| Add a commentThe comment attaches to whichever text, object or cell is selected. | Shift+Cmd+K |
| Save a comment | Cmd+Return |
| Go to next comment | Option+Cmd+K |
| Go to previous comment | Option+Shift+Cmd+K |
Selecting and layering objects 24
| Action | Mac |
|---|---|
| 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 dragging | Cmd+Drag |
| Drag-select outwardThe selection area grows in every direction from where the drag begins. | Option+Drag |
| Select one grouped object | Double-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 style | Option+Cmd+C |
| Paste graphic style | Option+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 back | Shift+Cmd+B |
| Send backwardMoves the object down by a single layer. | Option+Shift+Cmd+B |
| Bring to front | Shift+Cmd+F |
| Bring forwardMoves the object up by a single layer. | Option+Shift+Cmd+F |
| Group the selected objects | Option+Cmd+G |
| Ungroup the selected objects | Option+Shift+Cmd+G |
| Lock the selected objects | Cmd+L |
| Unlock the selected objects | Option+Cmd+L |
| Toggle the object's mask | Shift+Cmd+M |
| Show mask controlsDouble-click the image that carries the mask. | Double-click |
| Hide mask controls | ReturnorEnterorDouble-click |
| Define as media placeholder | Ctrl+Option+Cmd+I |
Moving, resizing and reshaping objects 18
| Action | Mac |
|---|---|
| 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 object | Cmd+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
| Action | Mac |
|---|---|
| Insert row above | Option+Up |
| Insert row below | Option+Down |
| Insert column on the right | Option+Right |
| Insert column on the left | Option+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 rows | Option+Cmd+Delete |
| Delete selected columns | Ctrl+Cmd+Delete |
| Cancel a row or column movePress it while still dragging the rows or columns being reordered. | Esc |
| Merge the selected cells | Ctrl+Cmd+M |
| Unmerge the selected cells | Ctrl+Shift+Cmd+M |
| Toggle the top border | Ctrl+Option+Cmd+Up |
| Toggle the bottom border | Ctrl+Option+Cmd+Down |
| Toggle the right border | Ctrl+Option+Cmd+Right |
| Toggle the left border | Ctrl+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 points | Shift+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.
| Action | Mac |
|---|---|
| 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 cell | Shift+Tab |
| Select the cell below | Return |
| Select the cell above | Shift+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 cells | Shift+Click |
| Add or remove one cellClicking a selected cell takes it out of the selection; an unselected one joins it. | Cmd+Click |
| Select additional rows | Shift+UporShift+Down |
| Select additional columns | Shift+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 cell | Option+Cmd+Left |
| Jump to row's last filled cell | Option+Cmd+Right |
| Jump to column's first filled cell | Option+Cmd+Up |
| Jump to column's last filled cell | Option+Cmd+Down |
| Extend to row's first filled cell | Option+Shift+Cmd+Left |
| Extend to row's last filled cell | Option+Shift+Cmd+Right |
| Extend to column's first filled cell | Option+Shift+Cmd+Up |
| Extend to column's last filled cell | Option+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 content | Cmd+A |
| Select the table name | Shift+Tab |
| Highlight a cell's row and columnHold the key while moving the pointer across the cells. | Option |
Editing cells 16
| Action | Mac |
|---|---|
| Edit a cell | Option+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 style | Option+Cmd+C |
| Paste cell style | Option+Cmd+V |
| Paste keeping destination styleThe pasted content takes the style of the cell it lands in. | Option+Shift+Cmd+V |
| Auto-align cell content | Option+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 value | ReturnorSpace |
| 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 equation | Option+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.
| Action | Mac |
|---|---|
| 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 formula | Option+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
| Action | Mac |
|---|---|
| Toggle filters | Option+Cmd+F |
| Apply sorting rules | Shift+Cmd+R |
| Collapse category groups | Cmd+8 |
| Expand category groups | Cmd+9 |
| Turn on autofill mode | Cmd+\ |
| Autofill from preceding column | Ctrl+Cmd+\ |
| Autofill from row above | Option+Cmd+\ |
Charts 3
| Action | Mac |
|---|---|
| Edit chart data references | Shift+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 |
No row on this page matches that filter.
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
- Apple Support — Numbers User Guide for Mac (Numbers 15.4): Keyboard shortcuts for Numbers on Mac All rows: general, text, objects, editable shapes, tables, charts and cell references in formulas
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.