zoho sheet
What are the functions available in Zoho Sheet?
A function/formula begins with an equal to (=) sign and is followed by syntax that lets you do the required calculations. Zoho Sheet supports more than 350 default functions click here to view them.
Run a macro in a sheet
To run a macro: Click Tools > VBA Macros > Manage > Run the macro you want from the list of macros you've created for the sheet. You can also assign a macro to a button and run the macro just by clicking the button.
Record a macro
To record a macro: Click Tools > VBA Macros > Record. Name the macro and continue recording. Note that the macro name can only consist of alphabets, numbers and underscore characters. Click on the box near Use Relative Reference if you want the cell ...
Create a VBA macro in sheet
To create a macro: Click Tools > VBA Macros > Create. The Create Macros menu is displayed. Name the macro that you wish to create. You can also describe the functioning of the macro. Note that the macro name can only consist of alphabets, numbers ...
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.
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 ...
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 ...
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.
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 ...
Apply filters with custom conditions
To apply custom filters: 1. Click on Custom Filter from the drop down menu. 2. Custom Filter lets you choose your condition according to which the data must be filtered. Note: Depending upon the data type chosen, the options that are used to set the ...
Set as document filter
Setting a filter as the document filter means the specified filter will be applied to all the users who are opening the spreadsheet for the first time until the filter is either removed or replaced with another. The published version of the file will ...
Manage named filters
Rename, delete, and reorder named filters using the Manage Named Filters option. Click on the dropdown arrow in the filter icon in toolbar and choose Manage Named Filters. In the Manage dialog, hover the mouse pointer over the filter of choice and ...
Apply a named filter
To use or apply a named filter, Click on the dropdown arrow on the icon in the toolbar and choose Named Filters. From the list of named filters, choose the filter you wish to apply. The filter will be applied on the specified range saved along with ...
Create a named filter
Once you've applied a filter on a range, Zoho Sheet allows you to save it for quick access later on. Select the required filter range and click on the Filter icon in the toolbar or go to Data > Filter. Apply the required filter conditions by clicking ...
Apply Filter
To apply filter: 1. Select the column or range of cells to be filtered. 2. Click Data> Filter or use the Filter icon from Toolbar or right click on the selected range and select Filter from the context menu. 3. Choose the required filtering ...
Change/edit the conditional formats already present in a sheet
To manage conditional formatting: On the menu bar, click Format > Conditional Formatting > Manage Rules. View a rule that has been created in an expanded or a collapsed mode. Choose to edit, copy or clear the rules that have been set and listed under ...
Apply color scales as conditional formats
To apply color schemes as conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on the Color Scales option from the drop down menu. 4. In the dialogue box that appears, select the range of cells ...
Apply color scales as conditional formats
To apply color schemes as conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on the Color Scales option from the drop down menu. 4. In the dialogue box that appears, select the range of cells ...
Apply classic conditional formats
To apply single-color/classic conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on Classic from the drop down. 4. Once the Conditional Formatting window appears, select the range of cells you ...
What is conditional formatting?
Conditional Formatting lets you fix a set of rules, and format cells that fit the rule in a unique way. This way, you can take a quick look at the spreadsheet, and can focus immediately on the cells you want to focus.
Adjust Grid Spacing
1. Click on the Grid Spacing icon on the bottom toolbar. 2. Toggle between the Classic view, Cozy View and Comfort view.
Wrap text
1. Select the cells in which you want the content to be wrapped. 2. Click on the Wrap Text icon on the quick access tool-bar. 3. Alternatively, click on the Format menu and select Wrap Text.
Customize borders
To apply borders with customized colors and line styles: 1. Click on the border icon on the tool bar. 2. In the drop down displayed, select the desired color, line style and the required border option to be applied. The customization can also be ...
Apply borders to cells
To apply borders for cells: 1. Select the cell(s). Click the Borders icon from the toolbar. 2. You can choose from a range of border types that are available . These are the types that you can choose from : You can also choose from the various ...
Change the text color
To change text color Select the cells for which you want to color the font. On the tool bar, click the Text Color icon . Choose the required color. The selected font color is applied to the selected text. To get a preview of the colors, hover over ...
Change a cell's background color
To change the cell color Select the desired cell(s). Choose Fill Color icon from the default tool bar. Click on the required color. The color is applied to the chosen cell.
Change the alignment of data in cells
You can change both the horizontal and the vertical alignment of data entered into the cell. To change the alignment of data inside the cells: 1. Select the cells to be aligned. 2. On the default toll bar, click on Alignment icon. 3. Choose to ...
Remove or clear the formatting from cells
To clear the formatting of a cell: Select the cell you want to clear the formatting of. Click on the Clear icon in the tool bar. You can then choose to clear only the formats from the cell. Alternatively, right click on the cell you want to clear ...
Copy the formats from one cell to another
Format Painter can be used to copy the formatting present in a particular cell to other cells of the sheet. To use Format Painter 1. Select the cell you want to copy the format from. 2. Click on the Format Painter icon from the toolbar. The format ...
Change the format of cells
To apply formatting that suits you: Choose Format > Format Cells. The Format Cells dialog box appears. Select the format in which you want the cells to be in. You can also create customized cell formats. Click OK to apply the format. Alternatively, ...
Embed a spreadsheet from Zoho Sheet
To embed a spreadsheet in your webpage: 1. Click Share > Publish. 2. Choose whether to publish the file in an internally (within your organization)or externally. 3. Copy and paste the HTML code snippet provided under "Embed Code" in order ...
Make my spreadsheet public
To make a spreadsheet public: 1. Click Share > Publish. Choose whether to publish to everyone or within the organization. You can also choose to allow others to export the sheet and to hide your formula cells by using the checkboxes provided. ...
Check in to/out from a spreadsheet
1. In the editor, you can click on the Share option on the left top corner. 2. From there, you can choose to Check in to / Check out from the spreadsheet. Checking out from a spreadsheet will make it Read-Only for all collaborators. 3. Alternatively, ...
Unlock the locked cells
To manage lock settings: Click Data > Lock > Manage Lock Settings. The dialog box shows all the cell ranges and sheets that have been locked by the user for various collaborators. A green lock icon indicates that the particular cell range has been ...
View all the locked cells/range
To highlight locked cells: Click Data > Lock > Highlight Locks or go to the View Settings in the side panel > Highlight Locks. The cells that have been locked for all collaborators will be highlighted and visible now. To remove the cell/range ...
Lock a sheet
You can also lock a particular sheet to be made inaccessible to edit for other collaborators. To lock a sheet Click Data > Lock> Lock Sheet. Lock the sheet to those collaborators for whom you wish to lock the cells. The sheet stays locked to newly ...
Lock cells
To lock a range of cells, Select the particular cell or range of cells that you wish to lock. Select Data > Lock> Lock Cells. You can also right click on the selected range and click Lock Cells. The Lock Cells dialog box appears. Choose the ...
What is the use of 'lock' in Zoho Sheet?
You can lock cells that you don't want the collaborators to accidentally edit. When you publish a spreadsheet, you can always choose to lock formula cells to make your spreadsheet a little more secure. Owners and Co-Owners of the document can lock ...
Restore a previous version of a sheet
To restore previous versions: 1. Go to File > Version History 2. In the Version History panel, select a version and click Revert in the toolbar. The version that you wanted to work will be restored.
Next page