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.

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.

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.
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.
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.