| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use full page
Hi
if your range has a different aspect ration then your paper it can't work. You could always try to set the page size ('File - Pagesetup'9 to 1 sheet high and wide -- Regards Frank Kabel Frankfurt, Germany Mark wrote: I am using Excel 97. Is there a way to programmatically ensure that the page setup uses the full page of an A4 sheet. I have set the print area to D3:S62 but despite altering the margins cannot get the whole sheet used. Any suggestions/solutions would be greatly apprecaited. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use full page
Frank,
Brilliant sorted, many thanks. Mark "Frank Kabel" wrote: Hi if your range has a different aspect ration then your paper it can't work. You could always try to set the page size ('File - Pagesetup'9 to 1 sheet high and wide -- Regards Frank Kabel Frankfurt, Germany Mark wrote: I am using Excel 97. Is there a way to programmatically ensure that the page setup uses the full page of an A4 sheet. I have set the print area to D3:S62 but despite altering the margins cannot get the whole sheet used. Any suggestions/solutions would be greatly apprecaited. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Full page formulas | Excel Discussion (Misc queries) | |||
| Need charts to print in full page | Charts and Charting in Excel | |||
| Rows not printing on full page | Excel Discussion (Misc queries) | |||
| COPING FULL PAGE PATTENS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| I want 20 rows in excel to take up full A4 page | Excel Worksheet Functions | |||
Hybrid Mode
