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 formula bar is where you can see exactly what is stored in a spreadsheet cell. If you would rather hide the formula ...Discover More
Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as ...Discover More
When you get a lot of data in a spreadsheet, it can be hard to zero in on the data you really need to work with. That's ...Discover More