by Allen Wyatt
(last updated February 6, 2014)
As you are developing a spreadsheet, it can be helpful to add comments that explain your thinking. For instance, you might want to add a comment explaining what a particular cell value means, why a particular formula was used, or additional research that needs to be done. How you use comments is entirely up to you. Here's how you add them to a cell:
Figure 1. Adding a comment to a cell.
You'll notice that the comment remains visible beside the cell. If you move to a different cell, then the comment is hidden, but you can still see a small triangle at the upper-right corner of the cell containing the comment. Hover the mouse pointer over the cell with a triangle, and you'll see the comment. Select the cell with a triangle and the comment is also displayed.
The purpose of gridlines is to make it easy to identify and select cells in a spreadsheet. If you find the gridlines to be ...Discover More
No longer need a previously defined named range? Here's how to get rid of it.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