Excel print range output issue

Scott4517

New Member
Joined
Jan 20, 2017
Messages
2
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,
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,855
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,406
Members
409,871
Latest member
i1patrick
Top