Page layouts on one worksheet

[Richard]

Is it possible to create different page layouts on the
same worksheet. I am in the process of creating a number
of different tools on the same worksheet and I've
organized them to print on different pages by placing page
breaks to seperate each one. Most of the tools fit well
with the normal portrait layout and would like to leave
things in this format. However, one of my spreadsheets is
just too wide to fit in portrait. Is it possible to tell
Excel that this one spreadsheet should print in landscape
while everything else is portrait. I would like to do
this without having to change to a new worksheet. Any
help will be appreciated. Thanks -RA

 

[Frank Kabel]

Hi
one way:
- start recording a macro
- print the first part of your sheet
- change the page orientation
- print the next part

Now use this macro for printing