Office & Documents

Numbers Keyboard Shortcuts

195 shortcuts to analyze data on mac faster — the complete Numbers keyboard shortcut reference

Numbers keyboard shortcuts

Developed by Apple, Numbers is a widely used office & documents tool built to help users analyze data on mac.

Keyboard shortcuts are essential for working efficiently in Numbers. Memorizing even a handful of key combinations can cut hours from a weekly workflow.

Running only on macOS, Numbers offers a streamlined shortcut set tuned for its native platform.

macOS
195 shortcuts 9 categories
Visit Numbers Official Website
Jump to Section (9 sections)

General 49 shortcuts

Start dictation
Fn +D
Open the template chooser
Cmd +N
Open the template chooser and show the Language pop-up menu
Opt +Cmd +N
Open an existing spreadsheet
Cmd +O
Close the template chooser / End editing the spreadsheet or sheet name and restore the original name
Esc
Save a spreadsheet
Cmd +S
Save as
Opt +Shift +Cmd +S
End editing the spreadsheet or sheet name
Enter
Duplicate a spreadsheet
Shift +Cmd +S
Print a spreadsheet
Cmd +P
Add a new sheet
Shift +Cmd +N
Switch to the previous sheet
Shift +Cmd +[
Switch to the next sheet
Shift +Cmd +]
Switch to the first sheet
Opt +Shift +Cmd +[
Switch to the last sheet
Opt +Shift +Cmd +]
Scroll one page up in print preview
PageUp
Scroll one page down in print preview
PageDown
Preview a sheet or spreadsheet
Opt +Cmd +P
Open the Numbers User Guide
Shift +Cmd +?
Close a window
Cmd +W
Close all windows
Opt +Cmd +W
Minimize a window
Cmd +M
Minimize all windows
Opt +Cmd +M
Enter full-screen view
Ctrl +Cmd +F
Zoom in
Shift +Cmd +Right
Zoom out
Shift +Cmd +Left
Show the Settings window
Cmd +,
Zoom to selection
Shift +Cmd +0
Return to actual size
Cmd +0
Show the spreadsheet rulers
Cmd +R
Show the Colors window
Shift +Cmd +C
Hide or show the toolbar
Opt +Cmd +T
Rearrange an item in the toolbar / Remove an item from the toolbar
Cmd +Drag
Hide or show the sidebar
Opt +Cmd +I
Open the next tab of the sidebar
Ctrl +`
Open the previous tab of the sidebar
Ctrl +Shift +`
Hide Numbers
Cmd +H
Hide other windows
Opt +Cmd +H
Undo the last action
Cmd +Z
Redo the last action
Shift +Cmd +Z
Quit Numbers
Cmd +Q
Quit Numbers and keep windows open
Opt +Cmd +Q
Select one of the first seven sheets
Cmd +1
Select one of the first seven sheets
Cmd +2
Select one of the first seven sheets
Cmd +3
Select one of the first seven sheets
Cmd +4
Select one of the first seven sheets
Cmd +5
Select one of the first seven sheets
Cmd +6
Select one of the first seven sheets
Cmd +7

Move around within a spreadsheet 26 shortcuts

Move one character to the left
Left
Move one character to the right
Right
Move one character backward (works for left-to-right and right-to-left text)
Ctrl +B
Move one character forward (works for left-to-right and right-to-left text)
Ctrl +F
Move to the line above
Up
Move to the line below
Down
Move to the beginning of the current or previous word
Opt +Left
Move to the beginning of the current or previous word
Ctrl +Opt +B
Move to the end of the current or next word
Opt +Right
Move to the end of the current or next word
Ctrl +Opt +F
Move to the beginning of the current text area
Cmd +Up
Move to the bottom of the current text area
Cmd +Down
Move to the beginning of the current line
Cmd +Left
Move to the end of the current line
Cmd +Right
Move to the beginning of the current paragraph
Opt +Up
Move to the end of the current paragraph
Opt +Down
Find the selected item in the spreadsheet
Cmd +E
Jump to a selection in a spreadsheet
Cmd +J
Scroll up the sheet
PageUp
Scroll down the sheet
PageDown
Scroll to the beginning of the sheet
Home
Scroll to the beginning of the sheet
Fn +Up
Scroll to the end of the sheet
End
Scroll to the end of the sheet
Fn +Down
Center the insertion point in the app window
Ctrl +L
Move down a page
Ctrl +V

Select text 16 shortcuts

Select all objects and text
Cmd +A
Deselect all objects and text
Shift +Cmd +A
Extend the text selection
Shift +Right
Extend the selection one character to the left
Shift +Left
Extend the selection to the end of the current word, then to the end of subsequent words
Opt +Shift +Right
Extend the selection to the beginning of the current word
Opt +Shift +Left
Extend the selection to the end of the current line
Shift +Cmd +Right
Extend the selection to the beginning of the current line
Shift +Cmd +Left
Extend the selection to the line above
Shift +Up
Extend the selection to the line below
Shift +Down
Extend the selection to the beginning of the current paragraph
Opt +Shift +Up
Extend the selection to the end of the current paragraph
Opt +Shift +Down
Extend the selection to the beginning of the text
Shift +Cmd +Up
Extend the selection to the beginning of the text
Shift +Home
Extend the selection to the end of the text
Shift +Cmd +Down
Extend the selection to the end of the text
Shift +End
The BuildBox Macropad Puts Keyboard Shortcuts at Your Fingertips! Learn More

Tables 69 shortcuts

Insert an equation
Opt +Cmd +E
Add a row above the selected cells
Opt +Up
Add a row below the selected cells
Opt +Down
Add a column to the right of the selected cells
Opt +Right
Add a column to the left of the selected cells
Opt +Left
Delete selected rows
Opt +Cmd +Delete
Delete selected columns
Ctrl +Cmd +Delete
Select a value in a pop-up menu in a selected cell
Enter
Select the next cell or, if the last cell of a row is selected, add a new column
Tab
Select all rows that intersect the current selection
Opt +Cmd +Enter
Select all columns that intersect the current selection
Ctrl +Cmd +Enter
Select additional rows / Move the selected table ten points / Extend the cell selection by one cell
Shift +Up
Select additional rows / Move the selected table ten points / Extend the cell selection by one cell
Shift +Down
Select additional columns / Move the selected table ten points / Extend the cell selection by one cell
Shift +Right
Select additional columns / Move the selected table ten points / Extend the cell selection by one cell
Shift +Left
Select additional cells
Shift +Click
Stop editing the cell and select the table
Cmd +Enter
Open the Formula Editor for the cell containing a formula or formatted number
Opt +Enter
Select all content in a table
Cmd +A
Delete the selected table, or the contents of selected cells
Delete
Copy cell style
Opt +Cmd +C
Paste cell style
Opt +Cmd +V
Paste and preserve the style of the destination cell
Opt +Shift +Cmd +V
Open a pop-up menu in a selected cell / Select a value in a pop-up menu in a selected cell / Check or uncheck a checkbox in a selected cell
Space
Check or uncheck a checkbox in a selected cell
Y
Check or uncheck a checkbox in a selected cell
N
Set the number of stars for a selected star rating cell
0
Set the number of stars for a selected star rating cell
1
Set the number of stars for a selected star rating cell
2
Set the number of stars for a selected star rating cell
3
Set the number of stars for a selected star rating cell
4
Set the number of stars for a selected star rating cell
5
Set the value for a slider in a selected cell
Type a value
Add a cell to the selection
Cmd +Click
Auto-align cell content
Opt +Cmd +U
Move the selected table one point / Select the cell to the left, right, up, or down
Right
Move the selected table one point / Select the cell to the left, right, up, or down
Left
Move the selected table one point / Select the cell to the left, right, up, or down
Up
Move the selected table one point / Select the cell to the left, right, up, or down
Down
Resize all columns in a table proportionately
Shift +drag a resize handle
Select the previous cell / Select the table name
Shift +Tab
Select the cell above
Shift +Enter
Insert a tab when editing text or a formula
Opt +Tab
Insert a line break (soft return) when editing text in a cell
Opt +Shift +Enter
Open the Formula Editor with the contents of the selected cell / Convert the formula in the open Formula Editor to text
Ctrl +=
Open the empty Formula Editor
=
Paste formula results / Paste a formula result
Shift +Cmd +V
In the Formula Editor, discard changes
Esc
Turn Filters on or off
Opt +Cmd +F
Apply sorting rules
Shift +Cmd +R
Collapse selected category groups
Cmd +8
Expand selected category groups
Cmd +9
Select the first populated cell in the current row
Opt +Cmd +Left
Select the last populated cell in the current row
Opt +Cmd +Right
Select the first populated cell in the current column
Opt +Cmd +Up
Select the last populated cell in the current column
Opt +Cmd +Down
Expand the current selection to include the first populated cell in the current row
Opt +Shift +Cmd +Left
Expand the current selection to include the last populated cell in the current row
Opt +Shift +Cmd +Right
Expand the current selection to include the first populated cell in the current column
Opt +Shift +Cmd +Up
Expand the current selection to include the last populated cell in the current column
Opt +Shift +Cmd +Down
Merge selected cells
Ctrl +Cmd +M
Unmerge selected cells
Ctrl +Shift +Cmd +M
Add or remove the top border
Ctrl +Opt +Cmd +Up
Add or remove the bottom border
Ctrl +Opt +Cmd +Down
Add or remove the right border
Ctrl +Opt +Cmd +Right
Add or remove the left border
Ctrl +Opt +Cmd +Left
Turn on autofill mode
Cmd +\
Autofill from the column before
Ctrl +Cmd +\
Autofill from the row above
Opt +Cmd +\

Charts 9 shortcuts

Edit chart data references
Shift +Cmd +D
Move the chart legend one point
Right
Move the chart legend one point
Left
Move the chart legend one point
Up
Move the chart legend one point
Down
Move the chart legend ten points
Shift +Right
Move the chart legend ten points
Shift +Left
Move the chart legend ten points
Shift +Up
Move the chart legend ten points
Shift +Down

Formulas 18 shortcuts

Navigate to and select a single cell
Opt +Right
Navigate to and select a single cell
Opt +Left
Navigate to and select a single cell
Opt +Up
Navigate to and select a single cell
Opt +Down
Extend or shrink a selected cell reference
Opt +Shift +Right
Extend or shrink a selected cell reference
Opt +Shift +Left
Extend or shrink a selected cell reference
Opt +Shift +Up
Extend or shrink a selected cell reference
Opt +Shift +Down
Navigate to the first or last nonheader cell in a row or column
Opt +Cmd +Right
Navigate to the first or last nonheader cell in a row or column
Opt +Cmd +Left
Navigate to the first or last nonheader cell in a row or column
Opt +Cmd +Up
Navigate to the first or last nonheader cell in a row or column
Opt +Cmd +Down
Insert a line break
Opt +Enter
Insert a tab
Opt +Tab
Specify absolute and relative attributes of selected cell references
Cmd +K
Specify absolute and relative attributes of selected cell references
Shift +Cmd +K
Specify absolute and relative attributes of the first and last cells of selected cell references
Opt +Cmd +K
Specify absolute and relative attributes of the first and last cells of selected cell references
Opt +Shift +Cmd +K

File 3 shortcuts

Open a spreadsheet
Cmd +O
Save your spreadsheet
Cmd +S
Print a spreadsheet
Cmd +P

Edit 4 shortcuts

Undo the last action
Cmd +Z
Redo the last action
Shift +Cmd +Z
Copy selected text or objects
Cmd +C
Paste content
Cmd +V

Keyboard shortcuts 1 shortcut

Unknown - need more context
Cmd +X
Noticed errors or keyboard shortcuts that don't work? Please let us know about them here
BuildBox Macropad

We've Built 10s Of 1000s Of Keyboard Shortcuts Into The BuildBox Macropad

The BuildBox Macropad is the ultimate shortcut machine. One device with up to 160 configurable shortcuts for apps like Numbers available at your fingertips, a crystal clear display showing what every key does, and a hall-effect scroll wheel for scrubbing through video, audio and graphic editing applications like butter!

Drop your email below to be eligible for our first production run of 500 BuildBox units, at a HUGE discount price:

View All Keyboard Shortcuts

Keyboard Shortcuts for Similar Applications