The print area of my spreadsheet is around 13x20 cells. What do
I need to do to tell Excel to print my sheet on just ONE page and
to cover the ENTIRE page???

I tried setting all margins to 0, set landscape orientation, and I
set the "scale" width and height to 1 page. Anybody got any advice??

Thank you!

Look up the FitToPagesWide and FitToPagesTall properties in the help
files... they are properties of the PageSetup object.

--
Rick (MVP - Excel)


"Robert Crandal" <(E-Mail Removed)> wrote in message
news:ImTEm.36024$(E-Mail Removed)...
> The print area of my spreadsheet is around 13x20 cells. What do
> I need to do to tell Excel to print my sheet on just ONE page and
> to cover the ENTIRE page???
>
> I tried setting all margins to 0, set landscape orientation, and I
> set the "scale" width and height to 1 page. Anybody got any advice??
>
> Thank you!
>
>

If the data isn't enough to fill the page, you could experiment with Font size
-- or even the scaling factor.

In xl2003 menus:
File|Page setup|Page tab|Adjust to
and make it bigger than 100%

But if your data doesn't match the same layout of the sheet, you'll find that
you can fit the width nicely--or the length nicely--but not both at the same
time.

Robert Crandal wrote:
>
> The print area of my spreadsheet is around 13x20 cells. What do
> I need to do to tell Excel to print my sheet on just ONE page and
> to cover the ENTIRE page???
>
> I tried setting all margins to 0, set landscape orientation, and I
> set the "scale" width and height to 1 page. Anybody got any advice??
>
> Thank you!

--

Dave Peterson

I think the problem is that I can't find a way to totally eliminate
all the margins. I tried setting all margins to ZERO, yet
I still cant seem to find a way to print my sheet to cover
the entire page. Ugh, there must be a way??

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If the data isn't enough to fill the page, you could experiment with Font
> size
> -- or even the scaling factor.
>
> In xl2003 menus:
> File|Page setup|Page tab|Adjust to
> and make it bigger than 100%
>
> But if your data doesn't match the same layout of the sheet, you'll find
> that
> you can fit the width nicely--or the length nicely--but not both at the
> same
> time.

I tried pasting the following Visual Basic code into some of my
Excel modules:

With Worksheets("Sheet1").PageSetup
.Zoom = False
.FitToPagesTall = 1
.FitToPagesWide = 1
End With


I then tried printing my sheet, but I saw no difference at all. I just to
eliminate all margins to zero, and force excel to print my print area
on one ENTIRE page.

Got any more tips??


"Rick Rothstein" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Look up the FitToPagesWide and FitToPagesTall properties in the help
> files... they are properties of the PageSetup object.
>
> --
> Rick (MVP - Excel)
>
>

If I understand correctly from your response to Dave, you are trying to
print your worksheet from edge-to-edge all around on your sheet of paper...
I don't think you will be able to do that. With the exception of smaller
photos, it is my understanding that printers don't print that way (something
to do with holding the paper as it advance through the printer)... it is a
limitation of the printer and not something you are doing wrong in Excel.

--
Rick (MVP - Excel)


"Robert Crandal" <(E-Mail Removed)> wrote in message
news:lN2Fm.16144$(E-Mail Removed)...
>I tried pasting the following Visual Basic code into some of my
> Excel modules:
>
> With Worksheets("Sheet1").PageSetup
> .Zoom = False
> .FitToPagesTall = 1
> .FitToPagesWide = 1
> End With
>
>
> I then tried printing my sheet, but I saw no difference at all. I just to
> eliminate all margins to zero, and force excel to print my print area
> on one ENTIRE page.
>
> Got any more tips??
>
>
> "Rick Rothstein" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Look up the FitToPagesWide and FitToPagesTall properties in the help
>> files... they are properties of the PageSetup object.
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>

Not always.

Sometimes, the limiting factor is the width. Sometimes, the limiting factor is
the height.

Very rarely do these occur at the same time. (Well, in my experience.)


Robert Crandal wrote:
>
> I think the problem is that I can't find a way to totally eliminate
> all the margins. I tried setting all margins to ZERO, yet
> I still cant seem to find a way to print my sheet to cover
> the entire page. Ugh, there must be a way??
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > If the data isn't enough to fill the page, you could experiment with Font
> > size
> > -- or even the scaling factor.
> >
> > In xl2003 menus:
> > File|Page setup|Page tab|Adjust to
> > and make it bigger than 100%
> >
> > But if your data doesn't match the same layout of the sheet, you'll find
> > that
> > you can fit the width nicely--or the length nicely--but not both at the
> > same
> > time.

--

Dave Peterson