MacOSShortcutsWindows

70 Zoho Sheet Shortcuts for Windows & Mac

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:

Devil

Hello, My name is Pratik, Founder of Tutorial Tactic. Only the mistakes will help you learn and Tutorial Tactic help you to stand strong and learn even harder & achieve success!

Leave a Reply

Your email address will not be published.

Back to top button