Cell Comments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry Bennett - 16 Sep 2007 00:01 GMT

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 to this Message

Gord Dibben - 16 Sep 2007 00:24 GMT

See Debra Dalgleish's site for code to copy to an adjacent column.

http://www.contextures.com/xlcomments03.html#CopyAdjacent

Or to place them on a new worksheet for printing.

http://www.contextures.on.ca/xlcomments03.html#CopyToSheet

Gord Dibben MS Excel MVP

>Is there any way of 'exporting' cell comments to show the text in other
>cells?
[quoted text clipped - 7 lines]
>
>Many thanks.

Reply to this Message

sompura - 16 Sep 2007 14:06 GMT

In
Tools-Option-View
change view to comment & indicator and try printing the same.

> Is there any way of 'exporting' cell comments to show the text in other
> cells?
[quoted text clipped - 7 lines]
>
> Many thanks.

Reply to this Message

Terry Bennett - 16 Sep 2007 22:02 GMT

Thanks for the suggestions Gord & Sompura

> Is there any way of 'exporting' cell comments to show the text in other
> cells?
[quoted text clipped - 7 lines]
>
> Many thanks.

Reply to this Message