by Allen Wyatt
(last updated February 6, 2014)
Many comments that get added to cells are meant to be used only temporarily. For instance, you might have a series of comments in a spreadsheet that indicate work that still needs to be done within those cells. As you do the work, you'll no longer have need for the comment, so you can get rid of them.
Deleting existing comments is easy. Here's how to go about it:
Figure 1. Comments appear beside cells with which they are associated.
You can, if you prefer, simply resolve comments instead of outright deleting them. A resolved comment is still maintained by Sheets, but it no longer appears as a comment associated with a particular cell. To resolve a comment, select the cell containing the comment and then click on the Resolve button. The comment is removed from the cell, but it is still accessible if you click the Comments button at the upper-right corner of the screen.
Need to know what the day of the week is? Sheets provides a handy function that can return a numeric value that ...Discover More
Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.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 ...Discover More