Excel: Different Page Orientation on Different Pages

[WPCMS]

I know that in Word you set different pages to print in different page orientations for the same document.

Is that cabpable in Excel? I have a spreadsheet that has a page of data and the second page terms and conditions.

The data needs to be printed in Landscape format and the terms in portrait.

Any suggestions?

Thank you in advance.

 

[WPCMS]

Just to let you know I am using Excel XP.

 

[SkipVought]

Hi,

Are you referring to PAGES or SHEETS.

Pages - no

Sheets, yes.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[WPCMS]

Pages. We are trying to have the user click print and two pages come out from sheet one. One is the data page on landscape and the next one is the terms page on portrait.

 

[SkipVought]

Why in the world would you have a TABLE and some PROSE on the same sheet?

That is not best and accepted spreadsheet practice.

Put the PROSE on a separate sheet, and set the page to portrait.

Select the two sheets & print. You'll get the TABLE as landscape and the PROSE as portrait.

Easy, peasy!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[WPCMS]

I know I know, not practical but I am trying to appease a user. Just checking to see if it could be done. They want to print to PDF in the same document at the same time. She didn't want to save both sheets as separate PDFs then merge together.

 

[SkipVought]

They want to print to PDF in the same document at the same time.

You did NOT read my last post carefully!

This is ONE PRINT JOB: not TWO!!!

Select the two sheets & print. You'll get the TABLE as landscape and the PROSE as portrait.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

I know that in Word you set different pages to print in different page orientations for the same document.

You do this by using different Sections though.


Section 1 - portrait
Section 2 - landscape
Section 3 - portrait

You can not have different page orientation in the same Section. If you choose to change orientation (either way) "from this point forward", Word automatically inserts a Section break.

Thus also in Excel. As Skip states:

Pages: no
Sheets: yes

If both pages are on the same Sheet this can not be done. Or at least as far as that Texan hound-dog says.

What do I know? I sure ain't no Excel guy.

Gerry