Printing comments.

[Jerry Park]

Comments print in the format:

Cell: A3
Comment: This is the comment.
Cell: AQ7
Comment: This is the next comment.

Is there a way to have Excel just print the comments on separate lines as:

This is the comment.
This is the next comment.

Thanks.

 

[Orlando Magalhães Filho]

Hi Jerry,

Go File Menu > Page Setup command > Sheet Tab > Print Section > on comments
combobox select an option


HTH

 

[Jerry Park]

That doesn't provide any option to change the way the page prints
(allows printing comments on each page or at the end of the print -- I
want to print the comments without the cell reference and the Comment
header).