How many times have you been working in a spreadsheet and thought to yourself, “Let me try this idea to see what happens.”
All seems well until you discover a few hours later that downstream data or calculations have failed because of that action a few days ago.
You need to put everything back the way it was, but the UNDO feature won’t go back far enough.
No problem; I’ll just close the file without saving.
Oh, NOOOOOOOOO! Google Sheets saved my mistake. In fact, it saves EVERYTHING instantly.
If you failed to make a backup copy of the file, what options do you have to regain your sanity?
Sheets has two ways to restore earlier versions of files when issues like this arise: Version Recovery and Cell Edit History. Let’s see how these work.