Editing a Spreadsheet
Rename a worksheet
To rename a sheet: Click besides the sheet name or simply, right click on the sheet name. Select Rename from the list of options. Alternatively, you can double-click on the sheet name and enter the desired name. Before naming your sheet, please refer ...Using the Picklist is Zoho Sheet
What is picklist? Picklist is a drop down list with a predefined set of items. For the cells with picklist, one cannot manually enter any data to it. To populate the cells with picklist, one can only pick a value from the drop down list. How to ...How to merge/unmerge cells in Zoho Sheet?
To merge cells, Select the cells you want to merge. Click on the Merge icon on the tool bar. To unmerge/split merged cells, Select the merged cell. Click on the Unmerge icon on the tool bar. Note: When you merge cells with content in them, please ...How to insert images in a cell?
To insert an image in a cell: Click on the Insert menu. Choose the option to insert Image in cell The Image Library window opens. You can choose to upload from your device, get it from an URL, Google Photos, or even perform a web search for the ...Select multiple cell ranges
To select multiple cells/ranges: 1. Place the selection on one of the desired cell/range. 2. Press Cmd (Ctrl for Windows) and select the other desired cells/ranges. Multi-selection can be used to apply formats to discontinuous ranges simultaneously, ...Select a cell range
To select a cell range using mouse: 1. Click, and drag to select the cells you want. To select a cell range using keyboard: 1. Place the cursor on the desired cell and press Shift + Arrow keys. 2. To select all the filled cells in the data range from ...Insert a hyperlink in a sheet
To insert button: Select the cell you want the hyperlink to be in. Click Insert > hyperlink. There are different places you can point to, using a hyperlink. In Zoho Sheet, you can link to a webpage, a place within the document, a telephone number or ...Insert a note in a sheet
To insert button: 1. Select the cell you want the note to be in. 2. Click Insert > Note. The notes you make are hidden by default and is revealed only when the cell with the note is hovered upon. If you want to show all the notes by default, go to ...Clone/delete a button
To clone/delete a button: Click the Advance Options on the top-right corner of the button or right click on the button. Select Clone or Delete to create a replica of the button or to remove it permanently.Insert a button in a sheet
To insert button: Click Insert > Button. Label the button. Click on the "..." on the right top of the button and choose "Edit Label" to rename the button.Download an image from a sheet
To download an image: Right click on the image or use the Advance Options menu Select Save Image As.Make a copy of an image in the same sheet
To make a copy of an image: 1. Right click on the image or use the Advance Options menu *icon image*. 2. Select Clone.Delete an image
To delete an image: 1. Right click on the image and select Delete. Alternatively, you can click on the image and hit Delete. 2. You can also use the Advance Options menu from the top right corner of the image.Get the image in its original size
To get the original size of an image: Right click on the image and select Resize To Original Size. You can also use the Advance Options menu from the top right corner of the image.Insert images into a sheet
To insert an image: Click Insert Click on Image, and choose the option to insert image over cells. The Image Library window opens. You can choose to upload from your device, get it from an URL, Google Photos, or even perform a web search for the ...Shift cells to the left or above
To shift cells to the left or above: Select the cells to be shifted. Click Edit > Delete > Shift Cells Left or Shift Cells Up to move the cells to the left or up respectively.Insert cells in a sheet / Shift the cells to the right or down.
To shift cells to the right or down: Select the cells to be shifted. Click Insert > Cell > Shift Cells Right or Shift Cells Down to move the cells to the right or down respectively.Delete a row or column from a sheet
To delete a row or column: Select the row or column that you wish to delete. Right click the selected row or column. Click Delete Row or Delete Column from the context menu. You can also right click on a cell that has been selected and choose to ...Insert a new column into a sheet
To insert a column: Click Insert > Column. Right click context menu. You can choose to insert a column before or after the cell that has been selected by clicking on the respective options. If you want to insert multiple columns, select as many ...Insert a new row into a sheet
To insert a row: Click Insert > Row. You can insert multiple rows by selecting as many rows as you want. Alternatively, you can select "Insert" from the right click contextual menu, and click on "Row" from the drop down. Select multiple rows or ...View the condition by removing a checkbox
To remove the checkbox and view the condition: Select the cell where the checkbox is to be removed. Click Edit > Clear > Checkbox. Alternatively, you can select the range of cells you want to remove the checkboxes from, and click on the Clear option ...Add checkboxes to the cells
To add a checkbox: Select the cell(s) where the checkbox is to be added. On the menu bar, click Insert > Checkbox The checkbox can be added to a range of cells also. Checkboxes can also be added to cells with the texts "True" or "False".Editing a cell in Zoho Sheet
Click on the cell that you want to edit. From there, you can take the cell to it's edit state by hitting enter, or double clicking the cell. After the edits are done, you can press enter, and your will be taken to the next line,Copy a sheet to an existing spreadsheet
To copy a sheet to an existing sheet: 1. Right click on the sheet name. 2. Select Copy > Copy $sheet_name$. 3. In the destination spreadsheet, right click on the sheet after which the source sheet is to be pasted and select Paste $sheet_name$.Copy a sheet to a new spreadsheet
To copy a sheet to a new spreadsheet: 1. Right click on the sheet name. 2. Select Copy > Copy to a New Spreadsheet. 3. In the pop-up that appears, select 'Click here' to view the newly created sheet.
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 Bigin?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?