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

Open Numbers help

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