Tip #12: What is Version History and how is it useful? | Revise, revisit, and restore.

Tip #12: What is Version History and how is it useful? | Revise, revisit, and restore.

Online spreadsheets spare you the hassle of creating a new spreadsheet file each time you edit your data set. Collaboration, revision, discussion, and iterations all happen in the same space—so there's no real need to save data as a separate file.

Here's the catch, though. You may sometimes need to revisit an older data set after the spreadsheet has been edited. Fortunately, this is possible thanks to the version history!

What is Version History?

Version History is a Zoho Sheet feature that helps you access the different iterations of your spreadsheet, all the way back to the original. Zoho Sheet automatically saves unlimited versions of your work, so you can always go back and revisit an earlier version at any time. 

Highlighting versions

We do not use the term "unlimited" lightly when it comes to the number of spreadsheet versions we save. To help highlight important versions of your spreadsheet for easy location, Zoho Sheet provides the option to name a version. 

Read the Changelog

If you're looking to revert to a version before a particular change, you should be able to zero in on the new changes made to every version. Zoho Sheet features a Changelog to bring context to each version. If you are looking to pull details on all the historic changes made to the spreadsheet, you can use the Audit Trail.

Share a past version online or offline

If you want to share an earlier version of your spreadsheet, you can easily download that version. If you're looking to collaborate online on a previous version, you can save that version as a new file and share it with your team.

Reverting to a past version

You can always revert your spreadsheet to any of its previous versions, whether it's a version you created or an auto-saved version. Please note that when you do this, all edits made after the selected version will be reversed. The current state of the file will be saved as a version as well, so this is not an irreversible change. 

Version History helps you effectively keep track of your spreadsheets from creation to finalization. Put it to use and let us know how you like the feature.

Follow our Twitter and LinkedIn spaces for product updates and other spreadsheet related information. Thanks for reading!

              Zoho Marketing Automation
                        • Sticky Posts

                        • Tip #7: Four things you didn't know you can do with Conditional Formatting

                          Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which are
                        • Tip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek

                          Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.
                        • Tip #10: 3 helpful ways to use data validation in your spreadsheet

                          Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in your
                        • Tip #8: Using RAND and RANDBETWEEN functions to generate random data sets

                          Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time. If you want to generate a sample data set for a demonstration, or just to learn how a pivot table works, using the RAND and
                        • Tip #3: Save your time by replicating formats

                          Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow.  Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.

                        New to Zoho Social?

                          Zoho Pagesense Resources

                            Zoho SalesIQ Resources

                                  Zoho TeamInbox Resources

                                    Zoho DataPrep Resources

                                      Zoho CRM Plus Resources

                                        Zoho Books Resources

                                          Zoho Subscriptions Resources

                                            Zoho Desk Resources

                                              Zoho Projects Resources

                                                Zoho Sprints Resources

                                                  Qntrl Resources

                                                    Zoho Creator Resources

                                                      Zoho WorkDrive Resources

                                                        Zoho Campaigns Resources

                                                          Zoho CRM Resources

                                                                Design. Discuss. Deliver.

                                                                Create visually engaging stories with Zoho Show.

                                                                Get Started Now