Printing in different ways within one worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Thomson - 11 Sep 2003 12:22 GMT

I currently have a sizeable report which runs on to a few
pages when printed. I would like to have one of these
pages print portriate and the others landscape.

Is there a way in ecxel to have these automatically print
in the desired format without having to go in each time
and change them to print the desired page.

Any help much appreciated.

Thanks

Brian

Reply to this Message

Paul Cundle - 11 Sep 2003 13:43 GMT

Can you not just put the landscape page onto a separate worksheet? Different
sheets within a workbook can have different page orientations, but different
pages within a sheet can't.

You could record a macro that sets portrait/landscape before it prints each
page or range of pages, which is easily enough done using the macro
recorder. I can't imagine a scenario where it wouldn't be easier to use
separate worksheets, though.

Paul C,

Signature

> I currently have a sizeable report which runs on to a few
> pages when printed. I would like to have one of these
[quoted text clipped - 9 lines]
>
> Brian

Reply to this Message

Brian Thomson - 11 Sep 2003 15:24 GMT

Thanks for your idea, but in this situation it really isnt
practical to have them on seperate worksheets. The Macro
sounds like the best option here.

Thanks for your help.

Brian

>-----Original Message-----
>Can you not just put the landscape page onto a separate worksheet? Different
[quoted text clipped - 22 lines]
>
>.

Reply to this Message