Numbers for Mac: Numbers for Mac keyboard shortcuts
You can use keyboard shortcuts to quickly accomplish many tasks in Numbers. To use a keyboard shortcut, press all the keys in the shortcut at the same time. Shortcuts for common commands are listed in the table below.
Move around within a spreadsheet
| Action | Shortcut |
|---|---|
| Move one character to the left | Left Arrow |
| Move one character to the right | Right Arrow |
| Move one character backward (works for left-to-right and right-to-left text) | Control-B |
| Move one character forward (works for left-to-right and right-to-left text) | Control-F |
| Move to the line above | Up Arrow |
| Move to the line below | Down Arrow |
| Move to the beginning of the current or previous word | Option-Left Arrow or Option-Control-B |
| Move to the end of the current or next word | Option-Right Arrow or Option-Control-F |
| 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 |
| Find the selected item in the spreadsheet | With the Find window open, select text, then press Command-E |
| 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 |
| Scroll to the end of the sheet | End |
| Center the insertion point in the app window | Control-L |
| Move down a page | Control-V |
Select text
| Action | Shortcut |
|---|---|
| Select one or more characters | Click in front of the first character and drag across the characters you want to select |
| 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 the text selection | Click in the text, then Shift-click in another location in the text |
| Extend the selection one character to the right | Shift-Right Arrow |
| Extend the selection one character to the left | Shift-Left Arrow |
| Extend the selection to the end of the current word, then to the end of subsequent words | Option-Shift-Right Arrow |
| Extend the selection to the beginning of the current word | Option-Shift-Left Arrow |
| Extend the selection to the end of the current line | Shift-Command-Right Arrow |
| Extend the selection to the beginning of the current line | Shift-Command-Left Arrow |
| Extend the selection to the line above | Shift-Up Arrow |
| Extend the selection to the line below | Shift-Down Arrow |
| Extend the selection to the beginning of the current paragraph | Shift-Option-Up Arrow |
| Extend the selection to the end of the current paragraph | Shift-Option-Down Arrow |
| Extend the selection to the beginning of the text | Shift-Command-Up Arrow or Shift-Home |
| Extend the selection to the end of the text | Shift-Command-Down Arrow or Shift-End |
| Select a bullet and its text | Click the bullet |
| Move a bullet and its text, with its sub-bullets and text | Click the bullet and drag |
Format text
| Action | Shortcut |
|---|---|
| Show the Fonts window | Command-T |
| Show the Colors window | Shift-Command-C |
| Apply boldface to selected text | Command-B |
| Apply italic to selected text | Command-I |
| Apply underline to selected text | Command-U |
| Delete the previous character or selection | Delete or Control-H |
| Delete the next character or selection | Control-D or Forward Delete (not available on all keyboards) |
| Delete the word before the insertion point | Option-Delete |
| Delete the word after the insertion point | Option-Forward Delete (not available on all keyboards) |
| Delete the text between the insertion point and the next paragraph break | Control-K |
| Make the font size bigger | Command-Plus Sign (+) |
| Make the font size smaller | Command-Minus Sign (-) |
| Decrease the space between selected characters | Option-Command-Left Bracket ([) |
| Increase the space between selected characters | Option-Command-Right Bracket (]) |
| Make the text superscript | Control-Shift-Command-Plus Sign (+) |
| Make the text subscript | Control-Command-Minus Sign (-) |
| Decrease the indent level of a block of text or a list item | Command-Left Bracket ([) |
| Increase the indent level of a block of text or a list item | Command-Right Bracket (]) |
| Decrease the indent level of a list item or headline | Shift-Tab |
| Increase the indent level of a list item or headline | Tab |
| Add a hyperlink to text | Command-K |
| Cut the selection | Command-X |
| Copy the selection | Command-C |
| Copy the paragraph style | Option-Command-C |
| Paste the selection | Command-V |
| Paste the paragraph style | Option-Command-V |
| Paste and match the style of the destination text | Option-Shift-Command-V |
| Add a range to (or remove it from) the selection | Shift-drag or Command-drag |
| Insert a nonbreaking space | Option-Space bar |
| Insert a line break (soft return) | Shift-Return |
| Insert a paragraph break | Return |
| Insert a new line after the insertion point | Control-O |
| Enter special characters | Control-Command-Space |
| Transpose the characters on either side of the insertion point | Control-T |
Use editing tools
| Action | Shortcut |
|---|---|
| Delete the previous character or selection | Delete |
| Delete the next character or selection | Fn-Delete or Forward Delete (not available on all keyboards) |
| Find | Command-F |
| Find next | Command-G |
| Find previous | Shift-Command-G |
| Place the selected text in the Find & Replace text field | Command-E |
| Replace text | Return |
| Scroll the window to show the selected text or object | Command-J |
| Hide the Find window | Esc |
| Look up the word at the insertion point | Control-Command-D |
| Display a list of words to complete the selected word | Option-Esc |
| Check spelling and grammar | Command-Semicolon (;) |
| Show the Spelling and Grammar window | Shift-Command-Colon (:) |
| Add a comment | Shift-Command-K |
| Show the next comment | Option-Command-K |
| Show the previous comment | Option-Shift-Command-K |
Manipulate objects
| Action | Shortcut |
|---|---|
| Select all objects | Select one object, then press Command-A |
| Deselect all objects | Select one object, then press Shift-Command-A |
| Select objects by dragging | Drag from a blank part of the sheet around objects. Option-drag to select objects outward from the starting point |
| Scroll zoom | Option-Command-scroll (available with a Magic Mouse or a trackpad only) |
| Add or remove objects from the selection | Command-drag |
| Select the next object on the sheet | Tab |
| Select the previous object on the sheet | Shift-Tab |
| Select or deselect additional objects | Command-click or Shift-click |
| Move selected objects | Drag |
| Move the selected object one point | Press an arrow key |
| Move the selected object ten points | Press Shift and an arrow key |
| Move the selected object one screen pixel | Press Option and an arrow key (for Retina display only) |
| Move the selected object ten screen pixels | Press Option-Shift and an arrow key (for Retina display only) |
| Copy the graphic style | Option-Command-C |
| Paste the graphic style | Option-Command-V |
| Apply the shape style, but not the text style | Press Option and click a shape or text box style in the sidebar |
| Send the selected object to the back | Shift-Command-B |
| Send the selected object one layer back | Option-Shift-Command-B |
| Bring the selected object to the front | Shift-Command-F |
| Bring the selected object one layer forward | Option-Shift-Command-F |
| Group selected objects | Option-Command-G |
| Ungroup selected objects | Option-Shift-Command-G |
| Select an object in a group | Double-click the object |
| Select the next object in a group | Tab |
| Select the previous object in a group | Shift-Tab |
| End editing an object and select the group | With an object in a group selected, press Command-Return |
| Lock selected objects | Command-L |
| Unlock selected objects | Option-Command-L |
| Duplicate the object | Command-D or Option-drag |
| Constrain the movement of the object to 45° | Shift-drag |
| Resize the object | Drag a selection handle |
| Disable alignment guides while resizing | Command-drag |
| Resize the object from the center | Option-drag a selection handle |
| Constrain the aspect ratio when resizing the object | Shift-drag a selection handle |
| Constrain the aspect ratio when resizing the object from the center | Option-Shift-drag a selection handle |
| Rotate the object | Command-drag a selection handle |
| Rotate the object 45° | Press Shift while rotating |
| Rotate the object around the opposite handle (instead of the center) | Option-Command-drag a selection handle |
| Rotate the object 45° around the opposite handle (instead of the center) | Option-Shift-Command-drag a selection handle |
| Turn off alignment guides while moving an object | Command-drag |
| Mask or unmask the object | Shift-Command-M |
| Hide mask controls | Return, Enter, or double-click |
| Show mask controls | Double-click the masked image |
| Open the shortcut menu for the selected item | Control-click the item |
| Exit text editing and select the object | Command-Return |
| Define the object as a media placeholder | Control-Option-Command-I |
Work with tables
| 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 the selected cells | Option-Right Arrow |
| Add a column to the left of the selected cells | Option-Left Arrow |
| Add or remove rows and columns with content | Option-drag the resize button |
| 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 |
| Select an entire row or column | Click the table, then click the lettered bar for the column or the numbered bar for the row |
| Select additional rows | Shift-Up Arrow or Shift-Down Arrow |
| Select additional columns | Shift-Right Arrow or Shift-Left Arrow |
| Select additional cells | Shift-click |
| Select only body cells in a row or column | Double-click the lettered bar for the column or the numbered bar for the row |
| Stop the reordering of rows or columns | Press Esc while dragging |
| Select a table from a cell selection | Command-Return |
| Select all content in a table | Command-A |
| Delete the selected table, or the contents of selected cells | Delete |
| Constrain the movement of the table and snap to guides | Shift-drag the table |
| Replace the contents of the selected cell with the contents of the destination cell | Drag the selected cell to another cell |
| Copy the contents of the selected cell into the destination cell | Option-drag the selected cell to another cell |
| Copy cell style | Option-Command-C |
| Paste cell style | Option-Command-V |
| Paste and preserve the style of the destination cell | Control-Shift-Command-V |
| Select a cell | Click a cell in a selected table (double-click a cell in an unselected table) |
| Edit a cell | Option-Return |
| Highlight the row and column for a cell | Press Option as you hover over a cell |
| Open a pop-up menu in a selected cell | Space bar |
| Select a value in a pop-up menu in a selected cell | Return or Space bar |
| Check or uncheck a checkbox in a selected cell | Space bar, Y, or N |
| Set the number of stars for a selected star rating cell | 0, 1, 2, 3, 4, or 5 |
| Set the value for a slider in a selected cell | Type a value that’s within the slider range |
| Add a cell to (or remove it from) the selection | Command-click a selected or unselected cell |
| Auto align cell content | Option-Command-U |
| Stop editing the cell and select the cell | Command-Return |
| Stop editing the cell and select the table | Command-Return twice |
| Move the selected table one point | Press an arrow key |
| Move the selected table ten points | Press Shift and an arrow key |
| Resize all columns in a table proportionately | Select the table, then Control-drag a resize handle |
| Select the next cell or, if the last cell is selected, add a new row | Tab |
| Select the previous cell | Shift-Tab |
| Select the cell below | Return |
| Select the cell above | Shift-Return |
| Select the cell to the left, right, up, or down | Press an arrow key (from a selected cell) |
| Extend the cell selection by one cell | Press Shift and an arrow key (from a selected cell) |
| Select the parent of the current selection | Command-Return |
| Insert a tab when editing text or a formula | Option-Tab |
| Insert a line break (soft return) when editing text in a cell | Control-Return |
| Insert a paragraph break (hard return) when editing text in a cell | Return |
| Open the Formula Editor with the contents of the selected cell | Control-Equal Sign (=) |
| Convert the formula in the open Formula Editor to text | Control-Equal Sign (=) |
| Open the empty Formula Editor | Equal Sign (=) |
| Open the Formula Editor for the cell containing a formula or formatted number | Double-click or Option-Return |
| Paste formula results | Shift-Command-V |
| In the Formula Editor, save changes | Return or Tab |
| In the Formula Editor, discard changes | Esc (Escape) |
Work with charts
| Action | Shortcut |
|---|---|
| Edit chart data references | Shift-Command-D |
| Move the chart legend one point | Select the legend, then press an arrow key |
| Move the chart legend ten points | Select the legend, then hold down Shift and press an arrow key |
Create cell references in formulas
| Action | Shortcut |
|---|---|
| Navigate to and select a single cell | Press Option and an arrow key |
| Extend or shrink a selected cell reference | Press Option-Shift and an arrow key |
| Navigate to the first or last nonheader cell in a row or column | Press Option-Command and an arrow key |
| Insert a line break | Option-Return |
| Insert a tab | Option-Tab |
| Specify absolute and relative attributes of selected cell references | Press Command-K or Shift-Command-K to move forward or backward through options |
| Specify absolute and relative attributes of the first and last cells of selected cell references | Press Option-Command-K or Option-Shift-Command-K to move forward or backward through options |
Work with editable shapes
| Action | Shortcut |
|---|---|
| Make a custom shape editable | Double-click the edge of the shape |
| Draw a custom shape with the Pen tool | Option-Shift-Command-P |
| Move a point of an editable shape | Drag the point to another location |
| Delete a point of an editable shape | Click the point, then press Delete on your keyboard |
| Add a sharp point to an editable shape | Command-drag the midpoint of a line |
| Add a smooth point to an editable shape | Drag the midpoint of a line |
| Add a Bézier point to an editable shape | Option-drag the midpoint of a line |
| Change a curve point of an editable shape into a corner point | Double-click the curved point |
| Reshape the curve of a smooth point | Drag the line adjacent to the smooth point |
| Reshape the curve of a Bézier point | Click a Bézier point, then drag the control |
General
| Action | Shortcut |
|---|---|
| Start dictation | Press Fn twice |
| Open a new spreadsheet | Command-N |
| Choose a template and create a new spreadsheet | Enter |
| Open an existing spreadsheet | Command-O |
| Close the template chooser | Esc |
| Save a spreadsheet | Command-S |
| Save as | Option-Shift-Command-S |
| End editing the spreadsheet or sheet name | Return |
| Duplicate a spreadsheet | Shift-Command-S |
| End editing the spreadsheet or sheet name and restore the original name | Esc (Escape) |
| Print a spreadsheet | Command-P |
| Add a new sheet | Shift-Command-N |
| Switch to the previous sheet | Command-Shift-Left Bracket ({) |
| Switch to the next sheet | Command-Shift-Right Bracket (}) |
| Switch to the first sheet | Option-Command-Shift-Left Bracket ({) |
| Switch to the last sheet | Option-Command-Shift-Right Bracket (}) |
| Scroll one page up in print preview | Page Up |
| Scroll one page down in print preview | Page Down |
| Preview a sheet or spreadsheet | Option-Command-P |
| Open Numbers Help | Command-Shift-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 | Command-Right Angle Bracket (>) |
| Zoom out | Command-Left Angle Bracket (<) |
| Show the Preferences window | Command-Comma (,) |
| Zoom to selection | Shift-Command-0 |
| Return to actual size | Command-0 |
| Show the spreadsheet rulers | Command-R |
| Show the Colors window | Command-Shift-C |
| Hide or show the toolbar | Command-Option-T |
| Rearrange an item in the toolbar | Command-drag |
| Remove an item from the toolbar | Command-drag away from the toolbar |
| 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 | Command-Option-H |
| Undo the last action | Command-Z |
| Redo the last action | Command-Shift-Z |
| Quit Numbers | Command-Q |
| Quit Numbers and keep windows open | Option-Command-Q |