Zoho Sheet (MacOS)
Formula related shortcuts
Toggle Expand and Collapse of Formula Bar
Command + Shift + U
All hotkeys for Zoho Sheet (MacOS)
File OperationsNew File |
Ctrl + N |
File OperationsOpen file |
Command + O |
File OperationsSave As File |
Command + Shift + S |
File OperationsPrint File |
Command + P |
ActionsUndo last action |
Command + Z |
ActionsRedo last action |
Command + Y |
ActionsRepeat last action |
F4 / Command + Y / Option + Return |
ActionsFilter |
Command + Shift + L |
ActionsFill to The Right |
Command + R |
ActionsFill Down |
Command + D |
ActionsAdd / Edit cell note |
Shift + F2 |
ActionsAdd / Edit Hyperlink |
Command + K |
ActionsOpen VBA Editor |
Option + F11 |
ActionsRun Macros / View Macros List |
Option + F8 |
ActionsInsert a new worksheet |
Shift + F11 |
ActionsInsert Columns |
Command + Shift + + |
ActionsInsert Rows |
Command + Option + + |
ActionsCut |
Command + X |
ActionsCopy |
Command + C |
ActionsPaste |
Command + V |
ActionsFormat Cells |
Command + Shift + 1 |
ActionsFind within spreadsheet |
Command + F / F3 |
ActionsReplace |
Command + H |
ActionsNames Ranges |
Command + F3 |
ActionsToggle Auto Completion On / Off |
Command + Shift + Q |
ActionsDisplay the auto suggest list (Pick from List) |
Option + Arrow Down |
ActionsInsert the current time in cell |
Command + Shift + ;; |
ActionsInsert the current date in cell |
Command + ; |
Editing ShortcutsInsert Line Break in Cell |
Command + Return |
Editing ShortcutsDelete one character to left while typing in a cell |
Del |
Editing ShortcutsDelete one character to right/left while typing in a cell |
Delete |
Editing ShortcutsFocus Formula Field |
Command + Shift + F |
Editing ShortcutsCancel cell entry |
Esc |
Editing ShortcutsEdit active cell |
F2 |
Formatting ShortcutsBold toggle for selection |
Command + B / Command + Shift + 2 |
Formatting ShortcutsItalic toggle for selection |
Command + I / Command + Shift + 3 |
Formatting ShortcutsStrikethrough toggle for selection |
Command + Shift + 5 |
Formatting ShortcutsUnderline toggle for selection |
Command + U / Command + Shift + 4 |
NavigateData Region Down |
Command + Arrow Down |
NavigateData Region Up |
Command + Arrow Up |
NavigateFocus Name Box |
Command + Shift + N |
NavigateMove to next worksheet in a spreadsheet |
Option + Right Arrow |
NavigateMove to previous worksheet in a spreadsheet |
Option + Left Arrow |
NavigateGo to cell command |
Command + G |
NavigateGo to last cell in data region |
Command + End |
NavigateGo to first cell in data region |
Command + Home |
NavigateDown one screen |
PgDn |
NavigateUp one screen |
PgUp |
NavigateMove to next cell in row |
Tab |
NavigateMove to previous cell in row |
Shift + Tab |
NavigateSelect Data Region to the Left / to the Right |
Command + Left Arrow / Command + Right Arrow |
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 |
Command + 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 |
Command + Arrow Keys |
Shortcuts for Objects (Images,charts,buttons etc)Snap the the object's right/bottom with the adjacent cell |
Command + Shift + Arrow Keys |
SelectionSelect Data Region to the Left/ to the Right |
Command + Shift + Arrow Left / Command + Shift + Arrow Right |
SelectionSelect Data Region Up/down |
Command + Shift + Arrow Up / Command + Shift + Arrow Down |
SelectionSelect from current cell to the first cell A1 |
Command + Shift + Home |
SelectionSelect from current cell to the last cell in the data region |
Command + 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 |
Command + A |
SelectionSelect column |
Command + Spacebar |
SelectionSelect row |
Shift + Spacebar |
Formula related shortcutsToggle Expand and Collapse of Formula Bar |
Command + Shift + U |
Formula related shortcutsInsert Array Formula on a range of cells |
Command + Shift + Return |
Formula related shortcutsSelect the range of array formula cells surrounding a cell |
Command + / |
Formula related shortcutsStart a formula |
= |
Formula related shortcutsRecalculate Formulas |
F9 |
Formula related shortcutsToggle absolute and relative references |
F4 |
Formula related shortcutsAuto Sum |
Option + = |
Formula related shortcutsShow Function Dialog Box |
Shift + F3 |