Getting Started with Zoho Sheet
Filter data in pivot tables based on dates with timeline
What is a timeline? Timeline allows you to filter data in your pivot tables based on dates quickly. To add a timeline to your spreadsheet, there should be a pivot table with a date range. How to add a timeline Right-click the pivot table and select ...View and unhide all the hidden sheets
To view and unhide all the hidden sheets: Go to View > Hide & Unhide > Hidden Sheets > Unhide All Sheets. Alternatively, to view and unhide all the hidden sheets from the status bar, select Unhide > Unhide All Sheets from the contextual menu.Search for the sheet name in your workbook
To search the name of any preferred sheet: Go to the status bar, click and type the preferred sheet name in the search bar.Customize the gridline color
To customize the gridline color of your workbook: Go to File > Spreadsheet settings > General Under View, select the preferred gridline color for your workbook. Click OK. To customize the gridline color of any sheet: Go to View > Gridlines and select ...Unsupported features in file export
While Zoho Sheet supports an extensive set of features for users to collect, organize, scrutinize, and visualize their data, some of these options may not be available on exporting the spreadsheet. Here's the list of features or options that will not ...View spreadsheet properties
The spreadsheet properties panel in Zoho Sheet provides you with the complete details about the spreadsheet and its usage in the form of a summary. You can access the spreadsheet properties using the icon in the top-right corner of the editor or ...How to highlight the current cell's row and column?
Highlighting the current cell's row and column helps you navigate through large data sets without any distractions. This highlighting option doesn't help you format any data sets in your spreadsheet. To highlight the current cell's row and column: Go ...Locale and calculation settings in your spreadsheet
To customize the gridline color and font of your spreadsheet: Go to File > Spreadsheet Settings. In the Spreadsheet Settings tab under General, select the preferred Font Name, Font Size, Text Color, and Gridline Color. Click OK. To customize the ...Insert functions to your spreadsheet
Zoho Sheet has around 400 prebuilt functions that can help you. To insert a function, 1. Select the cell you want the function in. 2. Click on the Insert menu. 3. Choose to insert a Function. 4. From the side pane, you can select which function you'd ...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. Connect Zoho Sheet to hundreds of other apps with Zapier.
Zapier lets you connect Zoho Sheet to 1,000+ other web services. Automated connections called Zaps, set up in minutes with no coding, can automate your day-to-day tasks and build workflows between apps that otherwise wouldn't be possible. Each Zap ...Custom functions in Zoho Sheet
Though Zoho Sheet supports around 400 functions by default, for simple and complex calculations, we understand that our users have their own business logic that requires personalized functions. Additionally, Zoho Sheet also allows you to bring in ...Do I need to save my spreadsheet after editing in Zoho Sheet?
No. Every modification you and your collaborators make to the Zoho Sheet spreadsheet will be automatically saved. The last modified time of the spreadsheet is shown at the right top corner. You can use features like Audit Trail and Version History ...Print spreadsheets in Zoho Sheet
To print your spreadsheet or just a selected area, Click on the File menu, and click on the Print option. (or) Click on the printer icon on the tool bar. (or) Use the Cmd/Ctrl+P shortcut. Once on the print preview window, here are all the options ...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 ...Publish a spreadsheet
How to publish a spreadsheet? 1. Click on the Share button on the right top corner. Alternatively, you can also click on the file menu and select the Publish option to open up the dialog box. 2. From the drop down, click on the Publish button. 3. ...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 262144 Maximum number of columns 1024 Maximum number of cells 8 Million Maximum number of ...Using the Zoho Sheet browser extension and web clipper
You can download and install the Zoho Sheet web clipper on Chrome and FireFox. Zoho Sheet's browser extension makes it easier to work with your spreadsheets . Here's how you can use it. To create a new spreadsheet Click on the Zoho Sheet web clipper ...Importing spreadsheets to Zoho Sheet
Import a new spreadsheet From the listing page, click on the Upload button. From the drop down, select the option to Upload Spreadsheet. You can drag and drop files from your computer into the dialog box that pops up, or click on the dialogue box and ...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
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 ...How to download your spreadsheet as a password protected file?
Click on the File menu. Hover over the Download as option From the menu that appears, choose the option to download as Password Protected File. In the dialog box that appears, enter your desired password. Hit download.How to turn on night mode in Zoho Sheet?
Toggle the switch in the right bottom corner to turn on the Night mode. Toggle again to turn it off.Locate your spreadsheet's Resource ID
A Resource ID, or an RID of the spreadsheet is an alphanumeric string that forms part of the spreadsheet's URL. The RID always follows the 'open/' part of the URL. For instance, in this URL, ...Link data across spreadsheets quickly
What is IMPORTRANGE, and when to use it? One of the impressive things about spreadsheets, as opposed to other applications for computation or data storage, is being able to refer to the value of one cell in whichever cell you want, even as part of a ...Unhide a hidden row or a column
Please note that Zoho Sheet leaves a green mark in between rows/columns if one or more rows/columns are hidden in between. 1. To unhide a row or a column, hover over the green mark. 2. Click on the arrows that appear when you hover over the mark to ...Hide a row/column/sheet
1. Left click on the row/column/sheet you'd like to hide. 2. Select the Hide row/column/sheet option. 3. Alternatively, you can select the row/column/sheet you want to hide, and click on the View menu. 4. From there, click on the Hide & ...Zoom in and zoom out of a sheet
To zoom in or zoom out of the current spreadsheet file, 1. Go to View > Zoom, and select the desired percentage of zoom (or) 2. Use the shortcut Cmd (Ctrl for Windows) and + or - keys to zoom in and out respectively 3. The zooming options can also ...Hide/unhide the grid lines in a sheet
To hide grid lines: Click View > Hide Gridlines. To make grid lines reappear: Click View > Show Gridlines.Freeze rows/columns
To freeze first row/column Click View > Freeze > Row 1 or Column A. To freeze panes up to selected row/column Place your selection on the cell, the rows and columns before which you wish to freeze. Click View > Freeze > Up to selected row or column. ...Know all the keyboard shortcuts for sheet
Here's the list of Zoho Sheet's keyboard shortcuts for Mac and Windows: Shortcuts for file operations Description Mac Windows Open file Cmd + O Ctrl + O Save as file Cmd + Shift + S Ctrl + Shift + S Print file Cmd + P Ctrl + P Shortcuts for edit ...Access a list of my recent spreadsheets
Access your recent spreadsheets easily without having to search through the entire collection of spreadsheets used. Click on the File menu. From the drop down, hover over Open. A list of your recent spreadsheets will be displayed. Click on the one ...Add a spreadsheet to my favorites list
To add important spreadsheets to your Favorites list: 1. Click the Star icon near the spreadsheet name in the editor. 2. The star icon will turn yellow , indicating that your spreadsheet has been added to your favorites list.You'll find these ...How do I delete a spreadsheet
You can follow these steps to delete a spreadsheet from your Zoho Sheet file listing page. To delete a spreadsheet: Right click on the file you want to delete. Click on the Delete option. When a spreadsheet is deleted, it is moved to Trash. ...Rename a spreadsheet
By default, a new spreadsheet created will be named "Untitled Spreadsheet". To rename a spreadsheet: Click the title of the spreadsheet at the top. Type the new name of the spreadsheet and press enter. You can also choose Rename from File menu to ...Make a copy of the spreadsheet
To copy/duplicate your spreadsheet under a separate name, then use the following steps: Click File and then choose Save As from the drop-down menu or use the keyboard shortcut i.e. Cmd+Shift+S. Enter the new name under which you wish to save the ...Export a spreadsheet from Zoho Sheet
To export spreadsheets: Click File > Download As. Choose the format in which you want the spreadsheet to be exported. The formats in which a sheet can be exported are as follows: ● MS Excel Workbook (.xlsx) ● MS Excel 97 - 2003 Workbook (.xls) ● ...What are the file formats that Zoho Sheet supports?
The supported file formats which can be imported to Zoho Sheet are: MS Excel Workbook (.xlsx) MS Excel 97-2003 Workbook (.xls) Excel Macro-enabled Workbook (.xlsm) OpenDocument Spreadsheet (.ods) Comma Separated Values (.csv) Tab Separated Values ...Create a new spreadsheet in Zoho Sheet
To create a new spreadsheet: Click on the File menu. From the drop down, choose New Spreadsheet. Alternatively, from the Zoho Sheet Listing Page, click on the "New Spreadsheet" on the right top. If you're trying to create a new spreadsheet from the ...
Access your files securely from anywhere
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 Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
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
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?