Numbers Keyboard Shortcuts

 

Moving around in a spreadsheet
Page UpScroll one screen up Scroll one page up (in Print View)
Optn-Page UpScroll one screen left Scroll one page left (in Print View)
Page DownScroll one screen down Scroll one page down (in Print View)
Optn-Page DownScroll one screen right Scroll one page right (in Print View)
HomeScroll to beginning of sheet
EndScroll to end of sheet
Cmnd-Page UpGo to previous sheet
Left Arrow or Up ArrowGo to previous sheet (if sheet is selected in Sheets pane)
Cmnd-Page DownGo to next sheet
Right Arrow or Down ArrowGo to next sheet (if sheet is selected in Sheets pane)
 
Moving around within text
Left ArrowMove one character to the left
Right ArrowMove one character to the right
Up ArrowMove to line above
Down ArrowMove to line below
Optn-Left ArrowMove to beginning of current or previous word
Optn-Right ArrowMove to end of current or next word
Cmnd-Left ArrowMove to beginning of current line
Cmnd-Right ArrowMove to end of current line
Optn-Up ArrowMove to beginning of current paragraph
Optn-Down ArrowMove to end of current paragraph
 
Selecting text
Click in front of first character and drag across characters you want to selectSelect one or more characters
Double-click the wordSelect a word
Triple-click in the paragraphSelect a paragraph
Cmnd-ASelect all text within selected object
Shft-Cmnd-ADeselect all text within selected object
Click in the text and Shft-click in another location in the textExtend text selection
Shft-Right ArrowExtend selection one character to the right
Shft-Left ArrowExtend selection one character to the left
Shft-Optn-Right ArrowExtend selection to end of current word
Shft-Optn-Left ArrowExtend selection to beginning of current word
Shft-Cmnd-Right ArrowExtend selection to end of current line
Shft-Cmnd-Left ArrowExtend selection to beginning of current line
Shft-Up ArrowExtend selection to the line above
Shft-Down ArrowExtend selection to the line below
Shft-Optn-Up ArrowExtend selection to beginning of current paragraph
Shft-Optn-Down ArrowExtend selection to end of current paragraph
Shft-Cmnd-Up Arrow or Shft-HomeExtend selection to beginning of text
Shft-Cmnd-Down Arrow or Shft-EndExtend selection to end of text
Select the first text you want and select additional text while holding down the Cmnd keySelect multiple words or blocks of text that aren't next to each other
 
Formatting text
Cmnd-TShow Font panel
Cmnd-BMake selected text bold
Cmnd-IMake selected text italic
Cmnd-UUnderline selected text
DeleteDelete 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 textEdit hyperlink text without disabling hyperlink
Cmnd-XCut
Cmnd-CCopy
Cmnd-VPaste
Optn-Shft-Cmnd-VPaste and match formatting of destination text
Optn-Space barInsert nonbreaking space
Shft-Return or Ctrl-ReturnInsert line break (soft return)
ReturnInsert paragraph break
 
Manipulating objects
Optn-click Shapes in toolbar, choose a shape, and drag crosshairs on canvasDraw shape
Optn-click Charts in toolbar, choose a chart, and drag crosshairs on canvasDraw chart
Select one object and press Cmnd-ASelect all objects on sheet
Select one object and press Cmnd-Shft-ADeselect all objects
Cmnd-click or Shft-clickSelect or deselect additional objects
Shft-drag or Cmnd-dragAdd range to or remove it from selection
Arrow keyMove selected object one point
Shft-arrow keyMove selected object ten points
Shft-Cmnd-BSend object to the back
Optn-Shft-Cmnd-BSend object one layer back
Shft-Cmnd-FBring object to the front
Optn-Shft-Cmnd-FBring object one layer forward
Optn-Cmnd-GGroup objects
Optn-Shft-Cmnd-GUngroup objects
Cmnd-LLock objects
Optn-Cmnd-LUnlock objects
Cmnd-D or Optn-dragDuplicate object
Shft-dragConstrain movement of object to 45º
Drag handleResize object
Optn-drag handleResize object from center
Shft-drag handleConstrain aspect ratio when resizing object
Optn-Shft-drag handleConstrain aspect ratio when resizing object from center
Cmnd-drag handleRotate object
Shft-Cmnd-drag handleRotate object 45º
Cmnd-Optn-drag handleRotate object around opposite handle (instead of center)
Shft-Cmnd-Optn-drag handleRotate object 45º around opposite handle (instead of center)
Cmnd-dragTurn off alignment guides
Shft-Cmnd-MMask or unmask object
Return, Cmnd-Return, Enter, or double-clickExit mask mode
Double-click masked imageReenter mask mode
Ctrl-clickOpen shortcut menu for selected item
Cmnd-ReturnExit text edit mode and select object
 
Working with tables
Select a cell and press Cmnd-ASelect all cell content in a table
Select a border segment and press Cmnd-ASelect all cell borders in a table
DeleteDelete selected table or border segment or contents of selected cells
Shft-drag tableConstrain movement of table and snap to guides
Drag selected cell by its border and release when other cell is selectedMove contents of selected cell to another cell, replacing its contents
Optn-drag selected cell to the other cellCopy contents of selected cell to another cell
Shft-click in the other cell or use Shft-arrow keysExtend selection from selected cell to another cell
Click cellSelect cell
Cmnd-click selected or unselected cellAdd cell to or remove it from selection
Select cell and click once, twice, or three timesEdit content in cell
Cmnd-ReturnStop editing cell and select cell
Cmnd-click a selected cellSelect table
Double-click border segment of selected or unselected tableSelect a single border segment (if border selection is on)
Click the segment in a selected or unselected tableSelect a long border segment (if border selection is on)
Click selectionChange single-segment selection to long-segment selection (if border selection is on)
Shft-click or Cmnd-click unselected border segmentAdd single or long border segment to selection (if border selection is on)
Shft-click or Cmnd-click selected single segmentDeselect single border segment (if border selection is on)
Drag selectionMove selected long border segment to new position (if border selection is on)
Arrow keysMove selected table, border, or long border segment one point
Shft-arrow keysMove 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
TabSelect next cell
Select last cell in row and press TabAdd column to right side of table when "Return key moves to next cell" is selected
ReturnAdd 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 tableAdd new row at end of table when last cell is selected and "Return key moves to next cell" option isn't selected
Shft-TabSelect previous cell
Cmnd-ReturnStop editing cells and select the table
Optn-TabInsert a tab when editing cell
Ctrl-ReturnInsert a line break (soft return) when editing text in a cell
Optn-ReturnInsert a paragraph break (hard return) when editing text in a cell and "Return key moves to next cell" is selected
ReturnInsert a paragraph break (hard return) when editing text in a cell and "Return key moves to next cell" isn't selected
Ctrl-click tableOpen table formatting menu for selected table or cells
Select cell and type =Open Formula Editor to add a new formula
Double-click cellOpen Formula Editor to edit a formula
Return, Enter, or Accept buttonIn Formula Editor, save changes
Escape, or Cancel buttonIn Formula Editor, discard changes
Double-click cellEdit value in cell with cell format
 
Working with editable shapes
Click the shape and then click againMake custom shape editable
Click point and drag to another locationMove a point of an editable shape
Click point and press DeleteDelete a point of an editable shape
Optn-click the shape edge where you want to add a pointAdd a point to an editable shape
Double-click the corner pointChange a corner point of an editable shape into a curved point
Double-click the curved pointChange a curved point of an editable shape into a corner point
Click a point on the curve and move the ctrl handlesReshape the curve of an editable shape
 
Using Print View
Optn-Cmnd-PShow pages in selected sheet
 
General
Cmnd-N (opens Template Chooser or template specified in Numbers preferences)Create new spreadsheet
Shft-Cmnd-NOpen Template Chooser
Cmnd-OOpen existing spreadsheet
Cmnd-SSave
Shft-Cmnd-SSave as
Cmnd-PPrint selected sheet
Cmnd-?Open Numbers help
Cmnd-FFind
Cmnd-GFind next
Shft-Cmnd-GFind previous
Cmnd-EUse selection for find
Cmnd-JScroll to found selection
Cmnd-semicolon (;)Check spelling
Cmnd-colon (:)Show spelling window
Cmnd->Zoom in
Cmnd-<Zoom out
Cmnd-WClose window
Cmnd-MMinimize window
Cmnd-comma (,)Show preferences
Optn-Cmnd-IShow Inspector window
Cmnd-RShow document rulers
Shft-Cmnd-LShow layout
Shft-Cmnd-CShow Colors window
Cmnd-HHide Numbers
Optn-Cmnd-HHide other windows
Cmnd-QQuit Numbers

 

comments powered by Disqus