How To See Edit History In Google Sheets

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.

Here’s how:

Step 1

Right click on the cell you want to see the edit history for and choose Show Edit History

Step 2

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

Step 3

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:

Step 1

Open the File menu and hover over Version History, then choose See Version History

Step 2

On the Version History screen, recently edited cells will be highlighted

Step 3

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

Step 4

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

Step 5

Close the Edit History by clicking the back arrow in the upper-left corner

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.