Printing - Fit Columns & Rows to page

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

Dave Peterson

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

BrianB

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
 
E

Eva Shanley

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top