I have a worksheet which is predominantly portrait, but want to have one page
within the worksheet which is landscape. How can I do this?

Do you mean you have data on a worksheet and when you print that worksheet, you
want most the pages portrait, but one page landscape.

If yes, then I'd suggest that you actually move that landscape data to a
different worksheet. It'll make your life a bit easier.

But you could use file|page setup|change to portrait, print all the pages you
want that way, then use file|Page setup to change to landscape and print the
other page (and swap back to portrait and print the remaining pages???).

I would think that you could record a macro when you did this manually and just
rerun that macro when you need to print.

And I would bet it would work best if you inserted page breaks manually.

(I'd still use that second worksheet.)

FrustratedLK wrote:

I have a worksheet which is predominantly portrait, but want to have one page
within the worksheet which is landscape. How can I do this?

--

Dave Peterson

Thanks Dave, to the first question- yes. I have seen it before but cannot
figure out how to do it. I would put it in another worksheet except for the
fact that it is a form and I want to pdf it into one document!
Any ideas?

"Dave Peterson" wrote:

Do you mean you have data on a worksheet and when you print that worksheet, you
want most the pages portrait, but one page landscape.

If yes, then I'd suggest that you actually move that landscape data to a
different worksheet. It'll make your life a bit easier.

But you could use file|page setup|change to portrait, print all the pages you
want that way, then use file|Page setup to change to landscape and print the
other page (and swap back to portrait and print the remaining pages???).

I would think that you could record a macro when you did this manually and just
rerun that macro when you need to print.

And I would bet it would work best if you inserted page breaks manually.

(I'd still use that second worksheet.)

FrustratedLK wrote:

I have a worksheet which is predominantly portrait, but want to have one page
within the worksheet which is landscape. How can I do this?

--

Dave Peterson

I don't know enough about creating PDF files.

But aren't there ways of joining pdfs into one giant pdf?



FrustratedLK wrote:

Thanks Dave, to the first question- yes. I have seen it before but cannot
figure out how to do it. I would put it in another worksheet except for the
fact that it is a form and I want to pdf it into one document!
Any ideas?

"Dave Peterson" wrote:

Do you mean you have data on a worksheet and when you print that worksheet, you
want most the pages portrait, but one page landscape.

If yes, then I'd suggest that you actually move that landscape data to a
different worksheet. It'll make your life a bit easier.

But you could use file|page setup|change to portrait, print all the pages you
want that way, then use file|Page setup to change to landscape and print the
other page (and swap back to portrait and print the remaining pages???).

I would think that you could record a macro when you did this manually and just
rerun that macro when you need to print.

And I would bet it would work best if you inserted page breaks manually.

(I'd still use that second worksheet.)

FrustratedLK wrote:

I have a worksheet which is predominantly portrait, but want to have one page
within the worksheet which is landscape. How can I do this?

--

Dave Peterson


--

Dave Peterson