Use keyboard shortcuts in Numbers on Mac

Start dictation

Press Fn twice

You can change this shortcut. Choose Apple menu  > System Preferences > Keyboard > Dictation.

Open the template chooser

Command-N

Open the template chooser and show the Language pop-up menu

Option-Command-N

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

Shift-Command-Left Brace ({)

Switch to the next sheet

Shift-Command-Right Brace (})

Switch to the first sheet

Option-Shift-Command-Left Brace ({)

Switch to the last sheet

Option-Shift-Command-Right Brace (})

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 the Numbers User Guide

Shift-Command-Question Mark (?)

Close a window

Command-W

Close all windows

Option-Command-W

Minimise a window

Command-M

Minimise 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 or hide the tab bar

Shift-Command-T

Show the spreadsheet rulers

Command-R

Show the Colours window

Shift-Command-C

Hide or show the toolbar

Option-Command-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

Option-Command-H

Undo the last action

Command-Z

Redo the last action

Shift-Command-Z

Quit Numbers

Command-Q

Quit Numbers and keep windows open

Option-Command-Q

Select one of the first seven sheets

Command-1 to 7 (for example, to select the second sheet, press Command-2)

Move one character to the left

Left Arrow

Move one character to the right

Right Arrow

Move one character back (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 Control-Option-B

Move to the end of the current or next word

Option-Right Arrow or Control-Option-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 or Fn-Up Arrow

Scroll to the end of the sheet

End or Fn-Down Arrow

Centre the insertion point in the app window

Control-L

Move down a page

Control-V

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

Option-Shift-Up Arrow

Extend the selection to the end of the current paragraph

Option-Shift-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

Show the Fonts window

Command-T

Show the Colours 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

Turn text into a link

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 non-breaking 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 bar

Transpose the characters on either side of the insertion point

Control-T

Apply a paragraph, character or list style using your own shortcut

Assign a shortcut key

Insert an equation

Option-Command-E

Insert the current time

Control-Shift-Command-T

Insert the current date

Control-Shift-Command-D

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 (while in the Find window)

Command-G

Find previous (while in the Find window)

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 (:)

Open a new comment for the selected text, object or table cell

Shift-Command-K

Save a comment

Command-Return

Show the next comment

Option-Command-K

Show the previous comment

Option-Shift-Command-K

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 outwards 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 an arrow key

Move the selected object ten screen pixels

Press Shift and an arrow key

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 centre

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 centre

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 centre)

Option-Command-drag a selection handle

Rotate the object 45° around the opposite handle (instead of the centre)

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

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

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 in the bottom-right corner of the table

Delete selected rows

Option-Command-Delete

Delete selected columns

Control-Command-Delete

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 letter for the column or the number for the row

Select all rows that intersect the current selection

Option-Command-Return

Select all columns that intersect the current selection

Control-Command-Return

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 letter for the column or the number for the row

Stop the reordering of rows or columns

Press Esc while dragging

Select a table from a cell selection

Command-Return

Select the first cell in a selected table

Option-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

Option-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

tick or untick a tickbox 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 Shift-drag a resize handle

Select the next cell or, if the last cell of a row is selected, add a new column

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)

Turn Filters on or off

Shift-Command-F

Apply sorting rules

Shift-Command-R

Collapse selected category groups

Command-8

Expand selected category groups

Command-9

Select the first populated cell in the current row

Option-Command-Left Arrow

Select the last populated cell in the current row

Option-Command-Right Arrow

Select the first populated cell in the current column

Option-Command-Up Arrow

Select the last populated cell in the current column

Option-Command-Down Arrow

Select the table name

Shift-Tab

Paste a formula result

Shift-Command-V

Expand the current selection to include the first populated cell in the current row

Option-Shift-Command-Left Arrow

Expand the current selection to include the last populated cell in the current row

Option-Shift-Command-Right Arrow

Expand the current selection to include the first populated cell in the current column

Option-Shift-Command-Up Arrow

Expand the current selection to include the last populated cell in the current column

Option-Shift-Command-Down Arrow

Merge selected cells

Control-Command-M

Unmerge selected cells

Control-Shift-Command-M

Add or remove the top border

Control-Option-Command-Up Arrow

Add or remove the bottom border

Control-Option-Command-Down Arrow

Add or remove the right border

Control-Option-Command-Right Arrow

Add or remove the left border

Control-Option-Command-Left Arrow

Turn on autofill mode

Command-Backslash (\)

Autofill from the column before

Control-Command-Backslash (\)

Autofill from the row above

Option-Command-Backslash (\)

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

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 non-header 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 forwards or backwards 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 forwards or backwards through options