MacOSShortcutsWindows

70 Zoho Sheet Keyboard Shortcuts

for Windows & Mac

Zoho Sheet Shortcuts are used to create, edit, share, collaborate and publish spreadsheets from anywhere around the world for free of cost. It is basically an application that will provide you space for organizing data, discussing reports with the team, and analyzing the data. It is a business problem solver tool.

Download Zoho Sheet Shortcuts PDF

Zoho Sheets can set your office where you are! And to stay focused and work with more productivity, we have listed down Zoho Sheet Shortcuts, especially for you. Download the Zoho Sheet Shortcuts list in PDF format.

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 the last action Ctrl + Z Command + Z
Redo the last action Ctrl + Y Command + Y
Filter Ctrl + Shift + L Command + Shift + L
Fill in 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 the cell Ctrl + Shift + ; Command + Shift + ;
Insert the current date in the 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

Read More: 30 CamBam Shortcuts for Windows

Selection Shortcuts

Action Zoho Shortcuts Windows Zoho Shortcuts Mac
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 the 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 the whole spreadsheet Ctrl + A Command + A
Select column Ctrl + Spacebar Command + Spacebar
Select row Shift + Spacebar Shift + Spacebar

Read More: 25 Reddit Shortcuts You Should Know

Formula related Shortcuts

Action Zoho Shortcuts Windows Zoho Shortcuts Mac
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 Zoho Sheet Shortcuts Windows Zoho Sheet Shortcuts Mac
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 the next cell in the row Tab Tab
Move to the previous cell in the 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

The software that is very much compatible or in other terms an alternative to Zoho is Microsoft Excel. Microsoft Excel is a complete software to meet your needs. You can sign into the list of Excel Shortcuts here.

FAQs

What is Zoho Sheet?

Zoho Sheet is a cloud-based spreadsheet application that allows users to create, edit, and share spreadsheets online. It is part of the Zoho Office Suite, which also includes Zoho Writer (word processing) and Zoho Show (presentations).

How does Zoho Sheet differ from Microsoft Excel?

Zoho Sheet is similar to Microsoft Excel in terms of functionality, but it is a web-based application while Excel is a desktop application. This means that with Zoho Sheet, you can access and edit your spreadsheets from anywhere with an internet connection, while Excel requires the software to be installed on a computer.

Can I import and export data in Zoho Sheet?

Yes, you can import and export data in a variety of formats such as CSV, XLS, and XLSX. You can also connect to external data sources like databases, Google Sheets, and other cloud-based applications.

READ NEXT:

Back to top button