Excel print range output issue

[Scott4517]

Is there a way to get my selected print ranges to print one after the other with each range stating in column "A" below the preceding range.

For example Range 1 is B2:F15 and range 2 is G2: L15 RANGE 3 IS N2:Z15 i want the output to appear on my sheet in this order.

B2:F15
G2: L15
N2:Z15

I want to use 11x17 paper landscape orientation and 11pt times new roman.

If anyone can advise I would greatly appreciate it,

 

[pgc01]

Hi

Set the page area equal to

B2:F15;G2: L15;N2:Z15

In this case the first 2 areas are contiguous and excel may merge them. To avoid that set a page break in G2.