Arggh! Each row prints on separate page

[Mitch Powell]

I have a single worksheet with enough rows that would normally span two
printed pages. The problem is that all rows that would normally fit on the
first page do so just fine but then each row that would normally fall on the
second page prints as a separate page. When I look at the worksheet in Page
Break Preview mode, I see each row after Page 1 as a separate page. Even
more bizarre is when I actually Print Preview, moving from Page 1 to Page 2
just adds a row to the bottom of the Page 1 preview, scrolling to Page 3 adds
another and so on until there is no more room on Page one and then I see no
change in the preview as I scroll further.

I'm really stumped on this on...

 

[MS-Exl-Learner]

In pagebreak preview Just extend the blue lines upto the range to which you
want to print in first page. Like that set it for other pages.

 

[Mitch Powell]

Shoudln't have to do that manually. Excel is automatically adding a soft
page break at each row when it shouldn't. Excel should let the 15 or so
lines that won't fit on the first page flow onto a single second page
automatically like it always does in every other situation I have encounted
in 15 years of using Excel. Why it wants to create a spearate page for every
single one of the overflow rows in this case is beyond me.