I'd like to automatically maintain the original version of a Google Sheets file whenever the file is opened. Manually, this would involve simply opening the file and selecting File/Version History/Name Current Version. But recording a macro of these actions doesn't capture these action.

Alternately, on Google Drive, looking at the versions shows when the file was changed but doesn't allow me to roll back to an older version.

Suggestions appreciated.

  • I'm downvoting this because the feature for rolling back the document to a previous version exists. The original version is thus in the version history. As user0 says, you need to click on "See version history". – ahorn Jun 14 '19 at 13:34

You could map this keyboard shortcut: LEFT ALT + F + H + N and ENTER which does what you want. And as platform you could use AHKscript.

To actually rollback you will need to go here:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.