by Allen Wyatt
(last updated December 20, 2013)
When you are collaborating on a spreadsheet with others, it can be a great boon to get everyone's changes all in that single spreadsheet. When your collaborators are all over the country (or the world), it would be great to be notified whenever someone makes a change in the spreadsheet. That way you wouldn't waste time continually checking the spreadsheet to see if others have made changes recently.
Fortunately, Sheets does provide a way to get notifications when things change in a shared spreadsheet. Here's how to set up your own notifications:
Figure 1. The Set Notification Rules dialog box.
Notifications can be set on a spreadsheet-by-spreadsheet basis, but (again) only for shared spreadsheets.
Conditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip ...Discover More
The purpose of gridlines is to make it easy to identify and select cells in a spreadsheet. If you find the gridlines to ...Discover More
Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick ...Discover More