up vote 0 down vote favorite
share [g+] share [fb]

I have a multi sheet excel spread sheet.

some pages are setup portrait others are setup landscape.

is there a way to define which pages should print which way or is it an all one way or the other type of thing?

link|improve this question
59% accept rate
feedback

1 Answer

up vote 2 down vote

With the Page Setup option you can determine orientation for each work sheet separately.

It will print the worksheets accordingly.

link|improve this answer
for each worksheet, select the range you need to print and set that as the print area for that sheet (in pre-2007 versions this is easier the other way round, now I come to think of it; Page Setup > Print area, use the range selection icon or just type in the box), set the orientation here too. Unfortunately no way to do this for multiple sheets at once (grouping does not do it), but if you plan ahead and set up one sheet correctly, then copying that sheet will keep the properties the same – AdamV Nov 9 '09 at 20:06
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.