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.
Action | Shortcut |
|---|---|
Move around within a spreadsheet | |
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 | 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 |
Move to the beginning of the spreadsheet | Command–Up Arrow |
Move to the end of the spreadsheet | Command–Down Arrow |
Select text | |
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 | |
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 |
Delete the next character or selection | 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 (–) |
Align the text flush left | Command–Left Brace ({) |
Center the text | Command–Vertical Bar (|) |
Align the text flush right | Command–Right Brace (}) |
Align the text flush left and flush right (justify) | Option–Command–Vertical Bar (|) |
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 |
Insert a page break | Command-Enter or Command-Return-Fn |
Enter special characters | Control-Command-Space |
Transpose the characters on either side of the insertion point | Control-T |
Use editing tools | |
Find | Command-F |
Find next | Command-G |
Find previous | Shift-Command-G |
Find using selected text | Command-E |
Replace text | Return |
Jump to selection | 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 (:) |
Highlight text | Shift-Command-H |
Add a comment | Shift-Command-K |
Show the next comment | Option-Command-K |
Show the previous comment | Option-Shift-Command-K |
Accept a change (when change tracking is on) | Option-Command-A |
Reject a change (when change tracking is on) | Option-Command-R |
Manipulate objects | |
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 | For Magic Mouse or a trackpad. Option-Command-scroll |
Add or remove objects from the selection | Command-drag |
Select the next object on the sheet | Tab |
Select the previous object on the page | 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 |
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 |
Lock selected objects | Command-L |
Unlock selected objects | Option-Command-L |
Duplicate the object | Command-D |
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 |
Insert a mathematical equation or expression | Option-Command-E |
Define the object as a media placeholder | Control-Option-Command-I |
Work with tables | |
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–Right Arrow or Shift–Left Arrow |
Select additional columns | Shift–Up Arrow or Shift–Down 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 |
Paste and preserve the style of the destination cell | Control-Shift-Command-V |
Extend the selection from the selected cell to the destination cell | Shift-click in the destination cell |
Select a cell | Click a cell in a selected table (double-click a cell in an unselected table) |
Edit a cell | Option-Return |
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 |
Select the next 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 text in the next cell or, if the last cell is selected, add a new row | Tab |
Select the text in the previous cell | Shift-Tab |
Stop editing the cell and select the table | Command-Return twice |
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 | Option-Return |
Insert a paragraph break (hard return) when editing text in a cell | Return |
Open the Formula Editor for the selected nonformula cell | 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) |
Create cell references in formulas | |
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 |
Refer to another table below or above the current table | Press Option–Command–Page Down or Page Up, then press Option and an arrow key (or press Option-Shift and an arrow key to select cells) |
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 |
Edit chart data | |
Edit chart data | Shift-Command-D |
Complete a cell entry and move the selection down | Return |
Complete a cell entry and move the selection up | Shift-Return |
Complete a cell entry and move the selection to the right | Tab |
Complete a cell entry and move the selection to the left | Shift-Tab |
Move one character left, right, to the beginning of text (up), or to the end of text (down) | Press an arrow key (when editing text) |
Complete a cell entry and select the cell | Enter |
Move one cell in a given direction | Press an arrow key (from a selected cell) |
Move to the last nonblank cell at the end of the row | End |
Extend the selection by one cell | Press Shift and an arrow key |
Extend the selection to the end of the row | Shift-End |
Work with editable shapes | |
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 and press Delete |
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 Bezier 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 Bezier point | Click a Bezier point and drag the control |
General | |
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 |
Preview a sheet or the entire spreadsheet (depending on the setting in General preferences) | Command-Option-P |
Save a spreadsheet | 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 |
Scroll one page up in print preview | Page Up |
Scroll one page down in print preview | Page Down |
Print without a preview | Option-Command-P |
Open Numbers Help | Command–Shift–Question Mark (?) |
Close a window | Command-W |
Minimize a window | 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 Inspector window | Command-Option-I |
Show the spreadsheet rulers | Command-R |
Show or hide layout boundaries Para | Command-Shift-L |
Change the spreadsheet orientation (landscape or portrait) | Command-Option-R |
Show formatting characters (invisibles) | Command-Shift-I |
Show the Colors window | Command-Shift-C |
Hide or show the toolbar | Command-Option-T |
Hide or show inspectors | Option-Command-I |
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 |