| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting comments
I am working with a spreadsheet that was created by someone in my
company that is no longer around. It is set up so that comment boxes appear for all cells within a certain column. When I search for comments within the spreadsheet, it tells that no comments could be found. I can not figure out if a macro was used to create the comments, or what. Selecting the cells and and selecting "clear comments" does not do the trick. I don't want to clear all comments, though. I only need to clear them from a few columns. Any help on this issue would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting comments
Hi Look at DataValidation in the menubar -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I am working with a spreadsheet that was created by someone in my company that is no longer around. It is set up so that comment boxes appear for all cells within a certain column. When I search for comments within the spreadsheet, it tells that no comments could be found. I can not figure out if a macro was used to create the comments, or what. Selecting the cells and and selecting "clear comments" does not do the trick. I don't want to clear all comments, though. I only need to clear them from a few columns. Any help on this issue would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting comments
Thank you. I believe that's what I was looking for.
Jeff Ron de Bruin wrote: Hi Look at DataValidation in the menubar -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I am working with a spreadsheet that was created by someone in my company that is no longer around. It is set up so that comment boxes appear for all cells within a certain column. When I search for comments within the spreadsheet, it tells that no comments could be found. I can not figure out if a macro was used to create the comments, or what. Selecting the cells and and selecting "clear comments" does not do the trick. I don't want to clear all comments, though. I only need to clear them from a few columns. Any help on this issue would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comments. | New Users to Excel | |||
| anchor comments to cell while inserting and deleting rows | Excel Discussion (Misc queries) | |||
| Add comments without deleting. | Excel Discussion (Misc queries) | |||
| Display Comments on Each Page | Excel Discussion (Misc queries) | |||
| Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Hybrid Mode
