| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print and shrink automatically so that worksheet fits on paper?
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print and shrink automatically so that worksheet fits on paper?
On Apr 15, 5:03*am, (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 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 File Page Setup Page Tab Scaling Fit to 1 x 1 page (can be modified). HTH, Reeza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing spreadsheet print area to 1 page fails to shrink image en | Excel Worksheet Functions | |||
| How can I automatically print a worksheet on same day each month | Excel Discussion (Misc queries) | |||
| How can I print a chart worksheet on legal size paper? | Charts and Charting in Excel | |||
| Movng Data Automatically the Fits a provision | Excel Worksheet Functions | |||
| How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
Linear Mode
