Getting data analysis done
What is a button in Zoho Sheet?
A button is one of the objects available in Zoho Sheet that allows you to execute an action when clicked. You can assign macros or custom functions to a button and run the macro with the click of the button every time. How to insert a Button? Go to ...Supported Excel classes in Zoho Sheet
Classes Properties Methods <Globals> ActiveCell ActiveChart ActiveSheet ActiveWindow ActiveWorkbook Application Cells Charts Columns Names Parent Range Rows Selection Sheets ThisWorkbook Windows Workbooks WorksheetFunction Worksheets Application ...Supported VBA modules in Zoho Sheet
Classes Properties Methods <Globals> All properties and modules under VBA are globals (i.e., they can be used directly without prefixing the respective module name) All properties and modules under VBA are globals (i.e., they can be used directly ...Create, run and record VBA macros
What is a macro? Macros are special programs that will help you auto-execute specific tasks instead of performing manual tasks repeatedly. Visual Basic for Applications (VBA) is the programming language used to write macros. In Zoho Sheet, you can ...Using Merge Templates in spreadsheets
Merge Templates in Zoho Sheet allows you to create spreadsheets with dynamic data fields with data fetched from external sources, and save the data records as files in Zoho Sheet or share them via email to respective stakeholders. Convert to Merge ...Configure and enable OpenAI in Zoho Sheet
ChatGPT by OpenAI is a generative artificial intelligence tool that processes the given queries and provides detailed responses. Zoho Sheet's integration with OpenAI will enhance the way you analyze your spreadsheet data with advanced AI features. ...How to get data refining suggestions from Zia?
Zia analyzes the selected data set and provides data cleaning and data quality suggestions to check and remove missing values, duplicate records and columns with multiple data types. To get data refining suggestions from Zia: Select the data or cell ...How to get formatting suggestions from Zia?
Zia analyzes the selected data and provides conditional formatting, picklist, and checkbox suggestions. To get formatting suggestions from Zia: Select the data or cell range for which you wish to get suggestion from Zia. From the side pane, go to > ...How to create and manage data connections?
Data connections Data connections help you pull in data from 15 Zoho applications powered by Zoho Flow, in addition to Feeds and URLs. To import data from a URL: Click on the Data > Data Connection > Connect URLs. To import data from other Zoho ...Absolute and relative cell references in a spreadsheet
When using a function/formula, while creating a macro, or a custom function we can use cell references in two ways—absolute and relative. Absolute cell reference The absolute cell reference indicates that the given column and row references are ...Using Spell Check in Zoho Sheet
How to use Spell Check? Zoho Sheet's automatic spell check helps you catch misspelt words and correct them. To use spell check, Select the range you want to check for misspelt words in and click on the Tools menu. Hover over the Spelling option, and ...How to create data validation?
Create a data validation for cells To create data validation: Click Data > Data Validation. You can choose the required range to apply data validation from the dialog shown below. The options that are available include the following: Decimal number, ...Create, apply & manage filters in your spreadsheet
Apply Filter To apply filter: Select the column or range of cells to be filtered. Click Data> Filter or use the Filter icon from Toolbar or right click on the selected range and select Filter from the context menu. Choose the required filtering ...Get AI recommended charts and pivots for your data
What is Zia? Zia, Zoho Sheet's Artificial Intelligence recommends personalized charts and pivots for your data. You can even ask queries in natural language about the data to Zia. Look for Zia's suggestions Click on in the side pane. By default, the ...Find and replace data
1. Click on the Search bar on the right top corner. 2. Click on the drop down menu in the search bar, and from there choose More options. 3. Once this done, a Find and replace dialogue box will appear. 4. In the dialogue box, key in the word you are ...Find and remove data inconsistencies
1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...Fill missing values
1. Click on the Data menu. 2. Navigate to the Data Cleaning tool, and from the drop down choose Fill Missing Values 3. In the data cleaning tab, choose a column for the tool to pick up the empty cells from. 4. Once the tool is done picking up empty ...Remove data duplicates
1. Select the range of cells from which you want to detect the duplicates 2. Click the Data menu. 3. From the menu, select Data Cleaning . 4. Click on Find Duplicates 5. The Data cleaning tool will let you know the number of duplicate and unique ...Recalculate values in Zoho Sheet
Click Edit > Recalculate or use the F9 key, all changes in data will be accounted for and formula cells will be updated. Every time you open or refresh a sheet containing formulas, the values will get automatically updated. However, if you wish to ...Sync live data from webpages to the spreadsheet
To link external data: Click Data > Link External Data. From the dialogue box, choose the type of data you want to link the spreadsheet to. Set the location where the external data is to be placed in the spreadsheet. By default, it is set to the ...Use the solver tool
To use the solver tool, Click on the Tools menu. Select the Solver option. In the dialogue box that opens, choose the Target cell and the Variant cell. Choose to fit what condition should the answer be optimised for– To maximise or to minimise the ...Correct an error in a complex data or formula
To solve faulty results and values: Click Tools > Goal Seek. Enter required target cell and the cell that gives you a varying result and not the result you were expecting. 3. Both the target and variant cells should be formula cells for Goal ...Separate text to different columns
To change text to columns: Select the required cell or column which consists of the text you want to move to separate columns. Click Data > Text to Columns. The Text to Columns dialog box appears. 3. Choose the delimiters such as comma, space, ...Sort data present in cells
To sort data: 1. Select the range of cells to be sorted. 2. Click Data > Sort > Sort Ascending or Sort Descending. 3. To set your conditions for sorting select Custom Sort. You can also use the Sort icon from the tool bar.
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?