Delete Comments

[DaveNJ0124]

Every month I reuse an Excel 2010 worksheet and delete all the cells, but the comments in the cells of course don't delete and I have to go to each cell and delete each comment. Is there an easier way to delete all the cell comments when I delete content of the worksheet? I am not advanced user so please not to complicated.....

 

[JonathanK]

Highlight the entire excel sheet, go to review tab and you should see the delete comment icon...it's an icon of the comment with an red X

 

[Debraj]

Hi Dave!


I guess "delete all the cells" refers to simply press "DEL" key..

instead of just DEL key use..

Clear All or Clear Comment..


Regards,

Deb