zoho sheet
Create a new version of my spreadsheet
To create a new version of a spreadsheet: 1. Click File. In the drop-down menu select Create version. 2. Name the version for future reference on the window that appears and click Create.
Name a version
To name a version: Go to File > Version History. In the Version History panel, select an unnamed version and click Mark this Version on the toolbar.
View the changes made to the sheet
To view changes made to the sheet: 1. Click File > Audit Trail in the menu bar. 2. Audit Trail can be filtered based on different parameters. Use the radio buttons on the top of the panel displayed in Audit Trail in order to sort the cell edit ...
View all the previous versions of a sheet
To view previous versions: Click File > View Version History. 1. A menu opens up and it lists the older versions of the spreadsheet. 2. Click the checkbox near Highlight Changes to observe the modifications between two different versions of the ...
Change the notification settings for comments
To change the notification settings: 1. Click on the comment icon on the side panel 2. Click on the menu icon on the top right corner of the side panel. 3. Click on the Email notification settings and choose how you want to be notified.
Notify all the collaborators in a sheet
To notify collaborators: 1. Click Share > Notify collaborators. 2. Use Notify Collaborators present within Share option 3. In the message dialog that appears, type in your content and click Send. All the collaborators will receive an email with your ...
View all the comments in a sheet
To view all the comments: Click on the comment icon on the side panel. All comments will be displayed in the comments panel. You can choose to filter them for better visibility, based on the sheet associated or status of the comments.
Add a comment in a sheet
To add a comment: Select the cell/range on which you wish to comment. Click Insert > Comment > Add Comment. Alternatively, right click on the selected range and click Add Comment. Enter your comment in the comment field. Click Add.
Share a spreadsheet in Zoho Sheet
To share a sheet: 1. Click Share in the top right corner. 2. Click on Share. 3. Enter the email addresses of the collaborators with whom you want to share the document. 4. You can allow the collaborator to only read the sheet (Read only), read and ...
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.
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.
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.
Get the image in its original size
To get the original size of an image: 1. Right click on the image and select Resize To Original Size. 2. 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: 1. Click Insert > Image. 2. 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 image. 3. After choosing the image click Insert.
Assign macros to a button
To assign macros to a button: 1. Click the Advance Options on the top-right corner of the button or right click on the button. 2. Select Assign an Existing Macro. 3. In the macro list that appears, choose the desired macro and click "Assign". 4. To ...
Clone/delete a button
To clone/delete a button: 1. Click the Advance Options on the top-right corner of the button or right click on the button. 2. 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: 1. Click Insert > Button. 2. Label the button. 3. Click on the "..." on the right top of the button and choose "Edit Label" to rename the button.
Insert a hyperlink in a sheet
To insert button: 1. Select the cell you want the hyperlink to be in. 2. 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 ...
View the condition by removing a checkbox
To remove the checkbox and view the condition: 1. Select the cell where the checkbox is to be removed. 2. Click Edit > Clear > Checkbox. 3. Alternatively, you can select the range of cells you want to remove the checkboxes from, and click on ...
Add a checkbox to the cells
To add a checkbox: 1. Select the cell(s) where the checkbox is to be added. 2. 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".
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 ...
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 ...
Shift cells to the left or above
To shift cells to the left or above: 1. Select the cells to be shifted. 2. 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: 1. Select the cells to be shifted. 2. Click Insert > Cell > Shift Cells Right or Shift Cells Down to move the cells to the right or down respectively.
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 ...
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.
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$.
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,
How do I delete a spreadsheet
You can follow these steps to delete a spreadsheet from your Zoho Sheet file listing page. To delete a spreadsheet: Right click on the file you want to delete. Click on the Delete option. When a spreadsheet is deleted, it is moved to Trash. ...
View all the keyboard shortcuts for sheet
To view the keyboard shortcuts: 1. Click on the Keyboard Shortcuts icon at the bottom right of the editor. 2. This will open a published sheet containing a list of all the keyboard shortcuts in Zoho Sheet.
Unfreeze panes
To unfreeze panes: Select Unfreeze Panes from the View Tab.
Freeze only the first row or column of a sheet
To freeze first row/column: 1. Click View > Freeze First Row or Freeze First Column.
Freeze rows/columns
To freeze panes Place your selection on the cell, the rows and columns before which you wish to freeze. Click View > Freeze Panes. You can also place images and charts on the frozen ranges for better visualization.
Zoom in and zoom out of a sheet
To zoom in or zoom out of the current spreadsheet file, 1. Go to View > Zoom, and select the desired percentage of zoom (or) 2. Use the shortcut Cmd (Ctrl for Windows) and + or - keys to zoom in and out respectively 3. The zooming options can also ...
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, 1. Click, and drag to select the cells you want.
Unhide a hidden row or a column
Please note that Zoho Sheet leaves a green mark in between rows/columns if one or more rows/columns are hidden in between. 1. To unhide a row or a column, hover over the green mark. 2. Click on the arrows that appear when you hover over the mark ...
Hide a row/column/sheet
1. Left click on the row/column/sheet you'd like to hide. 2. Select the Hide row/column/sheet option. 3. Alternatively, you can select the row/column/sheet you want to hide, and click on the View menu. 4. From there, click on the Hide & ...
Hide/unhide the grid lines in a sheet
To hide grid lines: Click View > Hide Gridlines. To make grid lines reappear: Click View > Show Gridlines.
Next page