Keyboard shortcuts in Numbers for iCloud
Use keyboard shortcuts to quickly accomplish tasks in Numbers for iCloud. To use a keyboard shortcut, press all the keys in the shortcut at the same time.
Frequently used shortcuts
Action | Mac shortcut | Windows shortcut |
---|---|---|
Cut the selected text or object | Command-X | Control-X |
Copy the selected text or object | Command-C | Control-C |
Paste the selected text or object | Command-V | Control-V |
Add a formula to the selected cell | Equal Sign (=) | Equal Sign (=) |
Edit a formula in a cell | Double-click or Option-Return | Double-click or Alt-Enter |
Add a row above the selected cells | Option-Up Arrow | Alt-Up Arrow |
Add a row below the selected cells | Option-Down Arrow | Alt-Down Arrow |
Add a column to the right of the selected cells | Option-Right Arrow | Alt-Right Arrow |
Add a column to the left of the selected cells | Option-Left Arrow | Alt-Left Arrow |
Insert a paragraph break (hard return) when editing text in a cell | Option-Return | Alt-Enter |
General
Action | Mac shortcut | Windows shortcut |
---|---|---|
Cut the selected text or object | Command-X | Control-X |
Copy the selected text or object | Command-C | Control-C |
Paste the selected text or object | Command-V | Control-V |
Open a new spreadsheet from the template chooser | Select a template and press Return | Select a template and press Enter |
Move between the spreadsheet, toolbar, and the Format sidebar | Shift-Command-U | Control-Shift-U |
Zoom in | Command-Right Angle Bracket (>) | Control-Right Angle Bracket (>) |
Zoom out | Command-Left Angle Bracket (<) | Control-Left Angle Bracket (<) |
View at 100% (actual size) | Command-0 (zero) | Control-0 (zero) |
Hide or show the Format sidebar | Command-Option-I | Control-Alt-I |
Undo the last action | Command-Z | Control-Z |
Redo the last action | Shift-Command-Z | Control-Y |
Print a spreadsheet | Command-P | Control-P |
Delete the previous character or selection | Delete | Backspace |
Delete the next character or selection | Forward Delete (not available on all keyboards) | Forward Delete (not available on all keyboards) |
Delete the word before the insertion point | Option-Delete | Alt-Backspace |
Delete the word after the insertion point | Option-Forward Delete (not available on all keyboards) | Alt-Forward Delete (not available on all keyboards) |
Work with tables
Action | Mac shortcut | Windows shortcut |
---|---|---|
Add a row above the selected cells | Option-Up Arrow | Alt-Up Arrow |
Add a row below the selected cells | Option-Down Arrow | Alt-Down Arrow |
Add a column to the right of the selected cells | Option-Right Arrow | Alt-Right Arrow |
Add a column to the left of the selected cells | Option-Left Arrow | Alt-Left Arrow |
Remove rows and columns with content | Option-drag the resize button | Alt-drag the resize button |
Delete selected rows | Option-Command-Delete | Alt-Shift-Backspace |
Delete selected columns | Control-Command-Delete | Control-Alt-Shift-Backspace |
Insert a row at the bottom of the table | Select a cell in the bottom row, then press Return | Select a cell in the bottom row, then press Enter |
Insert a column on the right of the table | Select a cell in the rightmost column, then press Tab | Select a cell in the rightmost column, then press Tab |
Select an entire row or column | Click the table, then click the lettered bar for the column or the numbered bar for the row | Click the table, then click the lettered bar for the column or the numbered bar for the row |
Select all rows that intersect the current selection | Option-Command-Return | Alt-Shift-Enter |
Select all columns that intersect the current selection | Control-Command-Return | Control-Shift-Enter |
Select additional columns | Shift-Right Arrow or Shift-Left Arrow | Shift-Right Arrow or Shift-Left Arrow |
Select additional rows | Shift-Up Arrow or Shift-Down Arrow | Shift-Up Arrow or Shift-Down Arrow |
Select additional cells | Shift-click | Shift-click |
Select only body cells in a row or column | Double-click the lettered bar for the column or the numbered bar for the row | Double-click the lettered bar for the column or the numbered bar for the row |
Stop the reordering of rows or columns | Press Esc while dragging | Press Esc while dragging |
Resize the table columns evenly | Press Option while dragging | Press Alt while dragging |
Select a table from a cell selection | Command-Return | Control-Enter |
Select the first cell in a selected table | Option-Return | Alt-Enter |
Select all content in a table | Click a table, then press Command-A | Click a table, then press Control-A |
Delete the selected table, or the contents of selected cells | Delete | Backspace |
Select a cell | Click a cell | Click a cell |
Edit a cell | Option-Return | Alt-Enter |
Stop editing the cell and select the cell | Command-Return | Control-Enter |
Stop editing the cell and select the table | Command-Return twice | Control-Enter twice |
Move the selected table one point | Press an arrow key | Press an arrow key |
Move the selected table ten points | Press Shift and an arrow key | Press Shift and an arrow key |
Select the next cell to the left, right, up, or down | Press an arrow key (from a selected cell) | Press an arrow key (from a selected cell) |
Extend cell selection by one cell | Press Shift and an arrow key (from a selected cell) | Press Shift and an arrow key (from a selected cell) |
Extend cell selection to the first row | Shift-Page Up | Shift-Page Up |
Extend cell selection to the last row | Shift-Page Down | Shift-Page Down |
Extend cell selection to the first column | Shift-Home | Shift-Home |
Extend cell selection to the last column | Shift-End | Shift-End |
Move cell selection to the first row | Option-Page Up | Alt-Page Up |
Move cell selection to the last row | Option-Page Down | Alt-Page Down |
Move cell selection to the first column | Option-Home | Alt-Home |
Move cell selection to the last column | Option-End | Alt-End |
Select the cell in the next row; from the last cell in the last row, add a new row | Return | Enter |
Select the cell in the next column; from the last cell in a row, add a new column | Tab | Tab |
Select the cell in the previous column | Shift-Tab | Shift-Tab |
Select the cell in the previous row | Shift-Return | Shift-Enter |
Insert a paragraph break (hard return) when editing text in a cell | Option-Return | Alt-Enter |
Select a value in a pop-up menu for a selected cell | Space bar | Space bar |
Merge selected cells | Control-Command-M | Control-Alt-Shift-M |
Unmerge selected cells | Control-Shift-Command-M | Control-Alt-Shift-U |
Turn Filters on or off | Option-Command-F | Control-Alt-F |
Create formulas
Action | Mac shortcut | Windows shortcut |
---|---|---|
Add a formula to the current cell | Equal Sign (=) | Equal Sign (=) |
Edit a formula | Double-click or Option-Return | Double-click or Alt-Enter |
In the formula editor, save changes | Return or Tab | Alt or Enter |
In the formula editor, discard changes | Esc | Esc |
Specify absolute and relative attributes of selected cell references | Press Command-K to move forward or backward through options | Press Control-K to move forward or backward through options |
Move around within a spreadsheet
Action | Mac shortcut | Windows shortcut |
---|---|---|
Move one character to the left | Left Arrow | Left Arrow |
Move one character to the right | Right Arrow | Right Arrow |
Move to the line above | Up Arrow | Up Arrow |
Move to the line below | Down Arrow | Down Arrow |
Move to the beginning of the current or previous word | Option-Left Arrow | Control-Left Arrow |
Move to the end of the current or next word | Option-Right Arrow | Control-Right Arrow |
Move to the beginning of the current line | Command-Left Arrow | Shift-Home |
Move to the end of the current line | Command-Right Arrow | Shift-End |
Move to the beginning of the current paragraph | Option-Up Arrow | Control-Up Arrow |
Move to the end of the current paragraph | Option-Down Arrow | Control-Down Arrow |
Move to the beginning of the current text area, text box, shape, or table | Command-Up Arrow | Control-Home |
Move to the bottom of the current text area, text box, shape, or table | Command-Down Arrow | Control-End |
Scroll to the beginning of the sheet | Home | Home |
Scroll to the end of the sheet | End | End |
Select text
Action | Mac shortcut | Windows shortcut |
---|---|---|
Select one or more characters | Click in front of the first character then drag across the characters you want to select | Click in front of the first character then drag across the characters you want to select |
Select a word | Double-click the word | Double-click the word |
Select a paragraph | Triple-click in the paragraph | Triple-click in the paragraph |
Select all objects and text | Command-A | Control-A |
Deselect all objects and text | Command-Shift-A | Control-Shift-A |
Extend the text selection | Click in the text, then Shift-click in another location in the text | Click in the text, then Shift-click in another location in the text |
Extend the selection one character to the right | Shift-Right Arrow | Shift-Right Arrow |
Extend the selection one character to the left | Shift-Left Arrow | Shift-Left Arrow |
Extend the selection to the end of the current word | Option-Shift-Right Arrow | Shift-Alt-Right Arrow |
Extend the selection to the beginning of the current word | Option-Shift-Left Arrow | Shift-Alt-Left Arrow |
Extend the selection to the end of the current line | Shift-Command-Right Arrow | Control-Shift-Right Arrow |
Extend the selection to the beginning of the current line | Shift-Command-Left Arrow | Control-Shift-Left Arrow |
Extend the selection to the line above | Shift-Up Arrow | Shift-Up Arrow |
Extend the selection to the line below | Shift-Down Arrow | Shift-Down Arrow |
Extend the selection to the beginning of the current paragraph | Option-Shift-Up Arrow | Shift-Alt-Up Arrow |
Extend the selection to the end of the current paragraph | Option-Shift-Down Arrow | Shift-Alt-Down Arrow |
Extend the selection to the beginning of the text | Shift-Command-Up Arrow | Control-Shift-Up Arrow |
Extend the selection to the end of the text | Shift-Command-Down Arrow | Control-Shift-Down Arrow |
Format text
Action | Mac shortcut | Windows shortcut |
---|---|---|
Apply boldface to selected text | Command-B | Control-B |
Apply italic to selected text | Command-I | Control-I |
Apply underline to selected text | Command-U | Control-U |
Decrease the indent level of a block of text or a list item | Shift-Tab, or in a table cell, Command-Left Bracket ([) | Shift-Tab, or in a table cell, Control-Left Bracket ([) |
Increase the indent level of a block of text or a list item | Tab, or in a table cell, Command-Right Bracket (]) | Tab, or in a table cell, Control-Right Bracket (]) |
Turn text into a link | Command-K | Control-K |
Add a range to (or remove it from) the selection | Shift-drag or Command-drag | Shift-drag or Control-drag |
Insert a line break (soft return) | Shift-Return | Shift-Enter |
Insert a paragraph break | Return | Enter |
Make the text superscript | Control-Command-Plus Sign (+) | Control-Alt-Plus Sign (+) |
Make the text subscript | Control-Command-Minus Sign (-) | Control-Alt-Minus Sign (-) |
Find and replace text
Action | Mac shortcut | Windows shortcut |
---|---|---|
Find | Command-F | Control-F |
Find next | Command-G | Control-G |
Find previous | Shift-Command-G | Control-Shift-G |
Find using selected text | Command-E | Control-E |
Replace text | Return | Enter |
Replace using selected text | Shift-Command-E | Control-Shift-E |
Hide the Find window | Esc | Esc |
Manipulate objects
Action | Mac shortcut | Windows shortcut |
---|---|---|
Select or deselect objects | Command-click or Shift-click | Control-click or Shift-click |
Move the selected object one point | Press an arrow key | Press an arrow key |
Move the selected object ten points | Press Shift and an arrow key | Press Shift and an arrow key |
Constrain the movement of the object horizontally, vertically, or diagonally (45°) | Shift-drag | Shift-drag |
Send the selected object to the back | Shift-Command-B | Control-Shift-B |
Send the selected object one layer back | Option-Shift-Command-B | Control-Shift-Alt-B |
Bring the selected object to the front | Shift-Command-F | Control-Shift-F |
Bring the selected object one layer forward | Option-Shift-Command-F | Control-Shift-Alt-F |
Group selected objects | Option-Command-G | Control-Alt-G |
Ungroup selected objects | Option-Shift-Command-G | Control-Shift-Alt-G |
Disable alignment guides while moving or resizing an object | Command-drag (to disable while moving), or drag a selection handle then press Command (to disable while resizing) | Control-drag (to disable while moving), or drag a selection handle then press Control (to disable while resizing) |
Resize the object | Drag a selection handle | Drag a selection handle |
Resize the object from the center | Option-drag a selection handle | Alt-drag a selection handle |
Constrain the aspect ratio when resizing the object | Shift-drag a selection handle | Shift-drag a selection handle |
Rotate the object | Command-drag a selection handle | Control-drag a selection handle |
Rotate the object 45° | Shift-Command-drag a selection handle | Shift-Control-drag a selection handle |
Mask or unmask an image | Only in Safari, Command-Shift-M | Only in Internet Explorer, Control-Shift-M |
Exit masking | Return | Enter |
Open the shortcut menu for the selected item | Control-click the item | Right-click the item |
Navigate in the document manager
Action | Mac shortcut | Windows shortcut |
---|---|---|
Move from one spreadsheet to another | Select a spreadsheet, then press an arrow key | Select a spreadsheet, then press an arrow key |
Extend the selection to the next spreadsheet | Shift-Right Arrow or Shift-Left Arrow | Shift-Right Arrow or Shift-Left Arrow |
Extend the selection above or below the spreadsheet | Shift-Up Arrow or Shift-Down Arrow | Shift-Up Arrow or Shift-Down Arrow |
Extend spreadsheet selection | Select a spreadsheet, then Shift-click another spreadsheet | Select a spreadsheet, then Shift-click another spreadsheet |
Select or deselect noncontiguous spreadsheets | Command-click | Control-click |
Select all spreadsheets | Command-A | Control-A |
Open a selected spreadsheet | Return | Enter |
Delete a selected spreadsheet | Delete | Backspace |
Rename a spreadsheet | Type a new name, then press Return. To undo, press Esc | Type a new name, then press Enter. To undo, press Esc |