7

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

3

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

|improve this answer|||||
  • I couldn't find this option upon right click – IsmailS Sep 30 '19 at 11:10
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.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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