How do you format a sheet to fill the entire page to print?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When printing a longer spread sheet onto one page, how do you format it so
that the width also fills the page and not just the length?
 
you can't automatically..

Excel scales proportionately.. if you notice when you select "fit to 2 pages
long by 1 wide" the percentage automatically adjusts..

One trick you can do is to leave one of the 'fit to' boxes blank.

example.

If you delete the number in the long box and put 1 in the wide box, it will
reduce so the width fills the page, but length will be proportionate to the
percent reduction.
 
You must log in or register to reply here.

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

rows and columns on worksheet 1
Expand text/information to fill sheet for printing 2
PAGE BREAK PREVIEW 1
Workbook Printing Problem 1
printing a spread sheet 1
Formatting Page 1
In Excel, how do I print the cell blocks as well as the data? 2
How do I fit to 1 page on entire workbook 2

Back
Top