Print and shrink automatically so that worksheet fits on paper?

C

Claudia d'Amato

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
 
B

Bernard Liengme

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
 
R

Reeza

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 anderror.

Is there a way to tell Excel 2003:

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

Claudia

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

HTH,
Reeza
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top