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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawn - 28 Jul 2006 15:44 GMT

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

Reply to this Message

David McRitchie - 30 Jul 2006 15:07 GMT

Hi Dawn,
You can't, you will have to move the material to another
worksheet. You can print both at the same time.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> 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

Reply to this Message

Amit Agg - 20 Aug 2006 04:39 GMT

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!

Reply to this Message