Moving around in a spreadsheet | |
Page Up | Scroll one screen up Scroll one page up (in Print View) |
Optn-Page Up | Scroll one screen left Scroll one page left (in Print View) |
Page Down | Scroll one screen down Scroll one page down (in Print View) |
Optn-Page Down | Scroll one screen right Scroll one page right (in Print View) |
Home | Scroll to beginning of sheet |
End | Scroll to end of sheet |
Cmnd-Page Up | Go to previous sheet |
Left Arrow or Up Arrow | Go to previous sheet (if sheet is selected in Sheets pane) |
Cmnd-Page Down | Go to next sheet |
Right Arrow or Down Arrow | Go to next sheet (if sheet is selected in Sheets pane) |
Moving around within text | |
Left Arrow | Move one character to the left |
Right Arrow | Move one character to the right |
Up Arrow | Move to line above |
Down Arrow | Move to line below |
Optn-Left Arrow | Move to beginning of current or previous word |
Optn-Right Arrow | Move to end of current or next word |
Cmnd-Left Arrow | Move to beginning of current line |
Cmnd-Right Arrow | Move to end of current line |
Optn-Up Arrow | Move to beginning of current paragraph |
Optn-Down Arrow | Move to end of current paragraph |
Selecting text | |
Click in front of first character and drag across characters you want to select | Select one or more characters |
Double-click the word | Select a word |
Triple-click in the paragraph | Select a paragraph |
Cmnd-A | Select all text within selected object |
Shft-Cmnd-A | Deselect all text within selected object |
Click in the text and Shft-click in another location in the text | Extend text selection |
Shft-Right Arrow | Extend selection one character to the right |
Shft-Left Arrow | Extend selection one character to the left |
Shft-Optn-Right Arrow | Extend selection to end of current word |
Shft-Optn-Left Arrow | Extend selection to beginning of current word |
Shft-Cmnd-Right Arrow | Extend selection to end of current line |
Shft-Cmnd-Left Arrow | Extend selection to beginning of current line |
Shft-Up Arrow | Extend selection to the line above |
Shft-Down Arrow | Extend selection to the line below |
Shft-Optn-Up Arrow | Extend selection to beginning of current paragraph |
Shft-Optn-Down Arrow | Extend selection to end of current paragraph |
Shft-Cmnd-Up Arrow or Shft-Home | Extend selection to beginning of text |
Shft-Cmnd-Down Arrow or Shft-End | Extend selection to end of text |
Select the first text you want and select additional text while holding down the Cmnd key | Select multiple words or blocks of text that aren't next to each other |
Formatting text | |
Cmnd-T | Show Font panel |
Cmnd-B | Make selected text bold |
Cmnd-I | Make selected text italic |
Cmnd-U | Underline selected text |
Delete | Delete previous character or selection |
Del (not available on all keyboards) | Delete next character or selection |
Cmnd-plus sign (+) or Cmnd-equal sign (=) | Make font size bigger |
Cmnd-minus sign (-) | Make font size smaller |
Ctrl-Cmnd-plus sign (+) | Make text superscript |
Ctrl-Cmnd-minus sign (-) | Make text subscript |
Cmnd-{ (left brace) | Align text flush left |
Cmnd-| | Center text |
Cmnd-} (right brace) | Align text flush right |
Optn-Cmnd-| | Align text flush left and flush right (justify) |
Use arrow keys to move into hyperlink text | Edit hyperlink text without disabling hyperlink |
Cmnd-X | Cut |
Cmnd-C | Copy |
Cmnd-V | Paste |
Optn-Shft-Cmnd-V | Paste and match formatting of destination text |
Optn-Space bar | Insert nonbreaking space |
Shft-Return or Ctrl-Return | Insert line break (soft return) |
Return | Insert paragraph break |
Manipulating objects | |
Optn-click Shapes in toolbar, choose a shape, and drag crosshairs on canvas | Draw shape |
Optn-click Charts in toolbar, choose a chart, and drag crosshairs on canvas | Draw chart |
Select one object and press Cmnd-A | Select all objects on sheet |
Select one object and press Cmnd-Shft-A | Deselect all objects |
Cmnd-click or Shft-click | Select or deselect additional objects |
Shft-drag or Cmnd-drag | Add range to or remove it from selection |
Arrow key | Move selected object one point |
Shft-arrow key | Move selected object ten points |
Shft-Cmnd-B | Send object to the back |
Optn-Shft-Cmnd-B | Send object one layer back |
Shft-Cmnd-F | Bring object to the front |
Optn-Shft-Cmnd-F | Bring object one layer forward |
Optn-Cmnd-G | Group objects |
Optn-Shft-Cmnd-G | Ungroup objects |
Cmnd-L | Lock objects |
Optn-Cmnd-L | Unlock objects |
Cmnd-D or Optn-drag | Duplicate object |
Shft-drag | Constrain movement of object to 45º |
Drag handle | Resize object |
Optn-drag handle | Resize object from center |
Shft-drag handle | Constrain aspect ratio when resizing object |
Optn-Shft-drag handle | Constrain aspect ratio when resizing object from center |
Cmnd-drag handle | Rotate object |
Shft-Cmnd-drag handle | Rotate object 45º |
Cmnd-Optn-drag handle | Rotate object around opposite handle (instead of center) |
Shft-Cmnd-Optn-drag handle | Rotate object 45º around opposite handle (instead of center) |
Cmnd-drag | Turn off alignment guides |
Shft-Cmnd-M | Mask or unmask object |
Return, Cmnd-Return, Enter, or double-click | Exit mask mode |
Double-click masked image | Reenter mask mode |
Ctrl-click | Open shortcut menu for selected item |
Cmnd-Return | Exit text edit mode and select object |
Working with tables | |
Select a cell and press Cmnd-A | Select all cell content in a table |
Select a border segment and press Cmnd-A | Select all cell borders in a table |
Delete | Delete selected table or border segment or contents of selected cells |
Shft-drag table | Constrain movement of table and snap to guides |
Drag selected cell by its border and release when other cell is selected | Move contents of selected cell to another cell, replacing its contents |
Optn-drag selected cell to the other cell | Copy contents of selected cell to another cell |
Shft-click in the other cell or use Shft-arrow keys | Extend selection from selected cell to another cell |
Click cell | Select cell |
Cmnd-click selected or unselected cell | Add cell to or remove it from selection |
Select cell and click once, twice, or three times | Edit content in cell |
Cmnd-Return | Stop editing cell and select cell |
Cmnd-click a selected cell | Select table |
Double-click border segment of selected or unselected table | Select a single border segment (if border selection is on) |
Click the segment in a selected or unselected table | Select a long border segment (if border selection is on) |
Click selection | Change single-segment selection to long-segment selection (if border selection is on) |
Shft-click or Cmnd-click unselected border segment | Add single or long border segment to selection (if border selection is on) |
Shft-click or Cmnd-click selected single segment | Deselect single border segment (if border selection is on) |
Drag selection | Move selected long border segment to new position (if border selection is on) |
Arrow keys | Move selected table, border, or long border segment one point |
Shft-arrow keys | Move selected table, border, or long border segment ten points |
Arrow keys (in cell selection mode) | Select next cell to the left, right, up, or down |
Shft-arrow keys (in cell selection mode) | Extend cell selection by one cell |
Tab | Select next cell |
Select last cell in row and press Tab | Add column to right side of table when "Return key moves to next cell" is selected |
Return | Add new row at end of table when last cell is selected and "Return key moves to next cell" option is selected |
Tab from last cell in table | Add new row at end of table when last cell is selected and "Return key moves to next cell" option isn't selected |
Shft-Tab | Select previous cell |
Cmnd-Return | Stop editing cells and select the table |
Optn-Tab | Insert a tab when editing cell |
Ctrl-Return | Insert a line break (soft return) when editing text in a cell |
Optn-Return | Insert a paragraph break (hard return) when editing text in a cell and "Return key moves to next cell" is selected |
Return | Insert a paragraph break (hard return) when editing text in a cell and "Return key moves to next cell" isn't selected |
Ctrl-click table | Open table formatting menu for selected table or cells |
Select cell and type = | Open Formula Editor to add a new formula |
Double-click cell | Open Formula Editor to edit a formula |
Return, Enter, or Accept button | In Formula Editor, save changes |
Escape, or Cancel button | In Formula Editor, discard changes |
Double-click cell | Edit value in cell with cell format |
Working with editable shapes | |
Click the shape and then click again | Make custom shape editable |
Click point and drag to another location | Move a point of an editable shape |
Click point and press Delete | Delete a point of an editable shape |
Optn-click the shape edge where you want to add a point | Add a point to an editable shape |
Double-click the corner point | Change a corner point of an editable shape into a curved point |
Double-click the curved point | Change a curved point of an editable shape into a corner point |
Click a point on the curve and move the ctrl handles | Reshape the curve of an editable shape |
Using Print View | |
Optn-Cmnd-P | Show pages in selected sheet |
General | |
Cmnd-N (opens Template Chooser or template specified in Numbers preferences) | Create new spreadsheet |
Shft-Cmnd-N | Open Template Chooser |
Cmnd-O | Open existing spreadsheet |
Cmnd-S | Save |
Shft-Cmnd-S | Save as |
Cmnd-P | Print selected sheet |
Cmnd-? | Open Numbers help |
Cmnd-F | Find |
Cmnd-G | Find next |
Shft-Cmnd-G | Find previous |
Cmnd-E | Use selection for find |
Cmnd-J | Scroll to found selection |
Cmnd-semicolon (;) | Check spelling |
Cmnd-colon (:) | Show spelling window |
Cmnd-> | Zoom in |
Cmnd-< | Zoom out |
Cmnd-W | Close window |
Cmnd-M | Minimize window |
Cmnd-comma (,) | Show preferences |
Optn-Cmnd-I | Show Inspector window |
Cmnd-R | Show document rulers |
Shft-Cmnd-L | Show layout |
Shft-Cmnd-C | Show Colors window |
Cmnd-H | Hide Numbers |
Optn-Cmnd-H | Hide other windows |
Cmnd-Q | Quit Numbers |
comments powered by Disqus