Keeping track of the changes made to the spreadsheet
What is version history?
Zoho Sheet automatically saves all previous versions of your spreadsheet. You can visit, revert or download any previous versions of the spreadsheet at any given point of time.
View all the previous versions of a sheet
To view previous versions:
-
Click File > View Version History.
-
A menu opens up and it lists the older versions of the spreadsheet.
-
Click the checkbox near Highlight Changes to observe the modifications between two different versions of the spreadsheet.
-
Find versions faster by filtering them out. Click on the settings icon on the top of the version panel and select the desired list of versions..
-
Simply click on a version to preview it on the spreadsheet at left.
-
Click Changelog to view the changes done in that particular version.
Restore a previous version of a sheet
To restore previous versions:
-
Go to File > Version History
-
In the Version History panel, select a version and click Revert in the toolbar.
The version that you wanted to work will be restored.
To create a new version of a spreadsheet
- Click File. In the drop-down menu select Create version.
- 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.
Download a version
To download a version
-
From the Version history panel, select the version you want to download.
-
In the toolbar, click on the download option
What is audit trail?
Audit trail allows you have a look at all the changes made to the spreadsheet. You can further use audit trail to filter these changes and single out edits based on the user that made the change, the date on which the change was done, and the sheet or range to which the change was done.
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 history based on user, date, sheet or even a specific range.
Manage email notifications for edits made to spreadsheets
To change the notification settings:
- Go to Tools > Email notification settings.
- From the dialog that appears, toggle the button to enable or disable notifications for edits.
- From the dropdown, select whether you wish to receive notifications for all the changes made by the collaborators on the spreadsheet or specific sheet or range.
You can choose to look at the data according to the selected option.
-
User— filters the edits performed by a specific collaborator
-
Date— filters the edits performed on a specified date/period
-
Sheet —filters the edits performed on a specific sheet.
-
Range—filters the edits performed on a specific range selected.
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:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
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 CPaaS?
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
Track changes in your spreadsheet
What is version history? Zoho Sheet automatically saves all previous versions of your spreadsheet. You can view, revert, or download any previous versions of the spreadsheet. Audit trail is a similar tool that allows you to view all changes made to ...Open a spreadsheet from Dropbox/Box (iPhone)
To open a spreadsheet from Dropbox, or Box: Go to Places using the option in the bottom bar of the file listing page. Choose the desired place from which you wish to open the file. For Dropbox and Box, you will need to authenticate your account. Pick ...Locate your spreadsheet's Resource ID
A Resource ID, or an RID of the spreadsheet is an alphanumeric string that forms part of the spreadsheet's URL. The RID always follows the 'open/' part of the URL. For instance, in this URL, ...Share spreadsheet for collaboration (iPhone)
To share a spreadsheet with others: Go to ••• > Add People in the listing page or spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access permission, and tap Share. If you are using Zoho ...Create a new blank spreadsheet (iPhone)
To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
New to Zoho LandingPage?
Zoho LandingPage Resources