Sheets can now view the edit history of a cell

Google has added a new feature in Sheets that lets users view the edit history of a cell. “Show edit history” is a new feature in Sheets that will help you easily see the edit history of a cell, including who made the last edit, when that edit was made, and the cell’s previous value.

Tracking edits made by collaborators is important for keeping information accurate and understanding why specific changes were made and by whom. This is especially critical when there are several collaborators working in a sheet.

Previously, you would need to open up Version History and manually look through past versions of a sheet to determine who changed a cell and when. With Show edit history, you can quickly surface the edit history of a cell: who edited, when, and the previous value.

The following changes are considered previous edits to a cell:

• Adding, editing, or removing content — like changing the value of a cell from “3” to “5”
• Changing a formula — like changing “=A1+B1” to “=A1+C5” 
• Adding, editing, or removing a link from a cell 

Some changes may not show up in the edit history. Some examples are:

• Added or deleted rows and columns 
• Changes to the cell’s format 
• Changes made by formulas