Here's the list of Zoho Sheet's keyboard shortcuts for Mac and Windows:
Description | Mac | Windows |
Open file | Cmd + O | Ctrl + O |
Save as file | Cmd + Shift + S | Ctrl + Shift + S |
Print file | Cmd + P | Ctrl + P |
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 |
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 |
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 |
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 |
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 |
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 + / |
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 |
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 |
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.