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

  • Select a cell of which edit history you want to check.

  • Right-click and go to “Show edit history”.

  • A pop-up with an edit record shows up.

How to show an edit history of a cell

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

How to view the version history of a worksheet

  • (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”.

  • You automatically move to another page with a list of versions on the right side.

  • If you want to check what changes were made, ensure “Show change” at the bottom of the list is checked.

  • Select the version you would like to view.

  • 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.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

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