multiple page layout in worksheet

[Dowjd]

I have twelve monthly worksheets in a workbook. In each worksheet, page 1 layout is portrait and page 2 layout is landscape. I need both to print our in their correct layouts. Any suggestions?

Thanks

[martindwilson]

just set the correct layout individually for each sheet in print preview, then select all sheets and print

[Dowjd]

If I make changes to either page, it changes the orientation to the other. When I look at them in print preview it reduces them to 53% to fit each portrait page. It will not maintain page 1 as portrait and page 2 as landscape.

[martindwilson]

well i just tried it with 6 sheets
set print areas on each then went to each sheet individually and alternately set portrait/landscape
then in print preview look at each sheet they change from portrait to landscape . If it's changing the size it's because you have set adjust to x% of normal size in page setup.
see attached
right click a tab /select all sheets
then file /print preview. then click next to see each sheet

[Dowjd]

Hey Martin,

Thanks for the reply. Sorry but I don't think I really described what I am looking for. I attached an example in my original post (I should have done anyway).

Your example has a workbook with multiple worksheets, each with its own page formatting.

I need each worksheet to have two different page layouts (if possible). Page 1 in portrait and page 2 in landscape. See example above.

Unfortunately, I have to have it setup like this. Its an inter-office template that must be non confusing for my PC illiterate co-workers. :-)

[Dowjd]

I gave up. Chose to create two worksheets. Co-workers will have to deal with it.