Print in portrait and landscape from same workbook

[excelneophyte]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have two sheets in my workbook. One needs to be printed in a portrait style, the other in a landscape. I want to put them on the same piece of paper. My printer HP Laserjet M5035 MFP (big unit here at my company) prints double sided just fine. But I can't find a way to get excel to let me change the page setup on one sheet without it affecting the 2nd sheet. Is there a way of locking it? or maybe even rotating one of the documents to 'trick' it?

 

[CyberTaz]

Well, there may be "a way" but not as a standard feature of the program to
mix orientation in a single job. If it's just a 2 page job it would be
easiest to print the Portrait then print the Landscape on the other side as
a separate job.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[excelneophyte]

Thanks for taking the time to respond!

It is just a two page job, however I'll be making hundreds of copies with unique information entered into each sheet every time I go to print.

Thanks again,
Ross

 

[CyberTaz]

Then it might be worth considering to have the sets run off at a local copy
center if you don't have a duplex copier in-house.

Regards |:>)
Bob Jones
[MVP] Office:Mac