How to Delete a Comment in Excel?

Comment in Excel is an incredible feature that lets you add quick notes to different cells. The process of adding comments in Excel is super easy and it takes less than five seconds to do it.

But what if you mistakenly insert a incorrect note and want to delete that? Or you simply want to declutter your worksheet by removing the comments. How do you do that?

Luckily, there are multiple quick ways to delete comments in Excel. We will learn all about these methods in detail in the article below. So without further ado, let’s jump right into it.

How to Delete a Single Comment in Excel?

Deleting a comment in Excel is a simple process and only consists of two short steps. Let’s learn everything about it below.

Say, we have the following comment in our worksheet.

We want to delete the comment in cell B2.

To do that,

1. Select cell B2.
2. Right-click the cell, and a drop down menu will appear.
3. Select Delete Comment from the options at the bottom.

4. Comment in the selected cell will be deleted.

And that’s it! Pretty quick, no?

How to Delete Multiple Comments in an Excel Worksheet?

The process of deleting multiple comments in Excel is the same as deleting a single comment. Let’s see how to do it below.

Say, we have the following data.

We want to delete the comments in cells A2, B3, C4, B5, and A6.

To do that,

1. Press and hold CTRL on your keyboard.
2. Select all the cells containing comments that you want to remove.

3. Right-click any cell containing a comment, and a drop down menu will appear.
4. Click on Delete comment.

5. All selected comments will be deleted from the worksheet in one go.

Otherwise, you can delete every other row or the rows containing blank cells to remove the comments as well (but only if applicable!)

How cool is that? Try it yourself.

COMMENT

You can do the same using the Clear option dropdown on the Home tab. Select the cells containing comments in your worksheet. Go to the Editing section on Home tab and click on the little arrow button next to Clear. A drop down menu will appear. Select Clear comments from the options, and comments in the selected cells will be deleted.

Avoid this though if you want to clear contents without deleting formulas.

How to Delete Multiple Comments in an Excel Worksheet Using the Ribbon?

You can also delete multiple comments in Excel using the ribbon. Let’s see it below.

Say, we have the following sample data.

We want to delete comments in certain cells.

To do that,

1. Press and hold CTRL and select the cells containing comments.
2. Go to the Review tab on the ribbon.
3. Under the Comments section, Press Delete (message icon with a red cross on the top left)

4. Comments in the selected cells will be deleted instantly.

Cool, no?

TIP!

Although this method works great, it can be tiresome to use if you have an entire worksheet filled with comments. But worry not - there is a quick way to delete comments in a worksheet in seconds.

To do this, click on the top left rectangular box on the screen or press CTRL + A. This will select all the cells, then go to the Editing section on Home tab. A drop down menu will appear. Select Clear comments from the options.

And you have it. All the comments from the worksheet will be deleted in seconds.

How to Delete All the Comments in a Workbook Using VBA Code?

We saw how to delete comments in an entire worksheet. But what if you have comments spread out in your workbook, and you want to delete all of them?

We can’t possibly go on deleting comments from each worksheet separately. Well, fortunately, Excel offers a quick way to delete all comments in a workbook in one go using a VBA code.

Let’s see how to do it below.

To delete comments from each sheet in the workbook,

1. Right-click any sheet tab and select View Code from the options or press Alt + F11.

2. Microsoft Visual Basic for Applications dialog box will appear.
3. Select View from the menu bar.
4. Click on Immediate Window or press CTRL + G.

5. The immediate window will appear at the bottom of the screen.
6. Copy and paste the following code in that window.

For each ws in Worksheets: ws.cells.ClearComments: Next ws

COMMENT

Users often make the mistake of only inserting the second half of the statement into the window. Make sure you copy the entire statement in the above block and paste it to the immediate window.

That's because the first half contains the For loop that runs the code in all sheets. If you miss that, the code will not execute and will show a Compile error.

7. Move your cursor to the end of the code and press Enter or F5.

The VBA code will delete all comments from the workbook in one go.

Pretty cool, no?

How to Hide a Single Comment in Excel?

Hiding a comment in Excel involves the same procedure as deleting a comment. Let’s begin with deleting a single comment.

Say, we have the following data.

And we want to hide the comment in cell A2.

To do that,

1. Select the cell containing the comment.
2. Right click the cell – a dropdown menu will appear.
3. Select the option Hide Comment at the bottom.

And it’s done. Comment in the selected cell will be hidden. You can unhide it using the same options.

Try it now!

How to Hide a Single Comment in an Excel Worksheet Using the Ribbon?

You can hide a comment using ribbon in Excel in seconds. The process is simple and is explained below.

Say, we have the following sample data.

We want to hide the comment in cell A2.

To do that,

1. Select cell A2.
2. Go to the Review tab on the ribbon.
3. Toggle the Show/Hide Comment option under the Comments section.

This will hide the comment in the selected cell, and your worksheet will look like this:

That was cool, no?

How to Hide Multiple Comments in an Excel Worksheet Using the Ribbon?

Hiding comments in Excel using the ribbon is a fun process. It is as quick and easy as using the right-click menu. Let’s see how to use it below.

Say, we have the following data.

We want to remove all the comments from this worksheet.

To do that,

1. Click on the rectangular box at the top left corner of the screen or press CTRL + A.
2. Go to the Review tab on the ribbon.
3. Under the Comments section, select the Show/Hide Comments option.

4. All the comments in the worksheet will be hidden.

Easy, no? Try it yourself.

Conclusion

In this article, we saw how to delete comments in Excel using different methods. We also saw how to temporarily hide comments in Excel.

Both processes are incredibly easy to use and offer a quick way to declutter your worksheet and improve its clarity. You can choose to delete a single comment or all at once – Excel offers feasible methods for both tasks.

Not only does this make working with large data easier, but it also helps improve the visual appeal of the worksheet and its navigation.

So what are you waiting for? Try deleting comments in Excel today and add this skill to your Excel skillset.