
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  | 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  | 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 | 
 sidebar
 sidebar