I am trying to print an Excel spreadsheet, which is rather large. I want it to be only one page wide, and as many pages tall as is necessary. I want the font to be as large as possible, as long as it is only one page wide.
So, in the print dialog, I told it to fit to 1 page wide, by [blank] pages tall. I selected US Legal for the Destination Paper size and checked Scale to fit paper size (unchecking Scale down only) on the Paper Handling screen. In Page Setup, I chose landscape.
I also tried specifying how many pages tall I wanted the document, but it had no affect. So, if when that field was blank, the document was 5 pages tall, I tried putting in 6, or 7. The document stayed at 5 pages tall, and didn't use any additional width.
In print preview, I am seeing that it is planning to use Legal paper, but it is not using the full width. It seems to have the same border it would use for letter paper.
I am running MS Office 2008 on Mac OS 10.5.