Keyboard shortcuts

8sheets uses the keyboard shortcuts spreadsheet users already know. On a Mac, use Cmd; on Windows and Linux, use Ctrl where the table shows Cmd. The full list, which you can also change, is under File > Preferences > Keyboard.

Some shortcuts belong to the browser in a normal tab, for example Cmd+N and Cmd+T. They reach 8sheets when it is installed as an app. Use Ctrl+T for a table in a browser tab.

Files and editing

KeysAction
Cmd+OOpen
Cmd+SSave
Cmd+Shift+SSave As
Cmd+PPrint and PDF
Cmd+ZUndo
Cmd+Shift+Z or Cmd+YRedo or repeat
Cmd+X, C, VCut, copy, paste
Ctrl+Cmd+VPaste Special
Cmd+FFind
Ctrl+HReplace
Ctrl+G or F5Go To

Moving and selecting

KeysAction
Arrow keysMove one cell
Cmd+arrowMove to the edge of the data
Shift+arrowExtend the selection
Cmd+Shift+arrowExtend the selection to the edge of the data
Ctrl+HomeGo to A1
Ctrl+EndGo to the last used cell
Ctrl+SpaceSelect the column
Shift+SpaceSelect the row
Cmd+ASelect all
Ctrl+Page Down / Page UpNext or previous sheet

Entering data

KeysAction
F2Edit the active cell
Return / TabConfirm and move down or right
EscCancel the edit
Cmd+D / Cmd+RFill down or right
Ctrl+;Today's date
Cmd+;The current time
Cmd+Shift+TAutoSum
Shift+F3Insert Function
F4Cycle absolute and relative references while editing
Ctrl+EFlash Fill
Cmd+KInsert a link

Formatting

KeysAction
Cmd+B, I, UBold, italic, underline
Cmd+Shift+XStrikethrough
Cmd+1Format Cells
Ctrl+Shift+$Currency format
Ctrl+Shift+%Percent format
Ctrl+Shift+#Date format
Opt+Cmd+0Outline border
Ctrl+TCreate a table

Data, formulas and tools

KeysAction
Cmd+Shift+FTurn AutoFilter on or off
Cmd+Shift+RSort
F9Calculate now
Ctrl+` | Show formulas
Ctrl+[ / ]Select precedents or dependents
F11Insert a chart
F7Spelling
Shift+F2Insert a note
Cmd+Shift+MNew threaded comment
F6Move between areas of the window
Opt or F10Show KeyTips for the ribbon