Learning these shortcuts can save you a lot of time in the long run. Are you searching for the Zoho Sheet Keyboard Shortcuts?
If you’re interested in Zoho Sheet Keyboard Shortcuts this is the right place for you. There are many keyboard shortcuts that can save you time and energy when you are working on Zoho Sheet.
Table of Contents
File Operations
| Ctrl+N( not supported in chrome and safari ) | New File |
| Ctrl+O | Open file |
| Ctrl+Shift+S | Save As File |
| Ctrl+P | Print File |
Actions
| Ctrl+Z | Undo last action |
| Ctrl+Y | Redo last action |
| F4 (or) Ctrl+Y (or) Alt+Enter | Repeat last action |
| Ctrl+Shift+ L | Filter |
| Ctrl+R | Fill to The Right |
| Ctrl+D | Fill Down |
| Shift+F2 | Add / Edit cell note |
| Ctrl+K | Add / Edit Hyperlink |
| Alt +F11 | Open VBA Editor |
| Alt+F8 | Run Macros / View Macros List |
| Shift+F11 | Insert a new worksheet |
| Ctrl+Shift+Plus | Insert Columns |
| Ctrl+Alt+Plus | Insert Rows |
| Ctrl+X | Cut |
| Ctrl+C | Copy |
| Ctrl+V | Paste |
| Ctrl+Shift+ 1 | Format Cells |
| Ctrl+F or F3 | Find within spreadsheet |
| Ctrl+H | Replace |
| Ctrl+F3 | Names Ranges |
| Ctrl+Shift+Q | Toggle Auto Completion On / Off |
| Alt+Arrow Down | Display the auto suggest list (Pick from List) |
| Ctrl+Shift+ ; | Insert the current time in cell |
| Ctrl+; | Insert the current date in cell |
Editing
| Ctrl+Enter | Insert Line Break in Cell |
| Backspace | Delete one character to left while typing in a cell |
| Delete | Delete one character to right/left while typing in a cell |
| Ctrl+Shift+F | Focus Formula Field |
| Esc key | Cancel cell entry |
| F2 | Edit active cell |
Formatting
| Ctrl+B (or) Ctrl+Shift+2 | Bold toggle for selection |
| Ctrl+I (or) Ctrl+Shift+ 3 | Italic toggle for selection |
| Ctrl+Shift+5 | Strikethrough toggle for selection |
| Ctrl+U (or) Ctrl+Shift+4 | Underline toggle for selection |
Navigate
| Ctrl+Arrow Down | Data Region Down |
| Ctrl+Arrow Up | Data Region Up |
| Ctrl+Shift+N | Focus Name Box |
| Alt+Arrow Right | Move to next worksheet in a spreadsheet |
| Alt +Arrow Left | Move to previous worksheet in a spreadsheet |
| Ctrl+ G | Go to cell command |
| Ctrl+End | Go to last cell in data region |
| Ctrl+Home | Go to first cell in data region |
| Page Down | Down one screen |
| Page Up | Up one screen |
| Tab | Move to next cell in row |
| Shift+Tab | Move to previous cell in row |
| Ctrl+Arrow Left/ Ctrl+Arrow Right | Select Data Region to the Left / to the Right |
Shortcuts for Objects (Images,charts,buttons etc)
| Tab | Navigate to the next object |
| Shift+Tab | Navigate to the previous object |
| F2 | Edit mode |
| Esc | Return the focus to the active cell |
| Esc | Cancel dragging the object |
| Ctrl +Click | Select/Focus the object |
| Arrow Keys | Move the selected object in the desired direction |
| Ctrl+Arrow Keys | Snap the the object’s left/top with the adjacent cell |
| Ctrl+Shift+Arrow Keys | Snap the the object’s right/bottom with the adjacent cell |
Selection
| Ctrl+Shift+Arrow Left/Ctrl+Shift+ Arrow Right | Select Data Region to the Left/ to the Right |
| Ctrl+Shift+Arrow Up/Ctrl+Shift+Arrow Down | Select Data Region Up/down |
| Ctrl+Shift+Home | Select from current cell to the first cell A1 |
| Ctrl+Shift+End | Select from current cell to the last cell in the data region |
| Shift+Home | Select from current cell to the first cell in the same row |
| Shift+End | Select from current cell to the last cell in the same row |
| Ctrl +A | Select whole spreadsheet |
| Ctrl+Space | Select column |
| Shift+Space | Select row |
Formula related shortcuts
| Ctrl+Shift+U | Toggle Expand and Collapse of Formula Bar |
| Ctrl+Shift+Enter | Insert Array Formula on a range of cells |
| Ctrl+/ | Select the range of array formula cells surrounding a cell |
| = | Start a formula |
| F9 | Recalculate Formulas |
| F4 | Toggle absolute and relative references |
| Alt+ = | Auto Sum |
| Shift+F3 | Show Function Dialog Box |
Using This Zoho Sheet Keyboard Shortcuts can help you be more productive.
So next time you’re sitting at your computer, take a few minutes to learn some of these essential keyboard shortcuts – your future self will thank you!
Was this article helpful?
YesNo
