Printing 2 ranges at one time

B

BEV

Is there a way to select 2 print ranges on a wide worksheet and print the sheet as two pages at one time? Currently, I set the print range and print one half the sheet then set again to print the other half. Is there an easier way

Thanks.
 
D

Dave Peterson

If you select two different ranges, there's an option under File|Print that says
to print th selection.

If you choose this, excel will print on at least 2 sheets of paper.

Maybe file|print|page tab and "fit to" would help.

(and use print preview to stop killing too many trees until you're satisfied.)
 
Top