Landscape Portrait

[tim]

Good Afternoon,
I have a pricelist in an excel worksheet that I print out in portrait
,however I have to add new pages that I need to setup in landscape in the
same sheet is this possible please ??? and if so how is it done
many thanks Tim

 

[Shane Devenshire]

Hi,

I think the only way you can do this is with different print ranges. Which
means you can print one range in portrait, define a second range and set that
to Landscape and print it and so on.

 

[Dave Peterson]

Is there a reason why you don't put the second table on a second worksheet?

I'm gonna guess that if you wanted to print one portion portrait and one portion
landscape, then the data is not laid out the same way.

And even if the data is related, if it doesn't match layout, I'd put it on a
different worksheet.

It would make inserting or deleting rows and columns much easier (safer!).