Problem with printing comment in Excel 2007

M

Michelle

I have inserted in cell C23. Colum A is set so that it appears on each
printed page. When I preview the worksheet all looks good, but when I print
it, the comment appears on each printed page.

Any help appreciated,
 
D

Dave Peterson

Do you want to see that comment at all?

If yes, then move it to the right (outside of column A).

If no, show the print setup dialog (not via print preview)

Then on the Sheet tab, turn off the "comments" option
(Don't use "as displayed on sheet").
 
M

Michelle

Hi Dave
Yes, we do want to see the comment.
Sorry, my question wasnt very clear - I have inserted a comment in cell C23.
Have set column A to print on every page, but the comment in cell C23 also
prints on every page.
 
D

Dave Peterson

Comments can float almost anywhere. They can float near column C or the can be
far away--column IV if you want!

If your comment is floating over column A, then it'll show up on the paper like
you describe.

Show the comment (if you it's not visible now).

Click on the border's edge of the comment and drag it to the right.

If this doesn't help, maybe it's time to give more details.
Hi Dave
Yes, we do want to see the comment.
Sorry, my question wasnt very clear - I have inserted a comment in cell C23.
Have set column A to print on every page, but the comment in cell C23 also
prints on every page.
 
M

Michelle

Thanks Dave,
Dragged comment to column E, but still prints on every page. What other
details do you want?
 
D

Dave Peterson

That was enough.

I don't have have any other other suggestions.

Maybe one...

If you delete the comment and then re-add it, does anything different happen?


Thanks Dave,
Dragged comment to column E, but still prints on every page. What other
details do you want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top