Deleting a Comment from a Cell

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:

  1. Select the cell that has a comment you want deleted. (You can tell which cells have comments by looking for the small triangle in the upper-right corner of the cell.) The comment appears beside the cell. (See Figure 1.)

    2. Figure 1. Comments appear beside cells with which they are associated.

  2. Click the Delete link. Sheets asks you to verify that you want to delete the comment.
  3. Click Delete. The comment is deleted.

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Adding a Macro to a Toolbar

One of the easiest ways to quickly access a macro is to assign it to a toolbar button. How you make the assignment ...

Discover More

Adding Serial Commas in a Sentence

Part of the job of an editor is to apply standards of grammar to text written by someone else. One standard that may need ...

Discover More

Converting an Unsupported Date Format

Excel makes it easy to import information created in other programs. Converting the imported data into something you can ...

Discover More
More DriveTips

Getting Notified of Spreadsheet Changes

Google Sheets makes it easy to receive notifications by e-mail whenever anything in a spreadsheet changes. Here's how to ...

Discover More

Filtering Data

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

Using Find and Replace in a Spreadsheet

As your spreadsheets get larger, it can be hard to find some information. You may also want to replace some existing ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 4?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Links and Sharing
OUR COMPANY
OUR PRODUCTS
OUR AUTHORS
OUR SITES
 

Copyright © 2018 Sharon Parq Associates, Inc.