Delete many cell comments simultaneously

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there -

Search didn't turn up an answer, so...

I've got a s/s that has a couple of dozen unneccessary comments.

Any way to delete all at once? Not hide, but, delete.

Thanks to anyone who takes the time to reply.

Regards,

Sam
 
Highlight the cells with the comments you want to delete (this can include
cells that do not include comments). Right-click-Delete Comment.

HTH,
Paul
 
Nevermind. It's delete one comment, then hilite the sheet, then Edit/Repeat
clear.

But at least now someone can search it...
 
interesting approach.

"sam" ...
Nevermind. It's delete one comment, then hilite the sheet, then Edit/Repeat
clear.

But at least now someone can search it...
Click to expand...
 
Select all cells and Edit>Clear>Comments works for me in 2003


Gord Dibben MS Excel MVP
 
Back
Top