
Doing so will open up a new window showing you what exactly was changed. If you want to see more details about a particular change, you can click on that change in the list. For each change, youll see the date and time it was made, as well as the name of the person who made it. The changes are listed chronologically, with the most recent changes at the top. In the drop-down menu that appears, click on "Show edit history."Ī new window will pop up, showing you a list of all the changes that have been made to those cells. Then, click on the "View" button in the top-right corner of the screen. To do this, first select the cells that you want to view the history for. In addition to viewing the edit history for a single cell, you can also view the edit history for a range of cells. Viewing the Edit History of a Range of Cells Once youve reverted, theres no way to go back to the newer version. Keep in mind that this cannot be undone, so make sure that you really want to revert to an older version before you do.
:max_bytes(150000):strip_icc()/013-how-to-track-changes-google-docs-4690549-2b52e29994ea49f4af3068e6f7505f9b.jpg)
Doing so will replace the current version of the cell with the one you selected. Then, click on the "Restore this version" button in the bottom-left corner of the window. To do this, first click on the version that you want to revert to. If you want, you can also revert to an older version of a cell. This can be helpful if youre trying to track down a particular change that was made, or if you want to see what someone else did. In the drop-down menu that appears, click on "Show edit history."Ī new window will pop up, showing you a list of all the changes that have been made to that cell. To do this, first click on the cell that you want to view the history for. In addition to viewing the edit history for the entire sheet, you can also view the edit history for a specific cell. Viewing the Edit History of a Specific Cell Doing so will replace the current version of the sheet with the one you selected.

If you want, you can also revert to an older version of the sheet.

In the drop-down menu that appears, click on "Version history."Ī new window will pop up, showing you a list of all the changes that have been made to the sheet. Then, click on "File" in the top-left corner of the screen. To view the edit history in Google Sheets, first open up the sheet that you want to view the history for.
#TRACK CHANGES IN GOOGLE SHEETS HOW TO#
In this article, well show you how to view the edit history in Google Sheets. Fortunately, Google Sheets makes this easy to do. That way, you can see who made what changes, and when they were made.
:max_bytes(150000):strip_icc()/013-how-to-track-changes-google-docs-4690549-2b52e29994ea49f4af3068e6f7505f9b.jpg)
If youre working on a Google Sheet with other people, it can be helpful to be able to see the edit history.
