How to delete all comments and notes in the spreadsheet

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

Excel for Microsoft 365 has changed how you work with comments, and now they are called notes.

Notes indicator in Excel 365

 -  Notes in cells are indicated as little red triangles. By default, notes are displayed in a rectangular box with a yellow background.

Comments indicator in Excel 365

 -  Comments are distinguished by little purple comment indicators.

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 365

Note: This command removes all notes and comments in the selection. If you want to delete only some comments, some notes, select cells with these comments and notes and click the Delete button in the Comments group on the Review tab.

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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more