Google Sheets maintains a detailed version history of all the changes or edits you’ve made to your spreadsheets. Here’s how to check your edit log, add version names, and restore them when necessary.

How to Check Version History in Google Sheets

First, open your browser and visit the Google Sheets website, and then load the spreadsheet that you want to work on. 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.

RELATED: The Beginner's Guide to Google Sheets

Once you’ve done that, there are two ways to check version history in Google Sheets. The simplest is to click the “Last Edit Was At” link to the right of the “Help” button in the menu bar.

Click the "last edit" link in the menu bar.

Alternatively, in Google Sheets, you can navigate to File > Version History in the menu bar.

In Google Sheets, you can go to File > Version History to view older versions of your spreadsheet.

In the “Version History” menu, select “See Version History.”

Click "See Version History" to view older versions of your Google Sheets spreadsheet.

This will show you a detailed log of all the changes made to your spreadsheet. You can see this in a pane on the right-hand side of the page. Google helpfully groups these changes by date and also time, which makes it easy to zero in on specific sets of edits to the spreadsheet. You can click any of the timestamps to go to that version.

The expanded version history view in Google Sheets.

Advertisement

To see more versions under any version group, click the small triangular arrow icon, which is located to the left of the timestamp in the version history pane.

After you click the triangle, the menu will expand, revealing a bunch of entries from the version history that should help you find the exact version you’re looking for.

The expanded version history view in Google Sheets.

How to Add Version Names in Google Sheets

Checking version history can quickly get tedious because of the version-naming scheme. Google Sheets names each version with a timestamp, which is a good starting point, but it can get overwhelming on documents with lots of changes.

That’s why it’s a good idea to name specific versions of documents in Google Sheets. We’re not suggesting that you diligently rename every minor change—that’s even more cumbersome—but it’s helpful to tag versions with big changes.

You can easily do this by opening the version history of any spreadsheet in Google Sheets and then clicking the three-dot icon next to the version that you want to name.

In the menu that appears, click “Name This Version,” and Google Sheets will allow you to change the version’s name from a timestamp to whatever you wish.

Click "Name This Version" to rename a version of your spreadsheet in Google Sheets.

Advertisement

When you’re done, hit the Enter key or click anywhere else on the spreadsheet to confirm the name.

A named version of a spreadsheet in Google Sheets.

After naming all of the versions that are important, you can make Google Sheets highlight only named versions of a spreadsheet while checking its version history. This helps you find versions with big changes quickly, without having to go through multiple sets of timestamps.

To do this, open the version history pane in Google Sheets once more. At the top of this pane, just below the “Version History” label, you can enable the option called “Only Show Named Versions.”

Enable "Show Named Versions" to hide all versions with just time stamps for names in Google Sheets.

This will highlight only the versions that you’ve named, along with the most recent version of your spreadsheet.

How to Restore Old Versions of Spreadsheets in Google Sheets

Now that you’ve found the version history of your spreadsheet and learned how to name the versions, it’s time to learn how to restore old versions in Google Sheets. To do this, open the version history pane in Google Sheets and select the correct version of the spreadsheet.

A named version of a spreadsheet in Google Sheets.

The next step is to click the big green button called “Restore This Version,” which is located at the top of the page.

Click the big green button called "Restore This Version," which is located at the top of the page in Google Sheets.

Advertisement

You can also go to the version history pane on the right and click the three-dot icon next to the name of the version. Here, select “Restore This Version.”

Select "Restore this Version" from the menu.

Both methods lead to the same end result—restoring the old version of a spreadsheet in Google Sheets. With that done, you might enjoy reading about how to delete version history in Google Docs.

RELATED: How to Delete Version History in Google Docs

Pranay Parab Pranay Parab
Pranay Parab has been a technology journalist for over 10 years, during which time he's written well over 500 tutorials, and covered everything from social media apps to enterprise software. Pranay lives in Mumbai, India, and keeps traveling around the country and the world.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.