Printing - Fit Columns & Rows to page

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
E

Eva Shanley

I have a file with a range A1:AG125; columns
D,E,J,K,P,Q,V,W are hidden. This file was converted from
Lotus 123, and the user was supposedly able to fit all the
columns and rows to print on 1 page. I'm trying to print
this on Legal, Landscape, Fit 1 Wide by 1 Tall; if I leave
the "1 Tall" blank, all the columns fit to fill across the
entire page as they should, but I end up with multiple
pages. If I include "1 Tall" all the rows fit, but the
columns crunch together and leave a very wide right
margin. I've tried moving page breaks (there's a manual
page break on column AG that somebody put in) back and
forth and everything else I can think of. Unhiding or
hiding columns doesn't seem to have any effect. Any ideas?
 
That sounds like a lot of data to squeeze into one sheet. Maybe to make the
number of rows fit, xl really has to squish the font--hence the wide margin.

But I recall that some versions of excel (xl97????) seemed to remember the
"adjust to" percentage.

Try making that 100% (or 120%) and then come back and try the "fit to" stuff.

And make sure your margins aren't really screwed up. Maybe it's that simple???

(But it sure sounds like that's what fits on the paper.)
 
You don't mention if you have used Fit To Page 1 wide *and * 1 tall an
changed column widths in Print Preview to fit
 
Dave,
Thanks for the reply; I agree that's a lot of data to
print on one sheet. I did find out from MS Knowledge Base
that if you fit 1 wide by 1 tall, the columns do not
adjust to fill the page; you need to widen then manually
which does work. However, the print is so small nobody
can read it regardless of any change in font size. The
users will just have to accept 2 printed pages instead of
1. Thanks again.
 
Back
Top