Excel 2007 - Scale To Fit

S

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?
 
J

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.
 

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

Similar Threads

Excel --> Word 4
scale to page error in Excel 2007 3
Space at end of multi page list to accommodate new entries 1
How to make a page fit the whole printed page 1
Excel Scale to Fit problem 1
Fitting to scale? 1
shape doesn't scale to fit when printed 0
Page numbering with Merged Document and IF statements 1

Top