#1   Report Post  
Posted to microsoft.public.excel.misc
tim tim is offline
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing in Portrait & Landscape Peter D Excel Discussion (Misc queries) 1 August 21st 08 03:14 AM
Printing report that is portrait and landscape jag53 Excel Discussion (Misc queries) 1 February 2nd 08 04:11 AM
Landscape and Portrait Phippsy Setting up and Configuration of Excel 2 January 12th 06 03:21 PM
I would like page setup to always be in landscape not portrait Tom Excel Worksheet Functions 0 December 13th 05 12:27 AM
Page Setup - landscape and portrait MLRB Setting up and Configuration of Excel 3 October 29th 05 07:43 PM


All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"