Can "print area" cover entire page???

[Robert Crandal]

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!

 

[Rick Rothstein]

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

 

[Dave Peterson]

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]

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

 

[Robert Crandal]

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]

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)

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

 

[Dave Peterson]

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.)