Can I adjust print scaling for multiple print areas on the same sh

N. Sammons

Guest

Posts: n/a

18th Jun 2008

If I have one large print area on a sheet (say 50 X 50 cells ) and one small
print area (say 10 X 10) on the same sheet at the same time, when I go print
by fitting to 2 pages Excel sets the print scaling so that the 50X50 area
will fit on one page, and then applies that same scaling to the 10X10 area
(so that the second page/print area comes out unecessarily small). Is there
a way to tell excel that I want it fit the two areas to two pages, but scale
each page individually?

« Converting worksheet to PDF format | VBA macro creating pdf »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I print multiple print areas on one page	Leo18	Microsoft Excel Misc	1	11th Jan 2010 07:28 PM
printing multiple print areas with a print dialog box	=?Utf-8?B?TEhhcm8=?=	Microsoft Excel Programming	0	17th Aug 2005 09:56 PM
Multiple print areas, one worksheet -need to print to PDF!	mohagany19	Microsoft Excel Programming	0	6th Oct 2004 11:54 PM
Code modification to accomodate scaling and print areas.	=?Utf-8?B?UGhpbCBIYWdlbWFu?=	Microsoft Excel Programming	4	26th Feb 2004 02:06 PM
Multiple print areas	Dave	Microsoft Excel Misc	1	8th Aug 2003 02:30 PM