XL producing bizarre page layouts

[Kevin]

I've been working on a 12-page worksheet for several days with Excel
2003, running XP, SP1.

This morning, when I attempted to print it, the 12 pages printed out as
three pages, with the pages printijng landscape orientation, but in
tiny size down the left margin. I saw that Page Setup was set to "Fit
to: 1 to 1," but the "Adjust to:" setting above--while unchecked--was
set to 10%, so I tried to set it to 100%.

I also experience the page allowing only the page width, about 7.5
inches, though it is printing in landscape. In other words, a wide
column that previously had fit on the page. I have margins set to .5
inches all around.

Anyone have any idea what is causing this, and what the solution is?

 

[Anne Troy]

This often occurs 'cause you've got "dirty" cells in unused columns. See:
http://www.officearticles.com/excel/clean_up_your_worksheet_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Kevin]

This often occurs 'cause you've got "dirty" cells in unused columns.
See:
http://www.officearticles.com/excel/clean_up_your_worksheet_in_microso
ft_excel.htm ************ Anne Troy
www.OfficeArticles.com

Thanks, but that didn't do it. It may be that I have cells with >255
characters in them. Could that be it? I thought it would just display
them as xxxxxx strings. This is truly bizarre.

 

[Anne Troy]

What happens in Page Break View, Kev? Also, have you tried completely
clearing your print area, and starting over with page setup?
************
Anne Troy
www.OfficeArticles.com

 

[Bill Sharpe]

What happens in Page Break View, Kev? Also, have you tried completely
clearing your print area, and starting over with page setup?
************
Anne Troy
www.OfficeArticles.com

I've had success with selecting what I consider the active area of the
worksheet, copying and pasting it to another worksheet, and then
deleting the original worksheet.

Bill

 

[Kevin]

What happens in Page Break View, Kev? Also, have you tried completely
clearing your print area, and starting over with page setup?
************ Anne Troy
www.OfficeArticles.com


orientation, >>> but in tiny size down the left margin. I saw that
Page Setup was >>> set to "Fit to: 1 to 1," but the "Adjust to:"
setting above--while >>> unchecked--was set to 10%, so I tried to set
it to 100%.

I cleared columns/rows outside my printing area, cleared and redefined
my print area, made sure Portrait was turned on.

In Page Setup, I tried turning on "Adjust to:" and changed it from 10%
to 100%. Print preview does not show the squashed thumbnails running
down the left-hand side of the screeen, but it seems to allow only
Portraint width, cutting off the last, right-most column.
Page Break View displays, showing the last column broken onto a
separate page. No matter how I narrow the rightmost column, I can't gt
it to fit on the same page with the other columns.

Trying another tack, I turned off "Adjust to," turned on "Fit to:" and
set it to 1 page wide. Print preview now shows everything in squashed
thumbnails.
Page break view shows all my columns, but fitted onto one page, so
apparently it's showing me the "thumbnail" view.

 

[Kevin]

I've had success with selecting what I consider the active area of
the worksheet, copying and pasting it to another worksheet, and then
deleting the original worksheet.

Thanks, Bill. That seems to have worked. I wish I knew what had made
Excel lose its mind on this, though.