ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Landscape Portrait (https://www.excelbanter.com/excel-discussion-misc-queries/224514-landscape-portrait.html)

tim

Landscape Portrait
 
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

Landscape Portrait
 
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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tim" wrote:

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



Dave Peterson

Landscape Portrait
 
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!).

tim wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com