Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.

[Guest]

I have a worksheet where the first 8 pages need to be in Portrait mode, all
with a consistent set of column widths.

Pages 9 and 10 need to be in Landscape, with different sets of column widths
(different from each other and different from the first 8 pages).

Is this possible and, if so, how?

 

[RagDyeR]

2 print sessions.

Print the first 8, change settings, then the last 2.

If you're numbering the pages, you can set the start page number for the
second session to "8" by:

<File> <PageSetup> <Page> tab,
And at the bottom, change the "First Page Number" from the default "Auto" to
"8".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a worksheet where the first 8 pages need to be in Portrait mode, all
with a consistent set of column widths.

Pages 9 and 10 need to be in Landscape, with different sets of column widths
(different from each other and different from the first 8 pages).

Is this possible and, if so, how?

 

[RagDyeR]

Of course, that second session page number should be set to "9"!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

2 print sessions.

Print the first 8, change settings, then the last 2.

If you're numbering the pages, you can set the start page number for the
second session to "8" by:

<File> <PageSetup> <Page> tab,
And at the bottom, change the "First Page Number" from the default "Auto" to
"8".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a worksheet where the first 8 pages need to be in Portrait mode, all
with a consistent set of column widths.

Pages 9 and 10 need to be in Landscape, with different sets of column widths
(different from each other and different from the first 8 pages).

Is this possible and, if so, how?

 

[Guest]

If that's the only way, I guess it will have to do. I remember being able
to do this in 1-2-3 many moons ago and hoped it might be possible in Excel

Thanks for the help

Tony

 

[Earl Kiosterud]

Tony,

It's a little odd that you want a different layout for data that's in the same sheet. It's
likely that you have stuff (the stuff that prints on pages 9 and 10) that should be in a
separate sheet. Often folks put stuff in separate sheets where it should be in one. I've
written about this many times, and it's in "Data across Multiple Sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. But in your case, you may have put stuff
into one sheet that should be in separate sheets. If you put the data in separate sheets,
you can set the second sheet to Landscape (File - Page setup), then print both sheets as a
single job (either select both sheets, or print the entire workbook). The page numbering
and everything should work out pretty much the same, print-wise.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...