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
| Keys | Action |
|---|
| Cmd+O | Open |
| Cmd+S | Save |
| Cmd+Shift+S | Save As |
| Cmd+P | Print and PDF |
| Cmd+Z | Undo |
| Cmd+Shift+Z or Cmd+Y | Redo or repeat |
| Cmd+X, C, V | Cut, copy, paste |
| Ctrl+Cmd+V | Paste Special |
| Cmd+F | Find |
| Ctrl+H | Replace |
| Ctrl+G or F5 | Go To |
#Moving and selecting
| Keys | Action |
|---|
| Arrow keys | Move one cell |
| Cmd+arrow | Move to the edge of the data |
| Shift+arrow | Extend the selection |
| Cmd+Shift+arrow | Extend the selection to the edge of the data |
| Ctrl+Home | Go to A1 |
| Ctrl+End | Go to the last used cell |
| Ctrl+Space | Select the column |
| Shift+Space | Select the row |
| Cmd+A | Select all |
| Ctrl+Page Down / Page Up | Next or previous sheet |
#Entering data
| Keys | Action |
|---|
| F2 | Edit the active cell |
| Return / Tab | Confirm and move down or right |
| Esc | Cancel the edit |
| Cmd+D / Cmd+R | Fill down or right |
| Ctrl+; | Today's date |
| Cmd+; | The current time |
| Cmd+Shift+T | AutoSum |
| Shift+F3 | Insert Function |
| F4 | Cycle absolute and relative references while editing |
| Ctrl+E | Flash Fill |
| Cmd+K | Insert a link |
| Keys | Action |
|---|
| Cmd+B, I, U | Bold, italic, underline |
| Cmd+Shift+X | Strikethrough |
| Cmd+1 | Format Cells |
| Ctrl+Shift+$ | Currency format |
| Ctrl+Shift+% | Percent format |
| Ctrl+Shift+# | Date format |
| Opt+Cmd+0 | Outline border |
| Ctrl+T | Create a table |
| Keys | Action |
|---|
| Cmd+Shift+F | Turn AutoFilter on or off |
| Cmd+Shift+R | Sort |
| F9 | Calculate now |
| Ctrl+` | Show formulas | |
| Ctrl+[ / ] | Select precedents or dependents |
| F11 | Insert a chart |
| F7 | Spelling |
| Shift+F2 | Insert a note |
| Cmd+Shift+M | New threaded comment |
| F6 | Move between areas of the window |
| Opt or F10 | Show KeyTips for the ribbon |