Excel 2007 - Scale To Fit

[SJH]

In excel 2007, I am attempting to reduce the document to fit within the
number of pages I want. I'm using the "Scale To Fit" function, reducing to
(say) 85% to get all columns onto one printable page.

This worked very simply in excel 2003. If I reduced to 85%, one or two more
columns would be included on the page.

In excel 2007, it's completely opposite. If I reduce to 85%, there are
FEWER columns that fit onto a page, and more pages are printed.

How do you use the Scale To Fit function in Excel 2007 to get more
information onto a page?

 

[JLatham]

Try setting the Width to 1 page and Height to Automatic. That should shrink
the columns to fit across one piece of paper while extending for as many
sheets as it takes to deal with all the rows.