Apple Numbers

Apple's spreadsheet application with beautiful templates, charts, and iCloud collaboration

170 shortcuts

MacWindows

General

Action	Shortcut
New spreadsheet	`⌘+N`
Open spreadsheet	`⌘+O`
Save	`⌘+S`
Save as	`⌥+⇧+⌘+S`
Duplicate spreadsheet	`⇧+⌘+S`
Print	`⌘+P`
Close window	`⌘+W`
Close all windows	`⌥+⌘+W`
Minimize window	`⌘+M`
Full-screen view	`⌃+⌘+F`
Undo	`⌘+Z`
Redo	`⇧+⌘+Z`
Zoom in	`⇧+⌘+>`
Zoom to selection	`⇧+⌘+0`
Actual size	`⌘+0`
Show rulers	`⌘+R`
Show Colors window	`⇧+⌘+C`
Hide/show toolbar	`⌥+⌘+T`
Hide/show sidebar	`⌥+⌘+I`
Open Numbers User Guide	`⇧+⌘+?`
Settings	`⌘or`
Quit Numbers	`⌘+Q`

Sheets

Action	Shortcut
Add new sheet	`⇧+⌘+N`
Switch to previous sheet	`⇧+⌘+{`
Switch to next sheet	`⇧+⌘+}`
Switch to first sheet	`⌥+⇧+⌘+{`
Switch to last sheet	`⌥+⇧+⌘+}`
Select sheet 1-7	`⌘+1through⌘+7`

Action	Shortcut
Move left	`←`
Move right	`→`
Move up	`↑`
Move down	`↓`
Previous word	`⌥+←`
Next word	`⌥+→`
Beginning of text area	`⌘+↑`
End of text area	`⌘+↓`
Beginning of line	`⌘+←`
End of line	`⌘+→`
Beginning of paragraph	`⌥+↑`
End of paragraph	`⌥+↓`
Jump to selection	`⌘+J`
Scroll up	`PageUp`
Scroll down	`PageDown`
Beginning of sheet	`HomeorFn+↑`
End of sheet	`EndorFn+↓`

Selection

Action	Shortcut
Select word	`Doubleclick`
Select paragraph	`Tripleclick`
Select all	`⌘+A`
Deselect all	`⇧+⌘+A`
Extend selection right	`⇧+→`
Extend selection left	`⇧+←`
Extend to end of word	`⌥+⇧+→`
Extend to beginning of word	`⌥+⇧+←`
Extend to end of line	`⇧+⌘+→`
Extend to beginning of line	`⇧+⌘+←`
Extend selection up	`⇧+↑`
Extend selection down	`⇧+↓`
Extend to beginning of text	`⇧+⌘+↑`
Extend to end of text	`⇧+⌘+↓`

Text Formatting

Action	Shortcut
Show Fonts window	`⌘+T`
Bold	`⌘+B`
Italic	`⌘+I`
Underline	`⌘+U`
Increase font size	`⌘++`
Decrease font size	`⌘+-`
Superscript	`⌃+⌘++`
Subscript	`⌃+⌘+-`
Decrease character spacing	`⌥+⌘+[`
Increase character spacing	`⌥+⌘+]`
Decrease indent	`⌘+[`
Increase indent	`⌘+]`
Decrease list indent	`⇧+Tab`
Increase list indent	`Tab`

Editing

Action	Shortcut
Cut	`⌘+X`
Copy	`⌘+C`
Paste	`⌘+V`
Paste and match style	`⌥+⇧+⌘+V`
Copy paragraph style	`⌥+⌘+C`
Paste paragraph style	`⌥+⌘+V`
Delete previous character	`Delete`
Delete next character	`Fn+Delete`
Delete previous word	`⌥+Delete`
Delete next word	`⌥+Fn+Delete`
Turn into link	`⌘+K`
Nonbreaking space	`⌥+Space`
Line break	`⇧+↩`
Paragraph break	`⌥+↩`
Special characters	`⌃+⌘+Space`
Insert current time	`⌃+⇧+⌘+T`
Insert current date	`⌃+⇧+⌘+D`

Find & Replace

Action	Shortcut
Find	`⌘+F`
Find next	`⌘+G`
Find previous	`⇧+⌘+G`
Place selection in Find field	`⌘+E`
Scroll to selection	`⌘+J`
Hide Find window	`Esc`
Look up word	`⌃+⌘+D`
Word completion	`⌥+Esc`
Check spelling	`⌘+;`
Spelling window	`⇧+⌘+:`

Comments

Action	Shortcut
New comment	`⇧+⌘+K`
Save comment	`⌘+↩`
Next comment	`⌥+⌘+K`
Previous comment	`⌥+⇧+⌘+K`

Objects

Action	Shortcut
Select all objects	`⌘+A`
Deselect all objects	`⇧+⌘+A`
Select next object	`Tab`
Select previous object	`⇧+Tab`
Move object one point	`Arrowkey`
Move object ten points	`⇧Arrowkey`
Copy graphic style	`⌥+⌘+C`
Paste graphic style	`⌥+⌘+V`
Send to back	`⇧+⌘+B`
Send one layer back	`⌥+⇧+⌘+B`
Bring to front	`⇧+⌘+F`
Bring one layer forward	`⌥+⇧+⌘+F`
Group objects	`⌥+⌘+G`
Ungroup objects	`⌥+⇧+⌘+G`
Lock objects	`⌘+L`
Unlock objects	`⌥+⌘+L`
Duplicate object	`⌘+D`
Mask/unmask object	`⇧+⌘+M`
Insert equation	`⌥+⌘+E`

Tables

Action	Shortcut
Add row above	`⌥+↑`
Add row below	`⌥+↓`
Add column right	`⌥+→`
Add column left	`⌥+←`
Delete rows	`⌥+⌘+Delete`
Delete columns	`⌃+⌘+Delete`
Select intersecting rows	`⌥+⌘+↩`
Select intersecting columns	`⌃+⌘+↩`
Next cell	`Tab`
Previous cell	`⇧+Tab`
Select cell below	`↩`
Select cell above	`⇧+↩`
Edit cell	`⌥+↩`
Stop editing, select cell	`⌘+↩`
Merge cells	`⌃+⌘+M`
Unmerge cells	`⌃+⇧+⌘+M`
Copy cell style	`⌥+⌘+C`
Paste cell style	`⌥+⌘+V`
Paste preserving style	`⌥+⇧+⌘+V`
Auto-align content	`⌥+⌘+U`
Insert tab in cell	`⌥+Tab`
Line break in cell	`⇧+⌥+↩`
Paragraph break in cell	`⌥+↩`
Add/remove top border	`⌃+⌥+⌘+↑`
Add/remove bottom border	`⌃+⌥+⌘+↓`
Add/remove right border	`⌃+⌥+⌘+→`
Add/remove left border	`⌃+⌥+⌘+←`

Formulas

Action	Shortcut
Open Formula Editor	`⌃+=`
Open empty Formula Editor	`=`
Save Formula Editor changes	`↩orTab`
Discard Formula Editor changes	`Esc`
Paste formula results	`⇧+⌘+V`
Turn on autofill	`⌘+\`
Autofill from column before	`⌃+⌘+\`
Autofill from row above	`⌥+⌘+\`
Toggle absolute/relative reference	`⌘+Kor⇧+⌘+K`

Data

Action	Shortcut
Turn Filters on/off	`⌥+⌘+F`
Apply sorting rules	`⇧+⌘+R`
Collapse category groups	`⌘+8`
Expand category groups	`⌘+9`
First populated cell in row	`⌥+⌘+←`
Last populated cell in row	`⌥+⌘+→`
First populated cell in column	`⌥+⌘+↑`
Last populated cell in column	`⌥+⌘+↓`

Charts

Action	Shortcut
Edit chart data references	`⇧+⌘+D`
Move legend one point	`Arrowkey`
Move legend ten points	`⇧Arrowkey`