Deleting All Cell Comments in Excel 2016

In this article, we will learn to delete or remove comments in Excel cells.

Comments in Excel to remind ourselves and inform someone else about what the cell contains. To add the comment in a cell, Excel 2016 provides the insert Comment function. After inserting the comment it is displayed with little red triangles.

How to insert comment on the cell?

Go to Review > New Comment
Comment box appears on the selected cell. You can write in the yellow bow.

Let’s delete some comments on the table shown below

1

All the yellow box are the comments on the sheet.

Select the cells where you want to delete comment. In this case,we select the sheet with CTRL + A.

Go to Review > Delete

2

Click Delete to remove the comments

3

Now our worksheet is free of comments.

Hope you got how to delete all cell comments in Excel 2016. Find more articles on similar topics here. Please state your query in the comment box below. We will help you.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel

Comments

  1. Thank you for the very helpful tip. The procedure would also be useful for obtaining other cell information and editing.

  2. Just select the whole sheet.
    Top left corner of your sheet. There where you select the whole workbook cells.
    Then right click, the delete comment. πŸ™‚

    • @Franko unfortunately there is nothing any option on pressing right click to remove or delete comments when you select Top left corner of your sheet. There where you select the whole workbook cells. (till 2013)

      only there is a option to clear contents (which clear all contents)

      πŸ™‚ πŸ™‚ πŸ™‚

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.