Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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.

Re: Excel Printing

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.

Re: Excel Printing

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.