Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Comments
Is there any way of 'exporting' cell comments to show the text in other
cells? I have a spreadsheet where a large number of cells have comments within them. Obviously these are available on screen when the cursor is moved over the cell but I need to be able to print them all out. Ideally, I just want to copy all of the comments in say A1:A1000 to B1:B1000. Any thoughts? Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Comments
See Debra Dalgleish's site for code to copy to an adjacent column.
http://www.contextures.com/xlcomment...l#CopyAdjacent Or to place them on a new worksheet for printing. http://www.contextures.on.ca/xlcomme...ml#CopyToSheet Gord Dibben MS Excel MVP On Sun, 16 Sep 2007 00:01:44 +0100, "Terry Bennett" wrote: Is there any way of 'exporting' cell comments to show the text in other cells? I have a spreadsheet where a large number of cells have comments within them. Obviously these are available on screen when the cursor is moved over the cell but I need to be able to print them all out. Ideally, I just want to copy all of the comments in say A1:A1000 to B1:B1000. Any thoughts? Many thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Comments
In
Tools-Option-View change view to comment & indicator and try printing the same. "Terry Bennett" wrote: Is there any way of 'exporting' cell comments to show the text in other cells? I have a spreadsheet where a large number of cells have comments within them. Obviously these are available on screen when the cursor is moved over the cell but I need to be able to print them all out. Ideally, I just want to copy all of the comments in say A1:A1000 to B1:B1000. Any thoughts? Many thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Comments
Thanks for the suggestions Gord & Sompura
"Terry Bennett" wrote in message ... Is there any way of 'exporting' cell comments to show the text in other cells? I have a spreadsheet where a large number of cells have comments within them. Obviously these are available on screen when the cursor is moved over the cell but I need to be able to print them all out. Ideally, I just want to copy all of the comments in say A1:A1000 to B1:B1000. Any thoughts? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Comments | Excel Discussion (Misc queries) | |||
Comments into a cell without VB. | Excel Discussion (Misc queries) | |||
print comments using cell contents, not cell# | Excel Discussion (Misc queries) | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
how do I keep comments with cell? | Excel Discussion (Misc queries) |