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 | 50 MB |
Maximum number of rows | 262144 |
Maximum number of columns | 2048 |
Maximum number of cells | 10 Million |
Maximum number of characters in a cell | 32768 |
Maximum number of worksheets | 1024 |
Maximum number of hyperlinks in a worksheet | No limit |
Maximum number of characters in a sheet name | 31 |
Maximum number of characters in a file name | 1000 |
Maximum number of undo actions in a worksheet | 30 |
Maximum number of cells you can paste data into | 3,00,000 |
Maximum number of live collaborators (users with edit permission) | 100 |
Maximum number of rows that can be hidden | 262143 |
Maximum number of columns that can be hidden | 1023 |
Column width | 2000px |
Row height | 2000px |
Limit for Audit Trail | 1000 in Audit Trail dialog. However, further audits will be available in the corresponding version history. |
Limit for Version History | No limit |
Zoom range | 50 % to 400 % |
Number precision | 15 digits |
Maximum number of custom functions | No limit. However, each function is limited to a maximum evaluation period of 3 seconds. |
Maximum number of formulas in a worksheet | No limit. However, each function is limited to a maximum evaluation period of 3 seconds. |
Maximum number of nested functions | No limit. However, the length of the formula can't exceed the cell value limit of 32768. |
Maximum number of iterations in circular references | 10000 |
Maximum number of charts in a worksheet | No limit |
Maximum number of data points in a chart | 5000 |
Maximum number of Pivot Tables in a worksheet | No limit. However, each Pivot Table is restricted to a maximum evaluation period of 15 seconds. |
Maximum number of unique value fields in a Pivot Table row | 10000 |
Maximum number of unique value fields in a Pivot Table column | 250 |
Maximum number of entries in a Picklist | 500 |
Maximum number of items in a filter drop-down | First 5000 unique items |
Maximum file size of image that can be inserted inside and over the cell | 10 MB |
Maximum number of sources files that can be linked to a single destination file using IMPORTRANGE() | 30 |
Access your files securely from anywhere
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:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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 CPaaS?
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
Workflows in Zoho Sheet
Workflows in Zoho Sheet streamline the way your spreadsheet files move through different stages like review, approval, and finalizing without manually tracking the progress. Let's say you are working on a quarterly budget report and want it to be ...HIPAA compliance in Zoho Sheet
The Health Insurance Portability and Accountability Act (including the Privacy Rule, Security Rule, Breach notification Rule, and Health Information Technology for Economic and Clinical Health Act) ("HIPAA"), requires Covered Entities and Business ...Working with comments on your Zoho Sheet spreadsheet
Why should you use comments? You can make cell or range or sheet level comments in Zoho Sheet. These comments can further be replied to, resolved or re-opened for further discussion. You can even @mention your collaborators on your comments to bring ...Working with templates
Import as a new template To import a spreadsheet as a new template, Click on the File menu Click on Import Browse and select the spreadsheet file you want to import. Alternatively, you can also drag and drop the file on to the dialog box. Once you ...Working with other cloud drives (Web)
Zoho Sheet lets you import and export your spreadsheets from/to other cloud drives like Google Drive, Dropbox, OneDrive and Box. Here's how to do it. To import from a cloud drive From the listing page Click on the Upload button on the right top ...
New to Zoho LandingPage?
Zoho LandingPage Resources