How to Delete All Comments from a Worksheet in Excel 2013

We have previously written about how to delete a comment in Excel 2013 when you have a specific comment in a spreadsheet that you no longer need. But what if your entire spreadsheet is full of comments that you don/t need? Deleting them individually can be time-consuming if there are a lot of comments, so you may be looking for a simple way to delete all of the comments.

Fortunately you can accomplish this in Excel by making sure to select all of the cells in your worksheet, then using the tool to delete a comment. Excel will then delete every comment from one of the selected cells.

If you need to delete an entire tab from one of your workbooks, then our guide on how to delete a sheet in Excel will show you how.

How to Remove All of the Comments from an Excel 2013 Spreadsheet

The steps in this guide are going to delete every comment in the worksheet that is currently active in your spreadsheet. This doesn’t mean that they will be hidden, or in any way recoverable. Once you complete these steps, the comments will be gone. If there is information in one of the comments that you think you may need later, it is probably a good idea to copy that information to a separate location before you complete these steps.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the worksheet tab containing the comments that you wish to delete.

mass delete excel 2013 comments

Step 3: Click the button above the row 1 heading, and to the left of the column A heading to select the entire sheet. Alternatively you could click on any cell in the spreadsheet and press Ctrl + A to select the entire spreadsheet.

deleting all coomments at once in excel

Step 4: Select the Review tab at the top of the window.

how to remove all comments in excel 2013

Step 5: Click the Delete button in the Comments section of the ribbon.

how to delete all comments in excel 2013

All of the comments in the spreadsheet should now be gone.

Do you have a spreadsheet that has a lot of good or important comments, and you would like to be able to print them out? Learn how to print comments in Excel 2013 so that you can analyze the comments on paper.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy