Keep Comments on the same printed page

[Guest]

I have been trying to print a sheet, all on one page, but the Comments always show u
on a second page. I even marked "fit to 1 page", but it always kicks the Comments to a second page
What am I doing wrong
Thanks
Louise

 

[Peo Sjoblom]

File>Page Setup, click the sheet tab, select from dropdown
as displayed on sheet

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Debra Dalgleish]

The comments will print on a separate sheet, even with the settings that
you've selected.

You could use code to extract the comments to a separate sheet, then
copy that information to the bottom of the original sheet before printing.

There's sample code on my web site that might help you:

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

 

[Guest]

Thanks for the suggestion. However, if I do that, the Comments will not print at all.
Any other suggestions to keep the Comments at the bottom of the first page
Thanks again
Louise

 

[Guest]

Thanks! It's great