Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.
 

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?

Answer: Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.
 

Yes, it is possible to mix landscape and portrait pages in one Excel 2007 worksheet. Here are the steps to achieve this:

1. Open the Excel worksheet and select the first 8 pages that need to be in portrait mode.
2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
3. Click on the "Orientation" button in the "Page Setup" group and select "Portrait".
4. Set the column widths for these pages as desired.
5. Next, select pages 9 and 10 that need to be in landscape mode.
6. Click on the "Page Layout" tab in the ribbon at the top of the screen.
7. Click on the "Orientation" button in the "Page Setup" group and select "Landscape".
8. Set the column widths for these pages as desired.
9. If you want to adjust the margins for any of the pages, click on the "Margins" button in the "Page Setup" group and select the desired margin settings.
10. Finally, if you want to preview how the pages will look when printed, click on the "Print Preview" button in the "Workbook Views" group on the "View" tab.

That's it! You should now have a worksheet with a mix of portrait and landscape pages with different column widths as needed.

Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.
 

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!
================================================== ===

"TonyR" wrote in message
...
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?

Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.
 

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 !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
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!
================================================== ===

"TonyR" wrote in message
...
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?

Mixing Landscape and Portrait pages in one Excel 2007 Workshee
 

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

"RagDyeR" wrote:

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 !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
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!
================================================== ===

"TonyR" wrote in message
...
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?

Mixing Landscape and Portrait pages in one Excel 2007 Worksheet.
 

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...
-----------------------------------------------------------------------
"TonyR" wrote in message
...
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?