View Edit History
Edit History in Zoho Sheet allows you to track changes made in cells including details like the name of the person, timestamp, and the value they've added, deleted or modified. This can be highly beneficial if you're doing collaborative work, and want to track the changes your co-workers made.
Audit Trail is a similar tool that lets you view all the user actions made in the spreadsheet including the name of the user, timestamp, cell range, etc.
To view edit history:
- Select the cell you wish to track the changes.
- Go to View > Edit History.
- From the side pane that appears, you can view the details of the changes made.
- Alternatively, you can right click on the desired cell and select Edit History from the contextual menu.
The cell changes were captured only from Jan 20, 2023. Therefore, edits made after the said date will alone be available in the edit history.
List of spreadsheet actions for which edit history won't be available:
- Column/cell/row insertion/deletion.
- Change in cell formatting.
- Undo action on a cell that has a formula or related expression.
- Actions like duplicating a spreadsheet, saving as a new spreadsheet and copying a spreadsheet to a new spreadsheet.
- Reverted version of a spreadsheet.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
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
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
View named filter
To view a named filter: Go to Filter under the Data menu and tap Named Filter. Tap ... besides the name of the filter to edit or delete the existing filter.View spreadsheet properties
The spreadsheet properties panel in Zoho Sheet provides you with the complete details about the spreadsheet and its usage in the form of a summary. You can access the spreadsheet properties using the icon in the top-right corner of the editor or ...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 ...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 ...Edit a comment
To edit a comment: Tap ... and tap Comment Tap ... next to the comment you want to edit and choose Edit. Make the desired changes to the comment and tap on ✔ To cancel the changes made, tap the X icon.
New to Zoho LandingPage?
Zoho LandingPage Resources