What is Zoho Sheet?
Zoho Sheet is an online spreadsheet application that lets you create, edit, share, and collaborate on spreadsheets. With AI-powered tools for analysis and data cleaning, Zoho Sheet makes your work easier. Read more about Zoho Sheet here.
What can I do with Zoho Sheet?
With Zoho Sheet, you can create, manage and share spreadsheets online. You can collaborate with users/ groups/ organizations in real time. It comes in handy for business people, accountants, scientists, scholars, students and anyone who deals with tabular data and needs to use spreadsheets. Zoho Sheet boosts your productivity by letting you gather, record, analyze, visualize data.
What browsers does Zoho Sheet support?
- Internet Explorer 11 & above
- Mozilla Firefox 50 & above
- Chrome 50 & above
- Safari 9 & above
- Opera 40 & above
What are the supported languages in Zoho Sheet?
Zoho Sheet is available in 18 languages - English, German, Spanish, French, Hungarian, Italian, Japanese, Dutch, Polish, Portugese, Russian, Swedish, Turkish, Chinese, Croatian, Korean, Bulgarian, and Esperanto.
What is the maximum number of cells with data that a Zoho Sheet file can have?
Zoho Sheet supports up to 2 million cells of data in a single spreadsheet (across multiple sheets) with a maximum number of 65,536 rows and 256 columns per sheet.
What are the keyboard shortcuts that I can use in Zoho Sheet?
Click here to get the complete list of keyboard shortcuts that you can use in Zoho Sheet.
How do I get the list of all the functions available in Zoho Sheet?
Zoho Sheet supports more than 400 predefined functions. All the functions supported by Zoho Sheet are listed in the Functions Reference page.
How do I save my spreadsheet?
You don't need to explicitly save your spreadsheet. The moment you edit something, your spreadsheet saves automatically.
Can versions be created in Zoho Sheet?
While Zoho Sheet automatically saves versions of your spreadsheet, you can choose to create versions too. Zoho Sheet stores the most recent 100 versions, if you wish to revert to any of them. Learn how to create a new version, here.
How do I access Zoho Sheet on a smartphone?
Zoho Sheet is available for free download on the App Store and Play Store using which you can install the app and work on your spreadsheets using your iPhones, iPads, Android smartphones and tablets..
What are the supported formats that can be imported into Zoho Sheet?
You can import spreadsheets in one of the below formats:
- .xlsx (Microsoft Excel Workbook)
- .xls (Microsoft Excel 97-2003 Workbook)
- .xlsm (Microsoft Excel Macro - Enabled Workbook)
- .sxc (OpenOffice Spreadsheet)
- .ods (OpenDocument Spreadsheet)
- .csv (Comma Separated Values)
- .tsv (Tab Separated Values)
What is the maximum file size allowed for import?
The maximum file size allowed is 10 MB.
Can protected spreadsheets be imported?
No. You cannot import the password protected spreadsheets. Only unprotected spreadsheets can be imported in Zoho Sheet.
What are the formats to which I can export a spreadsheet?
You can export your spreadsheet into a variety of formats as given below:
- .xls (MS Excel 97-2003 Workbook)
- .xlsx (MS Excel Workbook)
- .ods (OpenDocument Spreadsheet)
- .csv (Comma Separated Values)
- .tsv (Tab Separated Values)
- .html (HTML Document)
- .pdf (PDF Document)
Can I export individual sheets in a spreadsheet?
No, it is currently not possible to export individual sheets which are a part of a spreadsheet.
How many spreadsheets can I export (or download) at a time?
There is no limit on the maximum number of spreadsheets that you can export or download. All the spreadsheets that have been created in the document can be exported. The maximum number of spreadsheets that can be created per document is 256.
Is there an option to use filters in Zoho Sheet?
Yes, you can filter data using the Filter Option from Data tab. Data can be filtered using Cell Value, Cell Color and Text Color. Data can also be sorted using conditions
Can I fetch data from an external source periodically?
Yes. In Zoho Sheet you can fetch data periodically from the configured URL which could include CSV files, RSS Feeds or HTML pages and update the spreadsheet automatically. Click the More menu from the toolbar and select the Link External Data option. Provide URL, select Sheet name in which you want the data to be populated and configure the Schedule to import the data.
Can I rotate a text vertically in Zoho Sheet?
Rotating text in a cell is currently not supported in Zoho Sheet. However as a workaround, you can make the text to appear vertical by typing one character per line and using Ctrl+Enter or Alt+Enter keys for line break within a cell.
Can I pass an array as function argument?
Yes. Array of constant values can be passed to any function as argument. An array should be framed by enclosing the array values with curly braces like {1, 2, 3}. Comma or Semicolon should be used as column separator and vertical bar | as row separator. For example: {1,2,3 | 4,5,6} or {"a";"b";"c" | "d";"e";"f"}. Array functions are executed using Ctrl + Shift + Enter instead of Enter.
Can I view the changes made by collaborators in real time?
Yes. It is possible to view the changes made by the collaborators in real time. The changes made by the owner and the collaborators in the spreadsheet are immediately viewed by other collaborators and the owner. During collaboration, each collaborator is given a color code. The cells in which collaborators work are displayed in the respective colors and highlighted. When you hover the mouse pointer over those cells, the name of the collaborator will be displayed.
Can I be notified whenever shared users modify my spreadsheet?
Though it is not possible to get a notification from Zoho Sheet directly, you can use Zoho Sheet's integration with Zapier and Zoho Flow to achieve the same.
How do I see the list of users viewing my spreadsheet that is shared with them?
In the side panel, you can choose the "Chat" option and then choose "Users" tab to see all the collaborators in your spreadsheet and those who are currently active. The active collaborators profiles will also be displayed at the right bottom of the spreadsheet editor.
Can I send an email to all the collaborators?
Yes, you can send an email to all the shared users by selecting Notify Collaborators option from Share menu. When you use this option, individual emails are sent to each shared user in that particular spreadsheet. You can also choose to send mails only to owners and co-owners of the document or to all collaborators or only to specific collaborators.
How do I make my spreadsheet public?
To make your spreadsheet public, follow the below steps:
- Click Share > Publish
- Select the required options in the dialog box that opens.
- Click OK.
Note*:Once published, anyone can access the URL without signing in to Zoho.
How do I embed my spreadsheet in a website/blog?
To embed your spreadsheet in a website/blog, follow the steps below:
- Click Share > Publish
- Select the required options in the dialog box that opens. Spreadsheet will be made public and a HTML snippet to embed in your website/blog will be shown.
- Copy and paste the snippet in the source code of your web page or blog to embed the spreadsheet.
Can I hide and lock the formula cells while publishing a spreadsheet?
Yes, you can hide and lock the formula cells by checking "Hide and Lock Formula Cells" option in the "Publish Spreadsheet" dialog box while publishing a spreadsheet. Once you select this option, all formula cells will be locked in the published spreadsheet. Users will not be able to view and make any changes to the formula.
How do I restrict the users from exporting the published spreadsheet?
While publishing you can uncheck the "Allow to export" option to restrict users from downloading the published spreadsheet.
Can users make changes to my published spreadsheet?
No. Any changes made to the published spreadsheet will not be saved to the source file. Users can choose to save a copy of the spreadsheet to their Zoho account and edit it later as well.
Can I publish a specific range in my spreadsheet?
Yes, it is possible to publish a specific range from a spreadsheet. To publish a range of cells,
- Click Data > Publish Range > Publish this Range.
Or you can right click the range to be published and choose Publish this Range from the context menu. {Code Snippet}
What are the various chart types that can be created in Zoho Sheet?
Zoho Sheet supports both 2D and 3D charts. The following are the types of charts available
Column, Bar, Pie, Doughnut, Scaled Column/Bar, Grouped Column/Bar, Semi-pie/doughnut, Line, Area, Timeline, Combination Chart, Scatter, Bubble, Waterfall, Funnel, Pareto, Histogram, Wordcloud, Candlestick, OHLC, Polar, Spider Web, Horizontal/Vertical Bullet Charts.
What is the language in which a macro is written in Zoho Sheet?
Visual Basic for Applications (VBA) is the programming language used to write macros in Zoho Sheet.
Can I record a macro and play it back?
Yes, you can record a macro and play it back. Follow the steps below to record a macro:
- Click the VBA Macros option from the Tools menu and select the Record Macro option.
- Name the macro and click Start Recording.
- Do the required actions and click Stop Recording.
To play the recorded macro:
- Click the Macros menu and click on the Run Macro option from the toolbar or press the shortcut Alt+F8.
- Select the macro that you want to run.
What are the events supported in Zoho Sheet?
Zoho Sheet supports the following events:
Workbook Events:
- Open
- New Sheet
Sheet Events:
- Change
How do I run a macro every time a certain cell changes its value?
You can make use of the Change event. This event is triggered whenever the values are entered/edited by the user or by an external link.
Note: This event will not be triggered when a cell value changes due to recalculation.
How do I run a macro automatically every time the spreadsheet is opened?
You can make use of the Open event of the 'ThisWorkbook' module in the VBA editor. This event is triggered whenever a spreadsheet is opened.
Does Zoho Sheet support User Defined Functions?
Yes, user defined functions in Zoho Sheet are powered by Deluge. Click here to learn more about Custom Functions in Zoho Sheet.
Is there any possibility to import/reuse the existing macro from one spreadsheet to another?
No. Currently, it is not possible to import/reuse the macro from one spreadsheet to another in Zoho Sheet. However, you can copy the macro code from the old spreadsheet and paste it in your new spreadsheet.
How do I lock cells in Zoho Sheet?
You can achieve this by performing the following actions:
To lock cells:
- Select the range of cells you would like to lock.
- Click Data > Lock Cells.
- Choose the collaborators for whom you want to lock cells and click the Lock icon.
How can I hide gridines in Zoho Sheet?
To hide gridlines, click View > Hide Gridlines. To bring them back, click Show Gridlines from the same menu.
Can read-only users have the option to filter data in a sheet?
Yes, read-only users can create a new filter and apply existing named filters. However, the users cannot rename or delete an existing named filter.
I see the named filter option disabled in the menu. What should I do?
You can name a filter only if you have specified a condition on the columns of your filter range.
Can I replace an existing named filter with a new filter?
Yes. While creating the new filter, enter the name of the existing filter that is to be replaced. On submission, an alert will be displayed where you can confirm and replace the filter with the new one.
What is the maximum number of named filters I can create in a sheet?
Any number of named filters can be created in a sheet.