In this article:

Google Sheets Version History: The Ultimate Guide in 2024

May 8, 2024

What is Google Sheets Version History?

Google Sheets version history is a part of Google Workspace that lets you view and revert to previous spreadsheet versions. It's useful for tracking changes, understanding document evolution, and recovering lost data.

How to See Edit History in Google Sheets

Follow the steps below to see edit history in Google Sheets.

1. Navigate to the 'File' Menu on Sheets' Top Bar

Go to the top menu of your Google Sheets document and click on 'File'.

google sheets version history

2. Access Version History Under the 'File' Menu

Inside the 'File' menu, select 'Version history', and then click on 'See version history'. This action opens a sidebar on the right, showing different versions of your document.

google sheets edit history

3. Select a Version to View Past Changes

The sidebar displays a list of saved versions with their dates and times. Click on any version to view the changes made during that edit.

google sheets view history

Changes are usually highlighted for clarity.

google sheets history

4. Use the Option to Restore a Previous Version if Needed

To revert to a previous version, click the three-dot menu next to it and select 'Restore this version'.

how to see edit history in google sheets


5. Close the Version History Panel When Finished

After you're done, close the version history by clicking the back arrow at the top of the panel or the clicking outside the panel.

We hope that you now have a better understanding of what the Google Sheets version history feature is and how to see edit history in Google Sheets. If you enjoyed this article, you might also like our article on how to translate in Google Sheets or our article on how to embed a Google Form in an email. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->