Excel Printing

Posted by Andrew on December 10, 2001 1:56 PM

Is there any way top print a multiple page worksheet in portrait for some pages and landscape for others, all within the same file and tab.

Posted by Juan Pablo G. on December 10, 2001 4:41 PM

No. You would have to use either various worksheets (For portraits and landscapes), or do this manually: First portraits, change Print Area, print Landscapes, etc. (or a macro to do that).

Juan Pablo G.

Posted by Hansoh on December 11, 2001 10:49 AM

if you get creative with VIEW-->CUSTOM VIEWS, i think you can get it pretty much done.

and i'm sure a 2 CUSTOM VIEWS plus 1 simple macro will get you there.

han