|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 13th, 2008, 08:45 AM
|
|||
|
|||
|
Excel
Hi All
I need to know if it is possible to have two different page set ups in the same document. For eg Sheet 1 has a document that is six pages long when printed I need pages 4 - 6 printed in portfolio and pages 1 - 3 printed in landscape. Is there a way to do this if so how? Thanks Jodie 
|
|
#2
June 3rd, 2008, 10:18 AM
|
|||
|
|||
|
You can surely do it manually. However, have you tried to do this by yourself?
Like selecting first 1-3 pages then selecting 'Page Setup' and choosing landscape, etc. Then save the document, then re-open it and check to see if the settings have remained, if so, they will be printed as the same too.
|
|
#3
June 10th, 2008, 02:11 AM
|
||||
|
||||
|
As far as I'm aware, you cannot set multiple print areas on a single worksheet. This means that you'll be stuck with the same layout throughout the entire sheet.
What I would recommend is creating a print macro that will automate the manual process that was described above. This would allow you to change the page setup before printing each range of pages.
__________________
Scripting problems? Windows questions? Ask the Windows Guru! Stay up to date with all of my latest content. Follow me on Twitter! Help us help you! Post your exact error message with these easy tips!
|
|
| Viewing: ASP Free Forums > Other > Programming Help > Excel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
