Zoho Sheet (Windows)
Formula related shortcuts
Toggle Expand and Collapse of Formula Bar
Ctrl + Shift + U
All hotkeys for Zoho Sheet (Windows)
File OperationsNew File |
Ctrl + N ( not supported in chrome and safari ) |
File OperationsOpen file |
Ctrl + O |
File OperationsSave As File |
Ctrl + Shift + S |
File OperationsPrint File |
Ctrl + P |
ActionsUndo last action |
Ctrl + Z |
ActionsRedo last action |
Ctrl + Y |
ActionsRepeat last action |
F4 (or) Ctrl + Y (or) Alt + Enter |
ActionsFilter |
Ctrl + Shift + L |
ActionsFill to The Right |
Ctrl + R |
ActionsFill Down |
Ctrl + D |
ActionsAdd / Edit cell note |
Shift + F2 |
ActionsAdd / Edit Hyperlink |
Ctrl + K |
ActionsOpen VBA Editor |
Alt + F11 |
ActionsRun Macros / View Macros List |
Alt + F8 |
ActionsInsert a new worksheet |
Shift + F11 |
ActionsInsert Columns |
Ctrl + Shift + Plus |
ActionsInsert Rows |
Ctrl + Alt + Plus |
ActionsCut |
Ctrl + X |
ActionsCopy |
Ctrl + C |
ActionsPaste |
Ctrl + V |
ActionsFormat Cells |
Ctrl + Shift + 1 |
ActionsFind within spreadsheet |
Ctrl + F or F3 |
ActionsReplace |
Ctrl + H |
ActionsNames Ranges |
Ctrl + F3 |
ActionsToggle Auto Completion On / Off |
Ctrl + Shift + Q |
ActionsDisplay the auto suggest list (Pick from List) |
Alt + Arrow Down |
ActionsInsert the current time in cell |
Ctrl + Shift + ; |
ActionsInsert the current date in cell |
Ctrl + ; |
EditingInsert Line Break in Cell |
Ctrl + Enter |
EditingDelete one character to left while typing in a cell |
Backspace |
EditingDelete one character to right/left while typing in a cell |
Delete |
EditingFocus Formula Field |
Ctrl + Shift + F |
EditingCancel cell entry |
Esc key |
EditingEdit active cell |
F2 |
FormattingBold toggle for selection |
Ctrl + B (or) Ctrl + Shift + 2 |
FormattingItalic toggle for selection |
Ctrl + I (or) Ctrl + Shift + 3 |
FormattingStrikethrough toggle for selection |
Ctrl + Shift + 5 |
FormattingUnderline toggle for selection |
Ctrl + U (or) Ctrl + Shift + 4 |
NavigateData Region Down |
Ctrl + Arrow Down |
NavigateData Region Up |
Ctrl + Arrow Up |
NavigateFocus Name Box |
Ctrl + Shift + N |
NavigateMove to next worksheet in a spreadsheet |
Alt + Arrow Right |
NavigateMove to previous worksheet in a spreadsheet |
Alt + Arrow Left |
NavigateGo to cell command |
Ctrl + G |
NavigateGo to last cell in data region |
Ctrl + End |
NavigateGo to first cell in data region |
Ctrl + Home |
NavigateDown one screen |
Page Down |
NavigateUp one screen |
Page Up |
NavigateMove to next cell in row |
Tab |
NavigateMove to previous cell in row |
Shift + Tab |
NavigateSelect Data Region to the Left / to the Right |
Ctrl + Arrow Left / Ctrl + Arrow Right |
Shortcuts for Objects (Images,charts,buttons etc)Navigate to the next object |
Tab |
Shortcuts for Objects (Images,charts,buttons etc)Navigate to the previous object |
Shift + Tab |
Shortcuts for Objects (Images,charts,buttons etc)Edit mode |
F2 |
Shortcuts for Objects (Images,charts,buttons etc)Return the focus to the active cell |
Esc |
Shortcuts for Objects (Images,charts,buttons etc)Cancel dragging the object |
Esc |
Shortcuts for Objects (Images,charts,buttons etc)Select/Focus the object |
Ctrl + Click |
Shortcuts for Objects (Images,charts,buttons etc)Move the selected object in the desired direction |
Arrow Keys |
Shortcuts for Objects (Images,charts,buttons etc)Snap the the object's left/top with the adjacent cell |
Ctrl + Arrow Keys |
Shortcuts for Objects (Images,charts,buttons etc)Snap the the object's right/bottom with the adjacent cell |
Ctrl + Shift + Arrow Keys |
SelectionSelect Data Region to the Left/ to the Right |
Ctrl + Shift + Arrow Left / Ctrl + Shift + Arrow Right |
SelectionSelect Data Region Up/down |
Ctrl + Shift + Arrow Up / Ctrl + Shift + Arrow Down |
SelectionSelect from current cell to the first cell A1 |
Ctrl + Shift + Home |
SelectionSelect from current cell to the last cell in the data region |
Ctrl + Shift + End |
SelectionSelect from current cell to the first cell in the same row |
Shift + Home |
SelectionSelect from current cell to the last cell in the same row |
Shift + End |
SelectionSelect whole spreadsheet |
Ctrl + A |
SelectionSelect column |
Ctrl + Space |
SelectionSelect row |
Shift + Space |
Formula related shortcutsToggle Expand and Collapse of Formula Bar |
Ctrl + Shift + U |
Formula related shortcutsInsert Array Formula on a range of cells |
Ctrl + Shift + Enter |
Formula related shortcutsSelect the range of array formula cells surrounding a cell |
Ctrl + / |
Formula related shortcutsStart a formula |
= |
Formula related shortcutsRecalculate Formulas |
F9 |
Formula related shortcutsToggle absolute and relative references |
F4 |
Formula related shortcutsAuto Sum |
Alt + = |
Formula related shortcutsShow Function Dialog Box |
Shift + F3 |