Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not realize that it inadvertently messed up a whole bunch of other pivot tables and charts as a result? Well, I just did... Fortunately, the Google Sheets revision history feature is pretty darn good and just saved me from having to do a bunch of annoying fixes. Thanks, Google!
3
LVL 5

Expert Comment

by:Juana Villa
I did not know they have a revision history. That is nice!
0
LVL 7

Author Comment

by:Brian Matis
They've done a nice job with it! Can get to it via File > Version history > See version history or the keyboard shortcut of Ctrl + Alt + Shift + H (on Windows that is, not sure for Mac).

Will show you things like who made the change and color coding to call out the update.
Google Sheet Version History Example
1
LVL 5

Expert Comment

by:Juana Villa
THAT IS SUPER NICE!!
1
LVL 56

Expert Comment

by:Scott Fell, EE MVE
Thats why I use Dropbox for everything including development.
1
LVL 19

Expert Comment

by:Kyle Santos
Undo buttons are the best.
2
LVL 7

Author Comment

by:Brian Matis
@Kyle
Undo buttons are the best.
I kid you not, but whenever I do anything klutzy in real life (knock over a mug, bang my shin on something, etc.) I mentally try to hit Ctrl-Z. Sadly, it never works... ;-)
1
LVL 19

Expert Comment

by:Kyle Santos
Truth
1

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month