Edit data in your spreadsheet
Cut/Copy/Paste data
To cut data in a cell: Choose the cell in which you wish to cut the data. Tap Cut from the contextual menu. To copy data from a cell: Choose the cell from which you want to copy the data. Tap Copy from the contextual menu. To paste data into a cell: ...
Insert a hyperlink
To insert a hyperlink: Tap the cell you wish to add hyperlink to. Under the Insert menu, tap Link. Select the link type, specify the link address, and the display format from the respective drop-downs. Once you're done, tap Add at the top-right ...
Insert a checkbox
To insert a checkbox: Tap the cell you wish to add the checkbox to. Under the Insert menu, select Checkbox. You can check or uncheck the box based on your requirement. The logical equivalent of a checked box is TRUE, and for an unchecked box it is ...
Add a comment
To add comments to a sheet/cell: Select the sheet/cell you wish to add comments to. Go to the Insert menu and select Comments. Tap + at the top-right corner and add the comment.
Add a note
To add a note to a cell: Tap the cell/range of cells to which you wish to add notes. Go to the Insert menu and select Note. Once you input the desired note, tap ✓ at the top-right corner of the Note dialog.
Find and replace data
To find particular data and replace it with another: Go to Home in the menu bar and tap Find & Select. Enter the data you wish to find in the sheet and tap Find. To find and replace the data, enter the actual data and the data to replace it with. You ...
Insert or delete rows/columns
To insert or delete rows/columns: Tap the required cell and a contextual menu appears. Select Insert & Delete option. Choose whether you wish to insert or delete rows/columns from the options.
Insert functions and formulas
To insert functions or formulas: Enter = in any desired cell and type in the formula or function. Alternatively, go to the menu bar and tap Insert. Under the Insert menu, choose Function. Zoho Sheet supports 400+ functions and you can choose the ...
Input data in cells
To enter data in a cell: Double-tap any cell and start typing in the data or values or tap on the cell and select Edit from the contextual menu. Alternatively, you can edit any cell from the formula bar. Based on whether your data type is alphabets ...