Within Google Sheets, there is a detailed version history of all changes and edits made to each spreadsheet. To check version history, load a spreadsheet and click the “Last Edit Was At” link to the right of the “Help” button. Alternatively, select Version History and “See Version History” from the File menu. This will reveal a detailed log of all the changes that have been made to the spreadsheet. Any of the versions can have its name changed by selecting the three-dot icon and then “Name This Version.” Google Sheets can be then set to display only named versions. Old versions can be restored through the three-dot icon as well.
Key Takeaways:
- To the right of the Help button on the menu bar of a spreadsheet is a “Last Edit Was At” link.
- An alternative method is to look within File and Version History and select “See Version History.”
- You can change the name of a file within Version History by clicking the three-dot icon and “Name This Version.”
“If you’ve opened up a new spreadsheet, be sure to make a few edits so that Google Sheets has some edit history to log.”
Read more: https://www.howtogeek.com/731648/how-to-check-version-history-in-google-sheets/
