Know all the keyboard shortcuts for sheet
Here's the list of Zoho Sheet's keyboard shortcuts for Mac and Windows:
Shortcuts for file operations
Description | Mac | Windows |
Open file | Cmd + O | Ctrl + O |
Save as file | Cmd + Shift + S | Ctrl + Shift + S |
Print file | Cmd + P | Ctrl + P |
Shortcuts for edit actions
Description | Mac | Windows |
Undo last action | Cmd + Z | Ctrl + Z |
*Redo last action | Cmd + Option + Y Cmd + Y | Ctrl + Alt + Y Ctrl + Y |
Repeat last action | Alt + Enter | Alt + Enter |
Cut | Cmd + X | Ctrl + X |
Copy | Cmd + C | Ctrl + C |
Paste | Cmd + V | Ctrl + V |
Insert rows | Cmd + Shift + = | Ctrl + Shift + = |
Insert columns | Cmd + Shift + = | Ctrl + Shift + = |
Delete rows | Cmd + Alt + - | Ctrl + Alt + - |
Delete columns | Cmd + Alt + - | Ctrl + Alt + - |
Insert a new worksheet | Shift + F11 | Shift + F11 |
Hide rows | Cmd + Alt + 9 | Ctrl + Alt + 9 |
Hide columns | Cmd + Alt + 0 | Ctrl + Shift + 0 |
Unhide rows | Cmd + Shift + 9 | Ctrl + Shift + 9 |
Unhide columns | Cmd + Shift + 0 | Ctrl + Shift + 0 |
Run macros/ View macro list | Alt + F8 | Alt + F8 |
Open VBA editor | Alt + F11 | Alt + F11 |
*Add/ Edit hyperlink | Cmd + Option + K Cmd + K | Ctrl + Alt + K Ctrl + K |
Add/ Edit cell note | Shift + F2 | Shift + F2 |
Add comment | Cmd + Alt + M | Ctrl + Alt + M |
*Fill down | Cmd + Option + D Cmd + D | Ctrl + Alt + D Ctrl + D |
*Fill to the right | Cmd + Option + R Cmd + R | Ctrl + Alt + R Ctrl + R |
Filter | Cmd + Shift + L | Ctrl + Shift + L |
Reapply filter | Cmd + Alt + L | Ctrl + Alt + L |
Find within spreadsheet | Cmd + F | Ctrl + F |
*Replace | Cmd + Shift + H Ctrl + H | Ctrl + Shift + H Ctrl + H |
Named ranges | Cmd + F3 | Ctrl + F3 |
Insert the current date in the cell | Cmd + ; | Ctrl + ; |
Insert the current time in the cell | Cmd + Shift + ; | Ctrl + Shift + ; |
Insert current date and time in the cell | Cmd + Alt + ; | Ctrl + Alt + ; |
Display the auto suggest list (Pick from list) | Alt + Down | Alt + Down |
Group rows/columns | Alt + Shift + Right | Alt + Shift + Right |
Ungroup rows/columns | Alt + Shift + Left | Alt + Shift + Left |
Toggle auto completion on/off | Ctrl + Shift + Q | Ctrl + Shift + Q |
Convert selected range into a table | Cmd + Alt + T | Ctrl + Alt + T |
Edit active cell | F2 | F2 |
Cancel cell entry | Esc | Esc |
Focus formula field | Cmd + Shift + F | Ctrl + Shift + F |
Delete content of selected cell/ cell range | Delete | Backspace |
Delete format of selected cell/ cell range | Shift + Delete | Shift + Backspace |
Delete content and format of selected cell/ cell range | Cmd + Delete | Ctrl + Backspace |
Delete one character to right while typing in a cell | Fn + Delete | Delete |
Delete one character to left while typing in a cell | Delete | Backspace |
Insert line break in cell | Alt + Enter | Alt + Enter |
Shortcuts for menus
Description | Mac | Windows |
File | Ctrl + Option + F | Ctrl + Alt + F |
Edit | Ctrl + Option + E | Ctrl + Alt + E |
View | Ctrl + Option + V | Ctrl + Alt + V |
Insert | Ctrl + Option + I | Ctrl + Alt + I |
Format | Ctrl + Option + O | Ctrl + Alt + O |
Data | Ctrl + Option + A | Ctrl + Alt + A |
Tools | Ctrl + Option + S | Ctrl + Alt + S |
Help | Ctrl + Option + H | Ctrl + Alt + H |
Shortcuts for navigation
Description | Mac | Windows |
Move to next cell in row | Tab | Tab |
| Move to previous cell in row | Shift + Tab | Shift + Tab |
Up one screen | Page Up | Page Up |
Down one screen | Page Down | Page Down |
Go to first cell in the data region | Cmd + Home | Ctrl + Home |
Go to last cell in the data region | Cmd + End | Ctrl + End |
Go to cell command | Cmd + G | Ctrl + G |
Data region left | Cmd + L | Ctrl + L |
Data region right | Cmd + R | Ctrl + R |
Data region down | Cmd + Down | Ctrl + Down |
Data region up | Cmd + Up | Ctrl + Up |
Focus name box | Ctrl + Shift + N | Ctrl + Shift + N |
Move to a next worksheet in a spreadsheet | Alt + Right | Alt + Right |
Move to a previous worksheet in a spreadsheet | Alt + Left | Alt + Left |
Feature Finder | Cmd + Shift + Space | Ctrl + Shift + Space |
Shortcuts for formatting
Description | Mac | Windows |
Bold toggle for selection | Cmd + B | Ctrl + B |
Italic toggle for selection | Cmd + I | Ctrl + I |
Underline toggle for selection | Cmd + U | Ctrl + U |
Strikethrough toggle for selection | Cmd + Shift + X | Ctrl + Shift + X |
| *Open format cells dialog | Cmd + Option + 1 Cmd + 1 | Ctrl + Alt + 1 Ctrl + 1 |
Apply number format | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
Apply time format | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
Apply date format | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
Apply currency format | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
Apply percentage format | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
Apply scientific format | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
Cancel format painter | Esc | Esc |
Increase indentation for selected cell/ cell range | Cmd + M | Ctrl + M |
Decrease indentation for selected cell/ cell range | Cmd + Shift + M | Ctrl + Shift + M |
Shortcuts for selection
Description | Mac | Windows |
Select whole spreadsheet | Cmd + A | Ctrl + A |
Select column | Ctrl + Space | Ctrl + Space |
Select row | Shift + Space | Shift + Space |
Select from current cell to the first cell A1 | Ctrl + Shift + Home | Ctrl + Shift + Home |
Select from current cell to the last cell in the data region | Ctrl + Shift + End | Ctrl + Shift + End |
Select from current cell to the first cell in the same row | Shift + Home | Shift + Home |
Select from current cell to the last cell in the same row | Shift + End | Shift + End |
Select data region to the left | Cmd + Shift + Left | Ctrl + Shift + Left |
Select data region to the right | Cmd + Shift + Right | Ctrl + Shift + Right |
Select data region to the up | Cmd + Shift + Up | Ctrl + Shift + Up |
Select data region to the down | Cmd + Shift + Down | Ctrl + Shift + Down |
Extend selection up one screen | Shift + Page Up | Shift + Page Up |
Extend selection down one screen | Shift + Page Down | Shift + Page Down |
Shortcuts for formula related actions
Description | Mac | Windows |
Start a formula | = | = |
Recalculate formulas | F9 | F9 |
Toggle absolute and relative references | F4 | F4 |
Auto sum | Alt + = | Alt + = |
Show function dialog box | Shift + F3 | Shift + F3 |
Toggle expand and collapse of formula bar | Cmd + Shift + U | Ctrl + Shift + U |
Insert array formula on a range of cells | Cmd + Shift + Enter | Ctrl + Shift + Enter |
Select the range of array formula cells surrounding a cell | Cmd + / | Ctrl + / |
Shortcuts for objects
Description | Mac | Windows |
Select or focus the object | Cmd + Click | Ctrl + Click |
Move the selected object in the desired direction | Arrow | Arrow |
Snap the object's left/ top with the adjacent cell | Cmd + Arrow | Ctrl + Arrow |
Snap the object's right/ bottom with the adjacent cell | Cmd + Shift + Arrow | Ctrl + Shift + Arrow |
Navigate to the next object | Tab | Tab |
Navigate to the previous object | Shift + Tab | Shift + Tab |
Edit mode | F2 | F2 |
Return the focus to the active cell | Esc | Esc |
Cancel dragging the object | Esc | Esc |
The keyboard shortcuts marked with * denote those which are similar to the browser shortcuts.
What are overriding keyboard shortcuts and how do they work?
Shortcut keys in Zoho Sheet that are similar to browser's shortcuts are called overriding keyboard shortcuts. By default, the Override browser shortcuts option will be enabled, allowing Zoho Sheet's shortcuts to work instead of your browser's shortcut. To use your browser's shortcuts, you can disable the Override browser shortcuts option. The below table contains the list of overriding keyboard shortcuts in Zoho Sheet.
Description | Mac | Windows |
Redo last action | Cmd + Y | Ctrl + Y |
Add/ Edit hyperlink | Cmd + K | Ctrl + K |
Fill down | Cmd + D | Ctrl + D |
Fill to the right | Cmd + R | Ctrl + R |
Replace | Ctrl + H | Ctrl + H |
Open format cells dialog | Cmd + 1 | Ctrl + 1 |