How to See Google Sheets Version History
1In this video I'll show you how to see the version history for a Google Sheets spreadsheet.
Timestamps:
Introduction: 0:00
Steps to See Google Sheets Version History: 0:42
Conclusion: 1:58
Check out more great tutorials at https://www.maxdalton.how
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#googlesheets #techtips
Video Transcript:
The more data you pack into a spreadsheet, and the more people you have making edits to it, the higher the likelihood that someone is going to make a mistake. Thankfully, if you're using Google Sheets, the version history feature is enabled by default where Google saves all of your spreadsheet changes automatically. You can use version history to see what was changed, when those changes were made, and who made those changes. And finally, if you see a need to roll back your Google Sheets spreadsheet to a previous version, you can easily do that.
Now let's walk through the steps to see the version history for a Google Sheets spreadsheet.
Step 1. Open a web browser, navigate to www.Sheets.Google.com, and then sign in to your Google account if prompted. You'll land on your Google Sheets home screen.
Step 2. Open the Google Sheets document you want to see the version history for.
Step 3. Click "File" in the menu along the top of the spreadsheet to open a drop-down menu.
Step 4. Click "Version History" in the list of options to open an expanded menu, and then click "See Version History" in the expanded menu. A Version History window is now displayed on the right side of your spreadsheet, showing the dates and times when changes were made to this spreadsheet. When you click on any of the individual date options you'll see the changes on that date highlighted in the document in turquoise. Alternatively, if there were saved changes at different times on the same date, you can click to expand the date and see the different saved versions.
Step 5. Click "Restore This Version" at the top of the screen if you see a previous version of the document that you want to restore it to.