Getting data analysis done
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 and run a macro
What is a Macro? Macros are sequences of actions that you want to automate. You can do this by creating a VBA macro or record a macro. Create a VBA macro To create a macro: Click Tools > VBA Macros > Create. The Create Macros menu is displayed. ...
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 the Zia icon on the bottom right ...
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.
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.