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?

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

jostlund wrote:

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?

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

"Bob I" wrote:

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

jostlund wrote:

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?

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?

"jostlund" wrote in message
...
I'm not sure what you mean - resizing the columns doesn't help.

"Bob I" wrote:

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

jostlund wrote:

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?

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.

jostlund wrote:

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

"Bob I" wrote:


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

jostlund wrote:


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 something like:

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

HTH

"jostlund" wrote:

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?

Hey, I recognize that recorded code!
<vbg

Jim May wrote:

Maybe something like:

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

HTH

"jostlund" wrote:

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?

--

Dave Peterson

On Dec 14, 9:09 am, jostlund
wrote:
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.

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" wrote:

Hey, I recognize that recorded code!
<vbg

Jim May wrote:

Maybe something like:

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

HTH

"jostlund" wrote:

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?

--

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!

Jim May wrote:

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" wrote:

Hey, I recognize that recorded code!
<vbg

Jim May wrote:

Maybe something like:

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

HTH

"jostlund" wrote:

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?

--

Dave Peterson


--

Dave Peterson

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

"Jim May" wrote:

Maybe something like:

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

HTH

"jostlund" wrote:

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?

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)

jostlund wrote:

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

"Jim May" wrote:

Maybe something like:

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

HTH

"jostlund" wrote:

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?

--

Dave Peterson