How to Delete All Comments in Excel Spreadsheet

One of the key features of using Microsoft’s office software is being able to pass around documents for editorial work. For example, say you’re editing an Excel spreadsheet, you can leave a comment on a cell for someone to focus on or change. Once the work is finished, the comments can be deleted. But how do you delete all comments in an Excel spreadsheet? You’ve come to the right place for the answer.

Deleting a Single Comment in Excel Spreadsheet

1. Launch Microsoft Excel. Click the File tab in the top left corner of the program and choose Open in the left hand column.

2. Choose the Excel Spreadsheet that contains comments you want to delete and click Open.

choose Delete in the toolbar

3. Now, thumb through the Excel Spreadsheet for a comment you want to delete. Click on the cell that contains the comment. Next, in the top, on the toolbar, click on the Review tab. With the cell highlighted, choose Delete in the toolbar.

Additionally, you can highlight neighboring cells altogether and delete multiple comments.

4. Rinse and repeat until comments are gone.

After deleting a few comments, and realizing you have dozens of more to go, you may have noticed that this method can be quite tedious and time consuming. With a few comments to delete, this method will do just fine, but if you have more than, say 20, you may want to try to use a script to do the work for you, otherwise known as a “Visual Basic for Applications,” or VBA.

Deleting All Comments in Excel Spreadsheet

VBAs are macros that you can use to do the hard work for you. By running the VBA, you can target all comments and delete them all at once. Here’s how:

1. Launch Microsoft Excel. Click the File tab in the top left corner of the program and choose Open in the left hand column.

2. Choose the Excel Spreadsheet that contains comments you want to delete and click Open.

Microsoft Visual Basic for Applications window

3. With Microsoft Excel opened, press together the ALT key and F11, which will open the Microsoft Visual Basic for Applications window.

click the Insert tab

4. In the VBA window, click the Insert tab in the top left portion of the window. In the drop down menu that follows, choose Module. An additional window will appear.

5. Here’s where you get to type up the script or copy and paste, like so:

Sub DeleteAllComments()

'Updateby – insert date using year/month/day format

For Each xWs In Application.ActiveWorkbook.Sheets

For Each xComment In xWs.Comments

xComment.Delete

Next

Next

End Sub

click Run Sub/UserForm6. Without closing the module window, click the Run tab at the top of the VBA window and click Run Sub/UserForm from the drop down menu.