Excel+++Delete+Multiple+Comments+at+Once


 * Excel Delete Multiple Comments at Once **

If you have got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you are done.

If the worksheet is a large one and you have managed to accumulate quite a few comments, it is going to be frustrating (to say the least) as you move to each cell containing a comment, then either using the **Delete Comment** button on the Review tab of the Ribbon or right-clicking on the cell then choosing **Delete Comment** from the menu.

There is a way to select and remove all comments at one time!

One idea is to select all cells containing comments in one step :– Then **right-click on one of them** and choose **Delete Comment,** or use the **Delete Comment button on the Review tab**.
 * Ctrl + Shift + O** (the letter O, not the number zero).

In one quick click they are all gone – no fuss, no mess!

Another idea is to **select every cell in the worksheet with Ctrl + A**. From there, delete the comments with either a right-click or the Review tab. You could use the **Ctrl key** and select all cells with comments individually and proceed with the deletion.