List of Zoho Sheet Shortcuts
Learn Zoho Sheet Shortcuts for Windows & Mac
Most used Zoho Sheet Shortcuts
| Action |
Zoho Sheet Shortcuts Windows |
Zoho Sheet Shortcuts Mac |
| New File |
Ctrl + N |
Command + N |
| Open file |
Ctrl + O |
Command + O |
| Save As File |
Ctrl + Shift + S |
Command + Shift + S |
| Print File |
Ctrl + P |
Command + P |
| Copy |
Ctrl + C |
Command + C |
| Paste |
Ctrl + V |
Command + V |
| Cut |
Ctrl + X |
Command + X |
| Undo last action |
Ctrl + Z |
Command + Z |
| Redo last action |
Ctrl + Y |
Command + Y |
| Filter |
Ctrl + Shift + L |
Command + Shift + L |
| Fill to The Right |
Ctrl + R |
Command + R |
| Fill Down |
Ctrl + D |
Command + D |
| Add or Edit cell note |
Shift + F2 |
Shift + F2 |
| Add or Edit Hyperlink |
Ctrl + K |
Command + K |
| Open VBA Editor |
Alt + F11 |
Option + F11 |
| Run Macros or View Macros List |
Alt + F8 |
Option + F8 |
| Insert a new worksheet |
Shift + F11 |
Shift + F11 |
| Insert Columns |
Ctrl + Shift + + |
Command + Shift + + |
| Insert Rows |
Ctrl + Alt + + |
Command + Option + + |
| Format Cells |
Ctrl + Shift + 1 |
Command + Shift + 1 |
| Find within spreadsheet |
Ctrl + F |
Command + F |
| Replace |
Ctrl + H |
Command + H |
| Names Ranges |
Ctrl + F3 |
Command + F3 |
| Toggle Auto Completion On or Off |
Ctrl + Shift + Q |
Command + Shift + Q |
| Display the auto suggest list |
Alt + Down Arrow key |
Option + Down Arrow key |
| Insert the current time in cell |
Ctrl + Shift + ; |
Command + Shift + ; |
| Insert the current date in cell |
Ctrl + ; |
Command + ; |
| Insert Line Break in Cell |
Ctrl + Enter |
Command + Return |
| Focus Formula Field |
Ctrl + Shift + F |
Command + Shift + F |
| Edit active cell |
F2 |
F2 |
| Bold toggle for selection |
Ctrl + B |
Command + B |
| Italic toggle for selection |
Ctrl + I |
Command + I |
| Strikethrough toggle for selection |
Ctrl + Shift + 5 |
Command + Shift + 5 |
| Underline toggle for selection |
Ctrl + U |
Command + U |
Selection Shortcuts
| Action |
Windows Shortcuts |
Mac Shortcuts |
| Select Data Region to the Left |
Ctrl + Shift + Left Arrow key |
Command + Shift + Left Arrow key |
| Select Data Region to the Right |
Ctrl + Shift + Right Arrow key |
Command + Shift + Right Arrow key |
| Select Data Region Up |
Ctrl + Shift + Up Arrow key |
Command + Shift + Up Arrow key |
| Select Data Region down |
Ctrl + Shift + Down Arrow key |
Command + Shift + Down Arrow key |
| Select from current cell to the first cell A1 |
Ctrl + Shift + Home key |
Command + Shift + Home key |
| Select from the current cell to the last cell in the data region |
Ctrl + Shift + End key |
Command + Shift + End key |
| Select from the current cell to the first cell in the same row |
Shift + Home |
Shift + Home |
| Select from the current cell to the last cell in the same row |
Shift + End |
Shift + End |
| Select whole spreadsheet |
Ctrl + A |
Command + A |
| Select column |
Ctrl + Spacebar |
Command + Spacebar |
| Select row |
Shift + Spacebar |
Shift + Spacebar |
Formula related Shortcuts
| Action |
Windows Shortcuts |
Mac Shortcuts |
| Start a formula |
= |
= |
| Recalculate Formulas |
F9 |
F9 |
| Toggle absolute and relative references |
F4 |
F4 |
| Auto Sum |
Alt + = |
Option + = |
| Show Function Dialog Box |
Shift + F3 |
Shift + F3 |
| Insert Array Formula on a range of cells |
Ctrl + Shift + Enter |
Command + Shift + Return |
| Toggle Expand and Collapse of Formula Bar |
Ctrl + Shift + U |
Command + Shift + U |
| Select the range of array formula cells surrounding a cell |
Ctrl + / |
Command + / |
Navigation Shortcuts
| Action |
Windows Shortcuts |
Mac Shortcuts |
| Data Region Down |
Ctrl + Down Arrow key |
Command + Down Arrow key |
| Data Region Up |
Ctrl + Up Arrow key |
Command + Up Arrow key |
| Focus Name Box |
Ctrl + Shift + N |
Command + Shift + N |
| Move to the next worksheet in a spreadsheet |
Alt + Right Arrow key |
Option + Right Arrow key |
| Move to the previous worksheet in a spreadsheet |
Alt + Left Arrow key |
Option + Left Arrow key |
| Go to cell command |
Ctrl + G |
Command + G |
| Go to the last cell in the data region |
Ctrl + End |
Command + End |
| Go to the first cell in the data region |
Ctrl + Home |
Command + Home |
| Down one screen |
Page Down key |
Page Down key |
| Up to one screen |
Page Up key |
Page Up key |
| Move to next cell in row |
Tab |
Tab |
| Move to the previous cell in row |
Shift + Tab |
Shift + Tab |
| Select Data Region to the Left |
Ctrl + Left Arrow key |
Command + Left Arrow key |
| Select Data Region to the Right |
Ctrl + Right Arrow key |
Command + Right Arrow key |
Download Zoho Sheet Shortcuts PDF
Download Zoho Sheet Shortcuts PDF
READ NEXT:
