LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize finance!
Read More
Arrow
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.

show an edit history of a cell
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.

Show a version history of a worksheet
How to show a version history of a worksheet in Google Sheets

Restore Version history
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

Cta Photo

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

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

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

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.

Book a demo