How to delete all comments and notes in the spreadsheet

Excel 365
When you create a presentation from your draft Excel spreadsheet, you might need to delete all comments. You can delete every comment one by one, but this will take some time. This tip shows the quick way how to delete all comments in your spreadsheet.

There are several different ways how to delete all comments in your spreadsheet quickly, but the fastest and easiest is to:

   1.   Select all cells in your spreadsheet. For example, by clicking Ctrl+A (see also Quick way to select all cells for more details).

   2.   On the Review tab, in the Comments group, click the Delete button:

Delete all comments in Excel 2016

See also this tip in French: Comment supprimer tous les commentaires dans la feuille de calcul.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

See Also

Locking cells in a spreadsheet

Locking cells in a spreadsheet

Sometimes you might want to lock cells in your Excel spreadsheet that contain formulas and functions or data. Thus, the person doing the data entry will not accidentally overwrite or delete the spreadsheet formulas and functions or your data.
How to remove all hyperlinks in your Excel spreadsheet

How to remove all hyperlinks in your Excel spreadsheet

By default, Excel automatically creates hyperlinks when you type or insert URLs or e-mails. You can Turn off the automatic creation of hyperlinks in Excel, or delete all hyperlinks later.
Protecting spreadsheet elements

Protecting spreadsheet elements

Working with large and complex Excel workbooks, especially when entering large amounts of data, no one is protected from accidental changes in formulas, formats, and other spreadsheet elements. But you can protect yourself from too much work on finding and eliminating such errors by protecting the individual spreadsheet elements.