"Fit to Page" Does Not Work 3

[RH610]

I have an Excel2000 sheet. I set a print range and set the page setup to fit to 1 pages wide and no pages long (legal size paper, landscape) and do a print preview. Instead of filling the page width it puts it all in tiny print in the upper left corner of the page as if it thinks the page is about 6 inches wide by 4 inches tall. I don't think it is the printer driver because it happens with different types of printers. It also happens if I actually print to a printer.

Thank You

 

[ilses]

What is the scale in Page Setup set to?
Try changing it back to 100%.

HTH

Ilse

 

[smah]

I saw something very similar recently with Excel 2000. In my case, changing the Windows printer setup (not excel) from landscape to portrait cured the problem.

 

[ladyck3]

Have you tried to set the fit to page, to 1 page wide and maybe 3 pages long? The reason I say this is that if you set the number of pages to zero, its going to squish it to fit all on that one page, and it does it to ratio.

Try narrowing all margins to like .5 and set header and footer to 0, however, if the data is very wide and you are asking it to fit to page, that might equate to like 33%, it takes the ratio and downsizes the entire thing by 33% not just the width.

Hope this helps...

LadyCK3
(aka Laurie)
<fancy Signature Here>
(Just waiting til I think of something catchy, but I wanted a signatue TOO)

 

[tav1035]

RH610,
You have to...
File->Page setup->Page tab->
Pick sheet layout and size
Margins tab->
Check Center on Page-> Horizontal & Verticle
before chossing Fit to One Page.

Now you might have to rescale it to 100%
then choose fit to one page 'wide & tall'.

A good trick is to go to View->Page Break Preview
and manually grab the solid blue line, drag it for your print area, and the dotted blue line for your verticle page separations. But only after choosing layout and sheet size.
tav

 

[RH610]

Thanks to all for your tips. I have tried them all with no luck. When it &quot;fits&quot; it to the one page wide, it still shrinks it down to about 25% size. It should actually be about 55% to fit on the page correctly. If I manually zoom it to 55%, it fits and then shrinks back if I try to fit it. I tried changing it to 100% and then back to &quot;fit&quot; with the same result.

 

[tav1035]

RH610,
Sounds like one of your cells way out to the right has some formatting issues.
ie. if one of your cells way out has a border anywhere around it or a textbox or a character pasted from html, etc.
Did you try this...
A good trick is to go to View->Page Break Preview
and manually grab the solid blue line, drag it in for your print area, and the dotted blue line for your horizontal and verticle page separations. But only after choosing layout and sheet size.
Everything that you don't want to print will be grayed out.
This is the manual way to set the number of pages beeing printed.
Now go play with page setup and choose fit to 1 by 1.

One other thing... Highlight all columns with data and double click between one of the columns in the gray area. This will auto fit your columns. If you have a coulmn with Spaces after the data, it could create a problem with the auto-fit.
tav

 

[tav1035]

ladyck3,
I have to give you a star here because your right on.
I retested this with a spreadsheet of data and using your theory of:
(QUOTE)&quot;Have you tried to set the fit to page, to 1 page wide and maybe 3 pages long? The reason I say this is that if you set the number of pages to zero, its going to squish it to fit all on that one page, and it does it to ratio.&quot;
It makes sense.
Thanks,
tav

 

[ladyck3]

Well thank you, Tav...

Thing is, I learned that the HARD WAY... I can't tell you how many agonizing moments were spent trying to figure that darn thing out and then BLINK the light blub went on and I thought myself rather silly (me not someone else, but me) for not realizing it.....

I'm glad I was able to help clear up the mystery.... lord knows it sure had me going for a long time!!



Thanks again for the star....

Laurie.


LadyCK3

 

[GeekGirlau]

I came across the same problem, but in a worksheet being formatted via VBA. The number of columns is dynamic, so setting a specific value doesn't work. However so far the following has been successful:

        ' page setup
    With ActiveSheet.PageSetup
        .PrintTitleRows = "$1:$2"
        .LeftMargin = Application.InchesToPoints(0.393700787401575)
        .RightMargin = Application.InchesToPoints(0.393700787401575)
        .TopMargin = Application.InchesToPoints(0.393700787401575)
        .BottomMargin = Application.InchesToPoints(0.748031496062992)
        .HeaderMargin = Application.InchesToPoints(0.393700787401575)
        .FooterMargin = Application.InchesToPoints(0.354330708661417)
        .PrintHeadings = False
        .CenterHorizontally = True
        .PrintGridlines = True
        .Orientation = xlLandscape
        .PaperSize = xlPaperA4
        .Zoom = False
        .FitToPagesWide = 2
        .FitToPagesTall = False
        .Order = xlOverThenDown
        .PrintTitleColumns = "$A:$A"
    End With
    
        ' sometimes "FitToPages" option causes weird result!
    If ActiveSheet.PageSetup.Zoom > 100 Then
        ActiveSheet.PageSetup.Zoom = 100
    
        With ActiveSheet.PageSetup
            .Zoom = False
            .FitToPagesWide = 2
            .FitToPagesTall = False
        End With
    End If