Use full page

[Guest]

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.

 

[Frank Kabel]

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

 

[Guest]

Frank,

Brilliant sorted, many thanks.

Mark

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

 

[Joe]

Check "sheet" under "page setup".
If you have any "columns to repeat", delete them. You do not need them if
wanting to print one page wide. I believe Excel reserves room for those
columns, thereby not allowing your print to utilize the full page. Deleting
them frees up room on the sheet for the type to now fill the full width of
the page.