Printing comments.

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.

Hi Jerry,

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


HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)

"Jerry Park" <NoReply@No.Spam> escreveu na mensagem
news:Yo4Ma.13361$gu6.4029@fe03.atl2.webusenet.com...
> 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.
>
>

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).

Orlando Magalhães Filho wrote:
> Hi Jerry,
>
> Go File Menu > Page Setup command > Sheet Tab > Print Section > on comments
> combobox select an option
>
>
> HTH
>
> ---
> Orlando Magalhães Filho
>
> (So that you get best and rapid solution and all may benefit from the
> discussion, please reply within the newsgroup, not in email)
>
> "Jerry Park" <NoReply@No.Spam> escreveu na mensagem
> news:Yo4Ma.13361$gu6.4029@fe03.atl2.webusenet.com...
>
>>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.
>>
>>
>
>
>