How to delete all comments in excel

Answer

To delete all comments in Excel, use the built-in review tools that remove every comment from the active sheet or the entire workbook. Excel stores comments as threaded notes in modern versions, and the deletion process clears all associated comment objects.

Delete All Comments on Windows

Using the Ribbon

1. Select the worksheet where you want to delete comments.

2. Go to the Review tab.

3. Select Delete in the Comments group to remove the comment in the active cell.

4. Select the dropdown arrow beside Delete.

5. Choose Delete All Comments or Delete All Comments in Document depending on your Excel version.

Using the Right-Click Menu

1. Right-click any cell that contains a comment.

2. Select Delete Comment to remove the specific comment.

3. Press Ctrl + A to select the entire sheet first.

4. Right-click again and select Delete Comment to remove all comments.

Delete All Comments on Mac

Using the Ribbon

1. Select the worksheet.

2. Go to the Review tab.

3. Open the Comments dropdown.

4. Select Delete All Comments.

Using the Right-Click Menu

1. Select the entire sheet using Command + A.

2. Right-click any cell containing a comment.

3. Select Delete Comment.

Delete All Comments in an Entire Workbook

Using Find & Select (Windows and Mac)

1. Select the Home tab.

2. Choose Find & Select.

3. Choose Go To Special.

4. Select Comments in the dialog box.

5. Select OK to highlight all commented cells.

6. Press Delete on the keyboard to remove the comments.

Delete All Notes (Legacy Comments)

Excel distinguishes between comments (threaded) and notes (old-style). Notes require their own deletion method.

Delete All Notes

1. Go to the Review tab.

2. Open the Notes dropdown.

3. Select Delete All Notes.

Best Practices for Managing Comments

1. Maintain a backup workbook, because comment deletion cannot be reversed when the file is saved.

2. Review the Show/Hide Comments panel before deletion to identify comment density.

3. Use Protect Sheet after cleanup to prevent accidental future comment entry.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report