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.