Printing Problems

[Brian Matlack]

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)

[keithl816]

File/PageSetup/page/

In scaling change to fit to 1 page

Larry

[Elkar]

Goto "File" then "Page Setup". Under "Scaling" select "Fit to" 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

"Brian Matlack" wrote:

>
> 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: http://www.excelforum.com/member.php...fo&userid=3508
> View this thread: http://www.excelforum.com/showthread...hreadid=499946
>
>