View the edit history of a cell in Sheets

Posted: 11 Jun 2019 11:49 AM PDT

What’s changing

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

• To compare Docs:
  • Open any Google Doc — this will become your ‘base’ document.
  • From the toolbar, select Tools > Compare Documents
    • In the dialogue, click on Choose document to select the second Google Doc to compare against.
    • In the “Attribute differences to field”, enter the name of the user who will be labelled as the author of the suggested edits in the comparison output file.
  • Select Compare.

A new document will be generated that shows all existing suggested edits from both docs as accepted. Users will be able to see the differences between both documents as suggested edits labeled with the name defined in the Attribute differences to field.