How to Add and Delete a Comment in Excel

Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet. And it is very easy to add or even delete a comment in Excel. In this blog, we would learn two ways to add and delete a comment in Excel. It is a two-stepped procedure.

Let us first understand the definition and purpose of an Excel comment and also how can we recognize whether a cell contains a comment or not

What is an Excel Comment?

Comments are notes that are inserted into any cell in Excel. It can be used for any purpose which may include explaining a formula in the cell or giving information about what that cell is about or even can be used for reminders.

How Does an Excel Comment Look?

The Excel comment is a square light yellow color box with black borders around it.

It looks like below:

Excel Comment - How It Looks

How to Recognize Cells that Contain Comment?

The cell that contains any comment has a red color indicator on the top-right of the cell. As you can see in the below screenshot, the cells A1, B4, and C8 have a red triangle on its top-right. This red triangle denotes that these cells contain a comment.

Red Triangle in Cell Represent Excel Comment

How to Add and Delete a Comment in Excel?

As mentioned earlier, there are two ways that you can use to add or delete a comment in Excel.

The first method is by using the right-click options and the other by using available options on the Excel Ribbon tools.

Let us understand both these methods one by one.

Using Right-Click Options

Follow the below steps to add a new comment in Excel.

Select the cell(s) to which you want to add a new comment.

Now, right-click on the selected cell and click on the option “New Comment”.

Right Click Insert Comment Excel

Finally, you would notice that excel adds a new comment to the cell.

New Comment Added To Cell

Similarly, you can delete the comment in Excel.

To delete a comment in Excel. Right on the cell(s) in which comment exists and select the option “Delete Comment” from the list of drop-down options.

Right Click Delete Comment Excel

This would delete the existing comment in a cell.

Two Ways to Insert New Comment in Excel

Using Options of Excel Ribbon

You can also use the options available on the Excel ribbon to add and delete a comment in Excel. Follow the below procedure.

To add a new comment, select the cell(s) to which you want to add a comment.

Now go to the “Review” tab. Under the group “Comments”, click on the option ‘New Comment’, as highlighted in the screenshot below:

Review Tab New Comment Excel

As a result, Excel adds a new comment in the worksheet cell.

Similarly, to delete the existing comment, select the cell(s) that contain comment. Go to the ‘Review’ tab, under the ‘Comments’ group, click on the option ‘Delete’.

Review Tab Delete Comment Excel

As a result, excel deletes the comment from the selected cell(s).

Also, the red-colored triangle on the top-right corner of the cell gets removed.

Two Ways to Delete a Comment in Excel

This brings us to the end of this blog. Share your view and comments in the comment box below.

Leave a Comment