Printing EXCEL

[macHarry]

HELP:

I am new to excel. I use Mac Panther. I have created a worksheet that
will only print out in small version. I have tried going to page setup
and checking set to, etc. but nothing seems to work. the page prints
out about 25% of the size I need. I also check in the formatting
palette "fit to one page" and it still prints out smaller than I need.
Thanks.

 

[J Laroche]

macHarry wrote on 2005/05/03 18:04:

HELP:

I am new to excel. I use Mac Panther. I have created a worksheet that
will only print out in small version. I have tried going to page setup
and checking set to, etc. but nothing seems to work. the page prints
out about 25% of the size I need. I also check in the formatting
palette "fit to one page" and it still prints out smaller than I need.
Thanks.

First you have to know that "fit to one page" never enlarges a page above
100%, all it can do is shrink it if it wouldn't fit. You can also leave
either the "wide" or "tall" boxes empty to let Excel use as many pages as
necessary in that direction, to limit expansion in only the other direction.

Sometimes empty cells that used to contain values or formats are considered
by Excel as part of the print area. Select a dozen columns (by clicking and
dragging in the column letters) on the right of your rightmost data and do
Edit/Delete. You may want to do the same with some rows below your data.
Now, does it print better?

In the Page Setup/Sheet, do you have a print area defined? You can most of
the time leave it empty, Excel will chose it automatically.

JL
Mac OS X 10.3.9, Office v.X 10.1.6

 

[CyberTaz]

Hi macHarry-

Don't know if this was just omitted from your post or whether it may be
important...

I have tried going to page setup and checking set to, etc.

-->Did you also increase the 'Adjust to' value to something larger than
100%? Also, don't use _both_ 'Adjust to' & 'Fit to'.

Good Luck |:>)



On 5/3/05 6:04 PM, in article
(e-mail address removed), "macHarry" wrote:

-- (e-mail address removed)