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 characters in a cell | 32768 |
Maximum number of worksheets | 256 |
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 | 30 |
Maximum number of cells you can paste data into | 131072 |
Maximum number of live collaborators (users with edit permission) | 100 |
Maximum number of rows that can be hidden | 131071 |
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 | 1500 |
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() | 25 |
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:
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 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
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 ...Create a form in Zoho Sheet
To create a form: Click Tools > Create Form. Enter the Form Title and Description in the Create Form window and click Create. A new sheet for the form results opens. In the success notification that appears, select 'Click Here'. The form Builder ...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 ...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. Zoho Sheet supported browsers
Zoho Sheet supports the following browsers: Mozilla Firefox - Version 55+ Chrome - Version 55+ Safari - Version 9+ Opera - Version 50+ Edge - Version 12+ Incase you're trying to access Zoho Sheet via an unsupported browser or version, you'll face an ...
New to Zoho LandingPage?
Zoho LandingPage Resources