Quickly Delete All Comments from Excel

Описание: .
My Full Excel VBA/Macro Course [Discount]: https://www.teachexcel.com/vba-course...
Download the File: https://www.teachexcel.com/excel-tuto...

How to delete all comments and notes from all worksheets in Excel.

This works with old style "notes" and new "comments" and it does not matter if they are hidden or visible.

VBA Macro Code to Remove All Comments from a Workbook:

For Each ws In Worksheets: ws.Cells.ClearComments: Next Ws

Steps to Remove All Comments from a Worksheet
Select all cells in the worksheet.
Go to the Home tab - Editing Section on the right - Clear - Clear Comments and Notes.

Resources
Comments in Excel (Microsoft): https://support.microsoft.com/en-us/o...

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel