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 |
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
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.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Working with Zoho Sheet
Here are a few things that we'd like for you to know about Zoho Sheet as you get started: Maximum file size allowed for import 25 MB Maximum number of rows 131072 Maximum number of columns 1024 Maximum number of cells 5 Million Maximum number of ...SHEET
Returns the sheet number for a given cell reference. Syntax SHEET(cell_ref) cell_ref: The cell reference whose sheet number you want. If omitted, it returns the sheet number of the current cell containing the formula. E.g. SHEET.A1 Remarks The ...Custom functions in Zoho Sheet
Though Zoho Sheet supports around 400 functions by default, for simple and complex calculations, we understand that our users have their own business logic that requires personalized functions. Additionally, Zoho Sheet also allows you to bring in ...Configure and enable OpenAI in Zoho Sheet
ChatGPT by OpenAI is a generative artificial intelligence tool that processes the given queries and provides detailed responses. Zoho Sheet's integration with OpenAI will enhance the way you analyze your spreadsheet data with advanced AI features. ...About Zoho Sheet
Zoho Sheet is a cloud-based spreadsheet application. It allows you to create, share, and work together on spreadsheets online, in real time. You can analyze, visualize and publish data using Zoho Sheet across multiple devices and browsers.
New to Zoho LandingPage?
Zoho LandingPage Resources