Google Sheets keeps a detailed version history of your workbook. You can use this version history to track changes and identify when, where and who made a change. You can make a copy of an old version or revert your current sheet back to an old version.
Find out how to check your workbooks changes history in Google Sheets.
In this tutorial, I’ll cover,
- Why you might need to check the version history. 00:05
- How to see the version history 00:18
- What you can see opening version history 00:32
- How to expand to see specific individual history 00:52
- How to see edits individually by colour. 01:01
- Toggle the view on and off. 01:38
- How to Restore a version 01:57
- How to Name a version. 02:30
- How to Make a Copy. 03:10
- How to exit version history 03:47
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*
*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.