Chat with us, powered by LiveChat

Work with Versions

How to Work with Versions in Google Sheets

Work with Versions

After you create a new spreadsheet, every change or edit you make is recorded. The record of these changes is called the version history.

View Versions

  1. Click File on the menu bar.
  2. Select Version history.
  3. Select See version history.
    Work with versions.
  4. The Version history pane appears at the right, showing all previous versions that have been auto-saved.

  5. Select a different version of the spreadsheet.
  6. (Optional) Select the Show changes check box.
    Work with versions.

Any changes that were made are highlighted in green.

Now, selecting a version in this pane doesn't actually bring this version back. You could still click the back arrow and return to the current version.

Restore a Version

If you see a version in the Version history pane that you want to bring back, it can be restored.

  1. Select the version you want to restore in the version history pane.
  2. Click the Restore this version button.
    Work with versions.
  3. Click Restore to confirm.
    Work with versions.

The older version is restored to the active version and you can continue making edits.

Create a Named Version

To make it easier to know which version you're working with, give it a name.

  1. Select File on the menu bar.
  2. Select Version history.
  3. Select Name current version.
    Work with versions.
  4. Type a name for the version and click Save.
    Work with versions.

The name is saved and now it's easy to tell which version this is.

FREE Quick Reference

Click to Download