Arrow left
Back to guides
Google Sheets Tips

How to See Edit History in Google Sheets

In this article, you will learn how to view a version history in Google Sheets. This is beneficial when you share a Google worksheet with other collaborators and want to check what changes have been made in the document or if you want to restore a previous version.

How to view edit history in Google Sheets

How to see the edit history of a cell

  1. Select a cell of which edit history you want to check.
  2. Right-click and go to “Show edit history”.
  3. A pop-up with an edit record shows up.
How to show an edit history of a cell

How to view the version history of a worksheet

  1. (i) Press “Ctrl” + “Alt” + “Shift” + “H” (for Windows) or “Command” + “Alt” + “Shift” + “H” (for Mac), (ii) click the language, “Last edit was…”  next to the “Help” tab, or (iii) go to the “File” tab → “Version history” “See version history”.
  2. You automatically move to another page with a list of versions on the right side.
  3. If you want to check what changes were made, ensure “Show change” at the bottom of the list is checked.
  4. Select the version you would like to view.
  5. You can also restore a version if you need to by clicking “Restore this version” button, next to the date and time at the top of the page.
How to show a version history of a worksheet in Google Sheets

How a version history looks like

Who can see version history in Google Sheets?

Those who have an edit right of a worksheet can view the edit and version history of the spreadsheet.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below