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](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/631e431c01b475f4e80bea98_zdem-ac3kgjoYX0ZpmNbQZMPugNEN-27GX1Frs_-Uw1qsltqNJvOGsUHsfE5juy01WmM3HYUvsSmJV3re6p_c25er7qDlCdviK1p0mUdMZqCsj0skioOfAIkoHPu_qyKYp_IgT9rd_y2CP202_XVHZFYDbDzyZo0AUzSVdTB7fiKI--CfoF6NvJ2vw.png)
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](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/631e431c581e356a658de317_SibU7sBuDH8Hw3vKeZQsG9XjQlPccByWwnc_YnsuWxKQcTIi3pHwtYaBSgB9fttoqKcdtdkzOInQmoiCfuztGF_f8v259lRir-ZJhEn3eHYFw42tYLzmIk3-FGyvItxu610Na7lBCH9e4MCc_kOCcmFRUCx7x9ko5C9bohrl2jfmUujT1PkCmWHGIw.png)
![Restore Version history](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/631e431d95945b17d60ef3d9_NaNdKIcc7orMJygAq_jfzE_bacGGrv9RA9cGu9WbyyPukrcFV1JXb_dABcAZRwrBJ5HdcQPUvAv22b1ci_UvQJa0v7-DdSxgn2jc2xeZpgR1qjC5Lvuwz1e0J1qv1zx_8dAxkkNf5iF1VDPfn9jPZUciHd5mG-iLpfMcMUUx-KJRlgUi4vep26SATA.png)
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.