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 |
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 |
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
Action | Shortcut |
---|---|
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 (:) |
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 | Available with a Magic Mouse or a trackpad only. 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 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 Format inspector |
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 |
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 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 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) |
Edit chart data
Action | Shortcut |
---|---|
Edit chart data | Shift-Command-D |
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 |
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 |
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 |
Change the spreadsheet orientation (landscape or portrait) | Command-Option-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 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 |