close

Hi!
When I print my Worksheet (a defined range) it prints correctly at work
(a single page) but at home it prints on (2) two pages. I'm told that it
is because the printers are different. This workbook will be sent to
several hundred dealers and they will be printing the sheet.
Is there a way to set it up so that no matter what the printer
application is, it will still print on (1) one page? (I can not make
the range any smaller)--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: www.excelforum.com/member.php...foamp;userid=3508
View this thread: www.excelforum.com/showthread...hreadid=499946
File/PageSetup/page/

In scaling change to fit to 1 page

Larry--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=499946Goto quot;Filequot; then quot;Page Setupquot;. Under quot;Scalingquot; select quot;Fit toquot; and put 1 in
the page ranges. This may still result in some distortion on certain
printers, but should keep everyone to 1 page.

HTH,
Elkar

quot;Brian Matlackquot; wrote:

gt;
gt; Hi!
gt; When I print my Worksheet (a defined range) it prints correctly at work
gt; (a single page) but at home it prints on (2) two pages. I'm told that it
gt; is because the printers are different. This workbook will be sent to
gt; several hundred dealers and they will be printing the sheet.
gt; Is there a way to set it up so that no matter what the printer
gt; application is, it will still print on (1) one page? (I can not make
gt; the range any smaller)
gt;
gt;
gt; --
gt; Brian Matlack
gt; ------------------------------------------------------------------------
gt; Brian Matlack's Profile: www.excelforum.com/member.php...foamp;userid=3508
gt; View this thread: www.excelforum.com/showthread...hreadid=499946
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()