Print and shrink automatically so that worksheet fits on paper?

I have occasionally worksheets which are larger than a paper page.

In order to be able to print all content on ONE paper page I have to scale the size down to e.g.68%
Finding the exact scale value needs some user unfriendly fiddling try and error.

Is there a way to tell Excel 2003: 

"Hey Excel, scale down the size of the worksheet AUTOMATICALLY so it fits on the paper"?

Claudia

0
clauama
4/15/2010 12:03:25 PM
excel.misc 78881 articles. 4 followers. Follow

2 Replies
1242 Views

Similar Articles

[PageSpeed] 22

The print dialog has a area where would can specify: fit to N pages wide and 
M pages long
This is below the place you you are currently setting the % reduction
best wishes
-- 
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Claudia d'Amato" <clauama@wonderworld.com> wrote in message 
news:4bc7008c$0$6763$9b4e6d93@newsspool3.arcor-online.net...
> I have occasionally worksheets which are larger than a paper page.
>
> In order to be able to print all content on ONE paper page I have to scale 
> the size down to e.g.68%
> Finding the exact scale value needs some user unfriendly fiddling try and 
> error.
>
> Is there a way to tell Excel 2003:
>
> "Hey Excel, scale down the size of the worksheet AUTOMATICALLY so it fits 
> on the paper"?
>
> Claudia
> 
0
Bernard
4/15/2010 12:39:33 PM
On Apr 15, 5:03=A0am, clau...@wonderworld.com (Claudia d'Amato) wrote:
> I have occasionally worksheets which are larger than a paper page.
>
> In order to be able to print all content on ONE paper page I have to scal=
e the size down to e.g.68%
> Finding the exact scale value needs some user unfriendly fiddling try and=
 error.
>
> Is there a way to tell Excel 2003:
>
> "Hey Excel, scale down the size of the worksheet AUTOMATICALLY so it fits=
 on the paper"?
>
> Claudia

File > Page Setup > Page Tab> Scaling > Fit to 1 x 1 page (can be
modified).

HTH,
Reeza
0
Reeza
4/15/2010 3:57:25 PM
Reply:

Similar Artilces: