In this article:

Google Sheets: Revert to Previous Version (Easiest Way in 2024)

May 8, 2024

Google Sheets Revert to Previous Version

Follow the steps below to revert to the previous version of Google Sheets. 

1. Go to "File" > "Version history" > "See version history"

Go to the top menu and click on "File." Then select "Version history" and click on "See version history."

google sheets revert to previous version

2. Scroll Through and Find the Desired Version in History Panel

On the right side of the screen, you'll see the version history. Each entry is marked with a date and time.

revert to previous version google sheets

3. Click to Preview the Version Before Restoring

Click on any version to preview it. The sheet will show you what it looked like at that specific date and time.

4. Select "Restore This Version" for the Chosen Date

Find the version you want to revert to and click on it. Then, click "Restore this version" which is usually at the top of the version history panel.

5. Confirm Your Choice to Revert to Selected Version

A prompt will appear asking for confirmation to restore the version. Click "Yes" or "Restore" to proceed.

6. Check Your Sheet to Ensure Correct Version Restoration

Check your sheet to make sure it has reverted to the version you selected.

We hope that you now have a better understanding of how to set up Google Sheets to revert to the previous version. If you enjoyed this article, you might also like our article on how to use Google Sheets offline or our article on whether Google Sheets automatically saves changes.

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 ->