Different print orientation in one sheet

[kalwijro]

Hi there,

I want to print an Excel sheet. The first 3 pages has to be portrait. Then I want a landscape page, and after that I want to go back to portrait.
Does anybody know if it is possible (maybe even an other papersize)?

Thanks

 

[TonyJollans]

I'm not sure how you'ld expect to see the results. Does the landscape page want to show more columns, or the same columns fitting to the page, or some wider columns, or do you have explicit page breaks, or what?

I'm pretty sure you'll need to do separate prints but you could probably write a macro to do it.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[kalwijro]

Thanks,

Indeed the landscape part have some more columns to print.

I hoped I could define different print-ranges with different settings in one sheet.

Ok, I try the macro

Robert

 

[SkipVought]

Hi,

Excel is primarily a spreadsheet application. Sure you can do other things with it, but in some cases its like turning a screw with a butter knife -- possible? maybe, but not the tool I would pick.

So how would I use a butter knife on this panhead????

Trun on your macro recorder.

1st - View/Page Break Preview. Unless you've already put in hard page breaks, move the break just before the portrait to landscape boundary.

Print the pages up to that point.

Change the page layout from portrait to landscape.

Adjust the page breaks if necessary

Print the landscape sheet

Change the page layout from landscape to portrait.

Adjust the page breaks if necessary

Print the remaining pages.

Turn off the macro recorder and clean up your code.

ALTERNATIVELY...

Why not put the landscape portion on another sheet. In other words, put the data on 3 sheets. Format the page setup on the second sheet as landscape. Sleect sheets 1-3 and print.

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]