Understanding Auto-Save and Version History:
One of the key features of Google applications is that they consistently auto-save, while you’re doing your work! This means, no more losing spreadsheet data that you’ve worked on for hours once your battery dies or you have a power outage.
Any time that you are working in a Google Doc, Sheet, or Slide, you’ll see this text next to the dropdown menus. This text always states the last time the file was edited/saved. Pretty cool, right?!
The next neat feature about auto-save, is the Version History. If you click on the text that displayed the last edit/save time, it will open the Version History of the Google Sheet. You’ll see how it consistently saves at different times. If you click on one of the versions, it even highlights what is different on that version, than the previous saved version.
You also have the option to Restore an older version of the Sheet. Do do this, once you locate the version that you wish to restore, click the Restore this version option at the top of the page. Note, that this will remove any edits that occurred after that version history.