Keeping track of the changes made to the spreadsheet | Zoho Sheet Help Guide

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:
  1. Click File > View Version History.
  2. A menu opens up and it lists the older versions of the spreadsheet.     
  3. Click the checkbox near Highlight Changes to observe the modifications between two different versions of the spreadsheet. 
  4. 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..
  5. Simply click on a version to preview it on the spreadsheet at left. 
  6. Click Changelog to view the changes done in that particular version.  


Restore a previous version of a sheet

To restore previous versions:
  1. Go to File > Version History
  2. 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

  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.


Download a version

To download a version
  1. From the Version history panel, select the version you want to download.
  2. 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.


 
Note:
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 CRM Training
        Redefine the way you work
        with Zoho Workplace

          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 CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION






                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          Offline Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel Kiosk in mobile app
                          Prefill Forms Non-Profit

                          Intake Forms Legal

                          Form Designer HR

                          Card Forms Food
                          Assign Forms Photography

                          Translate Forms Real Estate
                          Electronic Forms

                          Notification Emails for Forms Alternatives
                          Holiday Forms Google Forms alternative 
                          Form to PDF Jotform alternative





                                            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.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Open a spreadsheet from Dropbox/Box

                                                                                                                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 ...
                                                                                                              • Share spreadsheet for collaboration

                                                                                                                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 ...
                                                                                                              • 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,  ...
                                                                                                              • Create a new blank spreadsheet

                                                                                                                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.
                                                                                                              • Check in to/out from a spreadsheet

                                                                                                                Checking out of a spreadsheet makes it read-only for all collaborators of the spreadsheet. The edits made to the spreadsheet will also be inaccessible to them, and they'll not be able to make changes to the spreadsheet until you check-in again. ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources