Have you ever made a change to a spreadsheet, then realized later that it was a mistake? Often these sorts of changes can be rolled back with Ctrl + Z or the application’s Undo option, but sometimes they can’t.
Typically you may decide that you simply need to manually recreate everything, or possible even give up on the current file and start over. But Google Sheets has something called Version History, which you can use to restore the spreadsheet to a version that was saved at some point in the past. Our guide below will show you how.
How to Use Version History in Google Sheets
The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Edge. Note that by restoring a previous version of the file you will be removing any of the edits, changes, or data that have been added to the file since that point.
Step 1: Sign into your Google Drive at https://drive.google.com and open the file.
Step 2: Select the File tab at the top-left of the window.
Step 3: Select Version history from the menu, then click See version history. Note that you can also open that menu by pressing Ctrl + Alt + Shift + H on your keyboard.
Step 4: Click the version of the file that you wish to restore from the list at the right side of the window.
Step 5: Click the green Restore this version button at the top of the window.
Step 6: Click the Restore button on the pop-up window to confirm that you wish to perform the action.
Do you need to open your file in Microsoft Excel, or to send it to someone else that will? Find out how to get an Excel version of your Google Sheets file so that it can be opened in Excel.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.