Hi All,

I consistently have trouble with Excel's print feature. This is the most
recent example.

I'm working on a spreadsheet with many columns so I have set page breaks
from left to right. At the time I did this, one page from top to bottom was
sufficient. Since then rows have been added so that the lack of a row page
break results in 47% scaling. When I added a row page break the 47% scaling
remained. I instead tried to change autoscale to fit 2 tall, leaving wide
blank, but that overwrote all my page breaks.

Is there a trick to removing the scaling without destroying the page breaks?
I just want it to autoscale to fit the pages I've created. This is the one
area where I still miss Lotus after 15 years. Any tips would be appreciated.
Thanks.

Erin

Forgot to mention I'm using Excel 2003.

"Erin Searfoss" wrote:

Hi All,

I consistently have trouble with Excel's print feature. This is the most
recent example.

I'm working on a spreadsheet with many columns so I have set page breaks
from left to right. At the time I did this, one page from top to bottom was
sufficient. Since then rows have been added so that the lack of a row page
break results in 47% scaling. When I added a row page break the 47% scaling
remained. I instead tried to change autoscale to fit 2 tall, leaving wide
blank, but that overwrote all my page breaks.

Is there a trick to removing the scaling without destroying the page breaks?
I just want it to autoscale to fit the pages I've created. This is the one
area where I still miss Lotus after 15 years. Any tips would be appreciated.
Thanks.

Erin