In this tutorial, you will learn how to see edit history in Google Sheets.
You probably already know that Google Sheets saves every edit automatically so you don’t have to worry about saving your changes, but did you know that Google Sheets also saves the time every edit was made and the user who made the edit? If you ever want to check what changes have been made to a Google Sheet or who made those changes, you can use the Edit History to get a full history of the spreadsheet
See Cell Edit History
The simplest way to see edit history in Google Sheets is to view a specific cell’s edit history.
Right click on the cell you want to see the edit history for and choose Show Edit History
A small popup will appear displaying information about the most recent edit to that cell, including username for the person who made the edit, date and time and previous and new values in the cell
Click on the back arrow to step back through previous edits. Note that this will not change the value in the cell. If you want to revert to a previous cell value, you can copy the previous value from the popup and paste it into the cell
See All Edit History
If you want to see all edits made to a spreadsheet, not only the edits made to a specific cell, follow these steps:
Open the File menu and hover over Version History, then choose See Version History
On the Version History screen, recently edited cells will be highlighted
The sidebar displays information about each edit made to the spreadsheet, with the most recent at the top. Edits are grouped by date made and each edit shows the name of the editor and time of the edit
You can click on an edit version to see what the spreadsheet looked like at that time, and restore that version by clicking the green Restore This Version button at the top
Close the Edit History by clicking the back arrow in the upper-left corner