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.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.