How do I change one page to lanscape in an Excel worksheet?

G

Guest

We have a very large docuement and all but one page fits fine using portrait
but one page is just to big and needs to be landscape but I can't figure out
how to change that one page and leave the reset at portrait.

Thanks so much for your help
 
D

David McRitchie

Hi Dawn,
You can't, you will have to move the material to another
worksheet. You can print both at the same time.
 
G

Guest

What you can also do is select all 'Lanscape' types sequentially and then
start selecting 'Portrait' orientations (using control Key and Print Area).
Not that you will be able to print all the pages in different orientations
using one 'Print' click instead you can give two print commands - One for all
Landscapes say 1-5 and one for all Portraits say 6-10. Can't say if this can
again be sorted out using a macro!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page Orientation 1
Changing Page Orientation in Excel 2007 1
How do i change one page to landscape and the rest portrait? 2
How do I print in 'landscape' on A4 paper 1
How do I change the page from landscape to portrait? 1
how do i change the page setup of one of the slide in a presentati 1
large picture - keep page number in portrait, even though pic land 1
how do I change page layout in vba 1

Top