Clipboard
3 shortcuts
| Action |
Mac |
|
Paste the selection Anywhere
|
Cmd + V
|
|
Paste and match the destination style Editing text
|
Option + Shift + Cmd + V
|
|
Paste only the formula results Cells copied
|
Shift + Cmd + V
|
Comments and review
2 shortcuts
| Action |
Mac |
|
Preview the sheet for printing Anywhere
|
Option + Cmd + P
|
|
Add a comment to the selection Text, object or cell selected
|
Shift + Cmd + K
|
Editing
7 shortcuts
| Action |
Mac |
|
Show or hide the toolbar Anywhere
|
Option + Cmd + T
|
|
Undo the last action Anywhere
|
Cmd + Z
|
|
Redo the last action Anywhere
|
Shift + Cmd + Z
|
|
Insert the current time Editing text
|
Ctrl + Shift + Cmd + T
|
|
Insert the current date Editing text
|
Ctrl + Shift + Cmd + D
|
|
Check spelling and grammar Anywhere
|
Cmd + ;
|
|
Insert an equation Editing text
|
Option + Cmd + E
|
Files and printing
7 shortcuts
| Action |
Mac |
|
Open the template chooser Anywhere
|
Cmd + N
|
|
Open a spreadsheet Anywhere
|
Cmd + O
|
|
Save the spreadsheet Anywhere
|
Cmd + S
|
|
Save the spreadsheet under a new name Anywhere
|
Option + Shift + Cmd + S
|
|
Print the spreadsheet Anywhere
|
Cmd + P
|
|
Open the settings window Anywhere
|
Cmd + ,
|
|
Find the next match Find window open
|
Cmd + G
|
Formulas and data
18 shortcuts
| Action |
Mac |
|
Add a row above the selected cells Table cells selected
|
Option + Up arrow
|
|
Add a row below the selected cells Table cells selected
|
Option + Down arrow
|
|
Add a column to the right of the cells Table cells selected
|
Option + Right arrow
|
|
Add a column to the left of the cells Table cells selected
|
Option + Left arrow
|
|
Select every row the selection touches Table cells selected
|
Option + Cmd + Return
|
|
Select every column the selection touches Table cells selected
|
Ctrl + Cmd + Return
|
|
Open an empty Formula Editor Cell selected
|
=
|
|
Open the Formula Editor with the cell contents Cell selected
|
Ctrl + =
|
|
Turn filters on or off Table selected
|
Option + Cmd + F
|
|
Apply the sorting rules Table selected
|
Shift + Cmd + R
|
|
Collapse the selected category groups Categories in a table
|
Cmd + 8
|
|
Expand the selected category groups Categories in a table
|
Cmd + 9
|
|
Jump to the first filled cell in the row Cell selected
|
Option + Cmd + Left arrow
|
|
Jump to the last filled cell in the row Cell selected
|
Option + Cmd + Right arrow
|
|
Jump to the first filled cell in the column Cell selected
|
Option + Cmd + Up arrow
|
|
Jump to the last filled cell in the column Cell selected
|
Option + Cmd + Down arrow
|
|
Merge the selected cells Table cells selected
|
Ctrl + Cmd + M
|
|
Unmerge the selected cells Table cells selected
|
Ctrl + Shift + Cmd + M
|
Navigation
10 shortcuts
| Action |
Mac |
|
Duplicate the spreadsheet Anywhere
|
Shift + Cmd + S
|
|
Add a new sheet Anywhere
|
Shift + Cmd + N
|
|
Switch to the previous sheet Anywhere
|
Shift + Cmd + {
|
|
Switch to the next sheet Anywhere
|
Shift + Cmd + }
|
|
Switch to the first sheet Anywhere
|
Option + Shift + Cmd + {
|
|
Switch to the last sheet Anywhere
|
Option + Shift + Cmd + }
|
|
Zoom in on the sheet Sheet
|
Shift + Cmd + >
|
|
Zoom out of the sheet Sheet
|
Shift + Cmd + <
|
|
Return to actual size Sheet
|
Cmd + 0
|
|
Find text in the spreadsheet Anywhere
|
Cmd + F
|
Selection
11 shortcuts
| Action |
Mac |
|
Bold the selected text Editing text
|
Cmd + B
|
|
Italicize the selected text Editing text
|
Cmd + I
|
|
Underline the selected text Editing text
|
Cmd + U
|
|
Cut the selection Anywhere
|
Cmd + X
|
|
Copy the selection Anywhere
|
Cmd + C
|
|
Group the selected objects Objects selected
|
Option + Cmd + G
|
|
Ungroup the selected objects Group selected
|
Option + Shift + Cmd + G
|
|
Lock the selected objects Objects selected
|
Cmd + L
|
|
Delete the selected rows Rows selected
|
Option + Cmd + Delete
|
|
Delete the selected columns Columns selected
|
Ctrl + Cmd + Delete
|
|
Edit the chart data references Chart selected
|
Shift + Cmd + D
|
System
1 shortcut
| Action |
Mac |
|
Quit Numbers Anywhere
|
Cmd + Q
|
Tabs and windows
1 shortcut
| Action |
Mac |
|
Close the window Anywhere
|
Cmd + W
|
View and zoom
2 shortcuts
| Action |
Mac |
|
Enter full screen view Anywhere
|
Cmd + Ctrl + F
|
|
Show or hide the sidebar Anywhere
|
Option + Cmd + I
|
From Shortivo at https://shortivo.net/platforms/numbers/. A dot means the maker does not document a key for that system. Nothing on this sheet was converted from one system to another.