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.
Conditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip ...Discover More
When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. If you don't ...Discover More
One of the layout tools that Sheets provides allows you to merge together a group of cells. Here's how to use that tool.Discover More