How to Remove Pop-up Comments in Excel (4 Suitable Ways)

We have a data set with some comments in the cell, which are giving pop-up comments when hovering over the arrows at the edges of the cells. We will hide or remove them.

Method 1 – Hide Pop-up Comments from Excel Options

Steps:

Go to File and select Options.

The Excel Options window will appear.
Go to the Advanced tab and go to the Display option.
In the “For cells with comments show” menu, select the option “No comments, notes, or indicators”
Press OK.

No comment arrows are visible in the cell corners. There are also no comments in the cells.

Method 2 – Remove Pop-up Comments via the Right-Click Context Menu

Steps:

Right-click on the cell with a comment.
Click on the “Delete Comment” option.
Delete all the comments to remove the pop-up comments in Excel.

Method 3 – Delete Pop-up Comments from the ‘Comments’ Window

Steps:

Go to the Review tab.
You will find “Show Comments” in the Comments menu.
Click on this and you will see a window named “Comments” appear on the right side of the worksheet.
You will find all the comments on this worksheet in a list.

Click on the 3 dots (…) in the top right corner of a comment.
Click on the Delete thread option to delete this comment.

Repeat to delete all comments.

Method 4 – Use VBA Code

Steps:

Go to Developer and select Visual Basic.
The Visual Basic Editor window will appear.

Click on the View tab.
Select Immediate Window from the menu or press Ctrl + G to open this.

You will find a new window at the bottom named “Immediate”.
Paste the following into the box.

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

While the mouse cursor is in the window, press Enter.

Using this VBA code will clear all the comments from the worksheet.

Remove Data Validation Pop-up Comments in Excel

Select the range of cells where pop-up comments are showing.
Go to the Data tab in the top ribbon and select the Data Validation icon in the Data Tools menu.