Edit a spreadsheet
Delete a worksheet
To delete a sheet: Tap on the desired sheet in the Sheet Tab Bar. Choose Delete from the context menu.
Set a worksheet tab color
To change or set a worksheet tab color: Tap on the desired sheet in the Sheet Tab Bar. Choose Color from the context menu. Pick the desired color from the palette.
Copy a worksheet
To copy a sheet: Tap on the desired sheet in the Sheet Tab Bar. Choose Copy from the context menu. Go to the desired spreadsheet and paste the copies sheet using the Paste option in the context menu. Note: You can use the Duplicate option to create a ...
Rename a worksheet
To rename a sheet: Tap on the desired sheet in the Sheet Tab Bar. Choose Rename from the context menu. Enter the desired name and tap Done.
Insert a new worksheet
To insert a new sheet: Tap on the + icon in the Sheet Tab Bar, or tap on the sheet after which you wish to insert a new sheet. Choose Insert from the context menu.
Clear values or formats in a cell range
To clear values or formats in a cell range: Select the cell range where you want to delete or clear the values or formats. In the context menu that appears, choose Clear. This will clear everything in the range by default. To perform specific delete ...
Insert an image in to spreadsheet
To insert an image: Go to icon Under the Insert menu, choose Image. Choose Image In Cell to insert the image within a cell, and Image Over Cells to insert it over the grid. You can choose an image from your device library or take one using the ...
Insert a checkbox
To insert a checkbox: Select the desired cell range on which you wish to insert the checkbox. Go to icon Under the Insert menu, switch on the Checkbox toggle.
Insert a note
To insert a note: Tap the desired cell on which you wish to insert the note. Go to icon Under the Insert menu, choose Note. Type in the desired content for the note and tap on ✓.
Hyperlink data in a cell
To insert hyperlinks: Choose the desired cell/data. Go to icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL/cell range/Email ID, respectively. To display a different text on the cell, enter the desired ...
Navigate inside the spreadsheet
To easily navigate inside your spreadsheet, you can use three options provided by Zoho Sheet: Go to, Quick Scroll, and Scroll Stick. View > Go To helps you navigate to a specific cell reference. Quick Scroll helps you scroll through huge data sets in ...
Fill data into adjacent cells
To perform fill series on a cell range: Select the cell range on which you wish to fill the data, including source data as the first cell. Go to icon Under Data menu, choose Fill. Choose the direction in which you wish to fill the data. Note: You ...
Find and replace values in a spreadsheet
To find and replace values in your spreadsheet: Go to the ... icon, then choose Find and Replace. Enter a value to search in the current worksheet. Navigate between the found values using the icons. Tap the icon to customize the search and to ...
Select multiple cells/ranges
To select multiple cells/ranges: Go to the icon, then choose View from the menu dropdown below the sheet tabs. Turn on the Multiple Selection toggle. This will insert a widget in the editor, using which you can turn on/off multiple selection ...
Create a picklist in a spreadsheet
To create a dropdown list or picklist: Select the desired cell range to apply the picklist. Go to Under the Insert menu, choose Picklist. Enter the values for the dropdown list and apply any desired formats. Note: These formats will be applied on ...
Create a named range
To create a named range: Select the desired cell range. Go to Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value. Enter the desired values and tap Done.
Hide or unhide a row/column/sheet
To hide a row/column/sheet: Select the desired row/column/sheet to hide. In the context menu that appears, choose Hide Row/Hide Column/Hide Sheet, respectively. To unhide a hidden row/column/sheet: Select the row/column that is adjacent to the ...
Insert or delete cells in a sheet
To insert or delete cells, rows, or columns: Select the desired row or column to delete, or before which you wish to insert a new row/column by tapping on the respective row/column header. In the context menu that appears, scroll or tap the icon to ...
Copy and paste values
To copy data in a range: Select the desired cell range to copy. Choose Copy from the context menu. To Paste the copied data: Tap on the desired cell. Choose Paste from the context menu.
Format data in cells
To apply or edit formats: Tap on the cell(s) containing the desired data to be formatted. You can use the Smart Tool Bar at the bottom for quick formats such as Bold, Fill/Text Color, Alignment, and Number Formats. This Smart Tool Bar will show ...
Use functions and formulas
To use a predefined or custom function in your spreadsheet: Double tap on the cell where you want the result to be displayed. Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function ...
Enter data into cells
To edit cells in a spreadsheet: Double tap on the cell you wish to edit or single tap on the desired cell, and use the Edit option in the context menu or the formula bar. This will open the keypad for you to start typing. You can switch between the ...