Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
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 "sam" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
Nevermind. It's delete one comment, then hilite the sheet, then Edit/Repeat
clear. But at least now someone can search it... "sam" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
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... "sam" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
In , David McRitchie
spake thusly: Indeed, interesting. I've been using Excel fairly heavily for 10 years and never even noticed, let alone used, Edit / Repeat Clear. :-) dman 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... "sam" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete many cell comments simultaneously
Select all cells and EditClearComments works for me in 2003
Gord Dibben MS Excel MVP On Sun, 1 Jul 2007 04:46:22 -0400, "David McRitchie" wrote: 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... "sam" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete columns simultaneously in several different workbooks | Excel Discussion (Misc queries) | |||
Delete added comments | Excel Discussion (Misc queries) | |||
have to change all the comments in the sheet simultaneously | Excel Discussion (Misc queries) | |||
Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
Comments will not delete from Worksheet | Excel Discussion (Misc queries) |