8

Google Sheets has a revision history accessible from File / See revision history. However, it doesn't appear to easily allow you to see when a particular part of the sheet (e.g. a cell) was changed? Is there an easy way to do this, short of clicking through every revision and seeing when that cell changes?

(Incidentally, I would consider this analogous to features such as git blame from the git RCS).

1
  • I'll stick my neck out (yet!) again and say "No" - based on the deduction that if such existed then most of the many questions asking for a date stamp to be applied when a cell changes would not have been posted. However, that may be a "workaround" for you, ie take one of those scripts and apply it.
    – pnuts
    Jan 23, 2015 at 14:23

1 Answer 1

5

This can now be accomplished via the Show edit history feature. Right-click on a cell and select "Show edit history". It will show you who made the edit, when it was made, and what changed. You can then go back and forward through cell edits.

enter image description here

1
  • I love this feature for an individual cell. I want to compare an entire column between the version of a past date and the current version to see which cells changed. Do you know how I can do that?
    – Farrel
    Jan 13 at 16:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.