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 | 65536 |
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 live collaborators (users with edit permission) | 100 |
Maximum number of rows that can be hidden | 65535 |
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 15000 ms. |
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 |
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:
Still can't find what you're looking for?
Write to us:
support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
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 Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
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 ...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 ...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 ...