Thursday, February 20, 2020

Google Spreadsheets Edit History for Cells

Did you know that you can now find out the edit history of every cell in a spreadsheet?
  1. Control click on a cell
  2. Choose "Show edit history" in the popup menu


  3. Use the arrows in the upper right to scroll from edit to edit. You will be able to see the editor's name, when the edit was made and what was changed/replaced.

This can be especially helpful on shared Google Sheets when multiple users are making edits but also can be used to find your own mistakes on private spreadsheets.