Numbers Keyboard Shortcuts
Moving around in a spreadsheet
Action |
Shortcut |
|---|---|
| Scroll one screen up Scroll one page up (in Print View) |
Page Up |
| Scroll one screen left Scroll one page left (in Print View) |
Option-Page Up |
| Scroll one screen down Scroll one page down (in Print View) |
Page Down |
| Scroll one screen right Scroll one page right (in Print View) |
Option-Page Down |
| Scroll to beginning of sheet | Home |
| Scroll to end of sheet | End |
| Go to previous sheet | Command-Page Up |
| Go to previous sheet (if sheet is selected in Sheets pane) | Left Arrow or Up Arrow |
| Go to next sheet | Command-Page Down |
| Go to next sheet (if sheet is selected in Sheets pane) | Right Arrow or Down Arrow |
Moving around within text
Action |
Shortcut |
|---|---|
| Move one character to the left | Left Arrow |
| Move one character to the right | Right Arrow |
| Move to line above | Up Arrow |
| Move to line below | Down Arrow |
| Move to beginning of current or previous word | Option-Left Arrow |
| Move to end of current or next word | Option-Right Arrow |
| Move to beginning of current line | Command-Left Arrow |
| Move to beginning of current paragraph | Option-Up Arrow |
| Move to end of current paragraph | Option-Down Arrow |
Selecting text
Action |
Shortcut |
|---|---|
| Select one or more characters | Click in front of first character and drag across characters you want to select |
| Select a word | Double-click the word |
| Select a paragraph | Triple-click in the paragraph |
| Select all text within selected object | Command-A |
| Extend text selection | Click in the text and Shift-click in another location in the text |
| Extend selection one character to the right | Shift-Right Arrow |
| Extend selection one character to the left | Shift-Left Arrow |
| Extend selection to end of current word | Shift-Option-Right Arrow |
| Extend selection to beginning of current word | Shift-Option-Left Arrow |
| Extend selection to end of current line | Shift-Command-Right Arrow |
| Extend selection to beginning of current line | Shift-Command-Left Arrow |
| Extend selection to the line above | Shift-Up Arrow |
| Extend selection to the line below | Shift-Down Arrow |
| Extend selection to beginning of current paragraph | Shift-Option-Up Arrow |
| Extend selection to end of current paragraph | Shift-Option-Down Arrow |
| Extend selection to beginning of text | Shift-Command-Up Arrow or Shift-Home |
| Extend selection to end of text | Shift-Command-Down Arrow or Shift-End |
| Select multiple words or blocks of text that aren't next to each other | Select the first text you want and select additional text while holding down the Command key |
Formatting text
Action |
Shortcut |
|---|---|
| Show Font panel | Command-T |
| Make selected text bold | Command-B |
| Make selected text italic | Command-I |
| Underline selected text | Command-U |
| Delete previous character or selection | Delete |
| Delete next character or selection | Del (not available on all keyboards) |
| Make font size bigger | Command-plus sign (+) or Command-equal sign (=) |
| Make font size smaller | Command-minus sign (-) |
| Make text superscript | Control-Command-plus sign (+) |
| Make text subscript | Control-Command-minus sign (-) |
| Align text flush left | Command-{ (left brace) |
| Center text | Command-| |
| Align text flush right | Command-} (right brace) |
| Align text flush left and flush right (justify) | Option-Command-| |
| Edit hyperlink text without disabling hyperlink | Use arrow keys to move into hyperlink text |
| Cut | Command-X |
| Copy | Command-C |
| Paste | Command-V |
| Paste and match formatting of destination text | Option-Shift-Command-V |
| Insert nonbreaking space | Option-Space bar |
| Insert line break (soft return) | Shift-Return or Control-Return |
| Insert paragraph break | Return |
Manipulating objects
Action |
Shortcut |
|---|---|
| Draw shape | Option-click Shapes in toolbar, choose a shape, and drag cross hairs on canvas |
| Draw chart | Option-click Charts in toolbar, choose a chart, and drag cross hairs on canvas |
| Select all objects on sheet | Select one object and press Command-A |
| Deselect all objects | Select one object and press Command-Shift-A |
| Select or deselect additional objects | Command-click or Shift-click |
| Add range to or remove it from selection | Shift-drag or Command-drag |
| Move selected object one point | Arrow key |
| Move selected object ten points | Shift-arrow key |
| Send object to the back | Shift-Command-B |
| Send object one layer back | Option-Shift-Command-B |
| Bring object to the front | Shift-Command-F |
| Bring object one layer forward | Option-Shift-Command-F |
| Group objects | Option-Command-G |
| Ungroup objects | Option-Shift-Command-G |
| Lock objects | Command-L |
| Unlock objects | Option-Command-L |
| Duplicate object | Command-D or Option-drag |
| Constrain movement of object to 45º | Shift-drag |
| Resize object | Drag handle |
| Resize object from center | Option-drag handle |
| Constrain aspect ratio when resizing object | Shift-drag handle |
| Constrain aspect ratio when resizing object from center | Option-Shift-drag handle |
| Rotate object | Command-drag handle |
| Rotate object 45º | Shift-Command-drag handle |
| Rotate object around opposite handle (instead of center) | Command-Option-drag handle |
| Rotate object 45º around opposite handle (instead of center) | Shift-Command-Option-drag handle |
| Turn off alignment guides | Command-drag |
| Mask or unmask object | Shift-Command-M |
| Exit mask mode | Return, Command-Return, Enter, or double-click |
| Reenter mask mode | Double-click masked image |
| Open shortcut menu for selected item | Control-click |
| Exit text edit mode and select object | Command-Return |
Working with tables
Action |
Shortcut |
|---|---|
| Select all cell content in a table | Select a cell and press Command-A |
| Select all cell borders in a table | Select a border segment and press Command-A |
| Delete selected table or border segment or contents of selected cells | Delete |
| Constrain movement of table and snap to guides | Shift-drag table |
| Move contents of selected cell to another cell, replacing its contents | Drag selected cell by its border and release when other cell is selected |
| Copy contents of selected cell to another cell | Option-drag selected cell to the other cell |
| Extend selection from selected cell to another cell | Shift-click in the other cell or use Shift-arrow keys |
| Select cell | Click cell |
| Add cell to or remove it from selection | Command-click selected or unselected cell |
| Edit content in cell | Select cell and click once, twice, or three times |
| Stop editing cell and select cell | Command-Return |
| Select table | Command-click a selected cell |
| Select a single border segment (if border selection is on) | Double-click border segment of selected or unselected table |
| Select a long border segment (if border selection is on) | Click the segment in a selected or unselected table |
| Change single-segment selection to long-segment selection (if border selection is on) | Click selection |
| Add single or long border segment to selection (if border selection is on) | Shift-click or Command-click unselected border segment |
| Deselect single border segment (if border selection is on) | Shift-click or Command-click selected single segment |
| Move selected long border segment to new position (if border selection is on) | Drag selection |
| Move selected table, border, or long border segment one point | Arrow keys |
| Move selected table, border, or long border segment ten points | Shift-arrow keys |
| Move selected table, border, or long border segment ten points | Shift-arrow keys |
| Select next cell to the left, right, up, or down | Arrow keys (in cell selection mode) |
| Extend cell selection by one cell | Shift-arrow keys (in cell selection mode) |
| Select next cell | Tab |
| Add column to right side of table when "Return key moves to next cell" is selected | Select last cell in row and press Tab |
| Add new row at end of table when last cell is selected and "Return key moves to next cell" option is selected | Return |
| Add new row at end of table when last cell is selected and "Return key moves to next cell" option isn't selected | Tab from last cell in table |
| Select previous cell | Shift-Tab |
| Stop editing cells and select the table | Command-Return |
| Insert a tab when editing cell | 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 and "Return key moves to next cell" is selected | Option-Return |
| Insert a paragraph break (hard return) when editing text in a cell and "Return key moves to next cell" isn't selected | Return |
| Open table formatting menu for selected table or cells | Control-click table |
| Open Formula Editor to add a new formula | Select cell and type = |
| Open Formula Editor to edit a formula | Double-click cell |
| In Formula Editor, save changes | Return, Enter, or Accept button |
| In Formula Editor, discard changes | Escape, or Cancel button |
| Edit value in cell with cell format | Double-click cell |
Working with editable shapes
Action |
Shortcut |
|---|---|
| Make custom shape editable | Click the shape and then click again |
| Move a point of an editable shape | Click point and drag to another location |
| Delete a point of an editable shape | Click point and press Delete |
| Add a point to an editable shape | Option-click the shape edge where you want to add a point |
| Change a corner point of an editable shape into a curved point | Double-click the corner point |
| Change a curved point of an editable shape into a corner point | Double-click the curved point |
| Reshape the curve of an editable shape | Click a point on the curve and move the control handles |
Using Print View
Action |
Shortcut |
|---|---|
| Show pages in selected sheet | Option-Command-P |
General
Action |
Shortcut |
|---|---|
| Create new spreadsheet | Command-N (opens Template Chooser or template specified in Numbers preferences) |
| Open Template Chooser | Shift-Command-N |
| Open existing spreadsheet | Command-O |
| Save | Command-S |
| Save as | Shift-Command-S |
| Print selected sheet | Command-P |
| Command-? | |
| Find | Command-F |
| Find next | Command-G |
| Find previous | Shift-Command-G |
| Use selection for find | Command-E |
| Scroll to found selection | Command-J |
| Check spelling | Command-semicolon (;) |
| Show spelling window | Command-colon (:) |
| Zoom in | Command-> |
| Zoom out | Command-< |
| Close window | Command-W |
| Minimize window | Command-M |
| Show preferences | Command-comma (,) |
| Show Inspector window | Option-Command-I |
| Show document rulers | Command-R |
| Show layout | Shift-Command-L |
| Show Colors window | Shift-Command-C |
| Hide Numbers | Command-H |
| Hide other windows | Option-Command-H |
| Quit Numbers | Command-Q |