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.
Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a ...Discover More
If you need to fill information into a range of cells, one of the fastest ways of doing it is to use the fill handle. This ...Discover More
The formula bar is where you can see exactly what is stored in a spreadsheet cell. If you would rather hide the formula bar, ...Discover More