How to remove all comments in Excel

Problem

We want to delete all comments in Excel. We will see three alternative, the last one using VBA.

Solution

• Option 1
1. On the Review tab click on Show all comments

2. Press Ctrl+A to select all comments
3. Click on Delete

• Option 2
1. Press F5 or Ctrl + G to open Go To dialog box, click on Special and then OK

2. All comments will be selected

3. Right click to open context menu and click on Delete Comment

• Option 3 - VBA
1. Delete all comments from active sheet

Sub Delete_Comments_from_Sheet()
 Cells.ClearComments
End Sub

2. Delete all comments from the workbook

Sub Delete_All_Comments()
    Dim ws As Worksheet

    For Each ws In Worksheets
        ws.UsedRange.ClearComments
    Next

End Sub