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;

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

software

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