Numbers for Mac: Numbers for Mac keyboard shortcuts
You can use keyboard shortcuts to quickly accomplish many tasks in Numbers. To use a keyboard shortcut, press all the keys in the shortcut at the same time. Shortcuts for common commands are listed in the table below.
Move around within a spreadsheet
Action |
Shortcut |
|---|---|
Move one character to the left |
Left Arrow |
Move one character to the right |
Right Arrow |
Move one character backward (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 |
Scroll to the end of the sheet |
End |
Center the insertion point in the app window |
Control-L |
Move down a page |
Control-V |
Select text
Action |
Shortcut |
|---|---|
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 |
Format text
Action |
Shortcut |
|---|---|
Show the Fonts window |
Command-T |
Show the Colors 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 |
Add a hyperlink to text |
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 nonbreaking 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 |
Transpose the characters on either side of the insertion point |
Control-T |
Apply a paragraph, character, or list style using your own shortcut |
Use editing tools
Action |
Shortcut |
|---|---|
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 |
Command-G |
Find previous |
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 (:) |
Add a comment |
Shift-Command-K |
Show the next comment |
Option-Command-K |
Show the previous comment |
Option-Shift-Command-K |
Manipulate objects
Action |
Shortcut |
|---|---|
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 outward 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 center |
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 center |
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 center) |
Option-Command-drag a selection handle |
Rotate the object 45° around the opposite handle (instead of the center) |
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 |
Work with tables
Action |
Shortcut |
|---|---|
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 |
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 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 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 |
Check or uncheck a checkbox 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 is selected, add a new row |
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) |
Work with charts
Action |
Shortcut |
|---|---|
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 |
Create cell references in formulas
Action |
Shortcut |
|---|---|
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 nonheader 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 forward or backward 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 forward or backward through options |
Work with editable shapes
Action |
Shortcut |
|---|---|
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 |
General
Action |
Shortcut |
|---|---|
Start dictation |
Press Fn twice |
Open a new spreadsheet |
Command-N |
Choose a template and create a new spreadsheet |
Enter |
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 Numbers Help |
Shift-Command-Question Mark (?) |
Close a window |
Command-W |
Close all windows |
Option-Command-W |
Minimize a window |
Command-M |
Minimize 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 Colors 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 |