Delete many cell comments simultaneously

S

sam

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
 
P

PCLIVE

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
 
S

sam

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

But at least now someone can search it...
 
D

David McRitchie

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

Gord Dibben

Select all cells and Edit>Clear>Comments works for me in 2003


Gord Dibben MS Excel MVP
 
Top