Pinting to fit

[jostlund]

I have Excel spreadsheets that I have specified a "Fit To" or "Adjust To"
size to either have the file print all on one page or have all columns on one
page. Is there a way to have the printed page fill the page? When it
reduces to fit there is often a lot of white space - the report looks ugly!
Any suggestions?

 

[Bob I]

"Stretch" in only one direction? You will need to "adjust" the Columns
or Rows in the "white space" yourself.

 

[jostlund]

I'm not sure what you mean - resizing the columns doesn't help.

 

[Stephen]

I think the problem is that you haven't explained clearly what you don't
like about the printed output.

If you have a worksheet that uses about the right number of columns, but
more rows, than would fit on one page at 100%, and you format to fit 1wide x
1tall, then obviously there will be a lot of white space to the left and/or
right of the printing. Is this what you don't like? If not, where is the
white space?

 

[Bob I]

The "fit on one page" keeps the selection proportional. If you select
something "tall and narrow" and fit to a single page, there is going to
be white space on either side. It won't distort the selection to cover
the page with text from one side to the other. You would need to make
the Column in the selection Wider if you want them wider.

 

[Jim May]

Maybe something like:

With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

HTH

 

[Dave Peterson]

Hey, I recognize that recorded code!
<vbg>

Maybe something like:

With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

HTH

 

[Harry's GMail World]

I have Excel spreadsheets that I have specified a "Fit To" or "Adjust To"
size to either have the file print all on one page or have all columns on one
page. Is there a way to have the printed page fill the page? When it
reduces to fit there is often a lot of white space - the report looks ugly!
Any suggestions?

Maybe not exactly what you want. I like to have my Exel sheet fill to
the outer edges. I make the margins .25 for one. Also, I experiment
with making the font size very large...maybe around 80..and adjust the
columns/rows to fit. Also, changing the row/column width/height can
influence. NOTE: Your page setting will auto change in Preview.
For me, it takes some playing around to make it come out right.

 

[Jim May]

Hope you don't mind, it's just that you gave it to me ONLY 2 minutes before,
AND I REMEMBERED IT HooRay (for me) !!!
Merry Christmas to you and your family !!
Jim

 

[Dave Peterson]

No, I don't mind--but since it was generated by recording a macro, you may want
to check with BillG???

Happy Holidays to you and yours, too!

 

[jostlund]

Now I'll really show my ignorance - where do I put this?

 

[Dave Peterson]

This is part of a macro that you would run to change these settings.

But you can do the same thing by:
File|Page setup|Page Tab
Check the "Fit to" button and change it to 1 page(s) wide by 1 tall
(xl2003 menu system)