Excel: Selecting discontiguous rows for PrintArea causes few rows printed per page

[Isorfir]

Okay, I don't know if the title made any sense, but here's what I'm doing.

Say I have the following ranges selected as my print area: A1:F4, A10:F13, A20:F21

When I print, it prints each area to its own page, is there any way I can have it fill up a single page (until there isn't room left) with my print areas?

[westconn1]

2 possible ways come to mind
set a contiguous print area, but hide the rows between the ranges you want to print

or copy all the required ranges to a temporary worksheet, so again it would print a contiguous range

[Isorfir]

Thanks for replying westconn1.

In my example, I set a print area range of A1:F450. I then hide most of the rows in between, but leave say 10% not hidden. When I print, I get the 1st and 4th page with rows, and 2,3,5,6 are completely blank. It's as if it's printing the entire area, but hiding the rows, thus creating blank pages.

If, alternatively, I only select what’s left as my print area(s), I get my first problem described: 6 pages with an average of 2 or 3 rows on each.

Maybe there's a better way to go about this?

[westconn1]

Maybe there's a better way to go about this?

try the temp worksheet