I'm trying to scale a worksheet so that when it prints it fills the entire A4 page.

I have used under the print preview menu - page setup option the fit to 1 page with by 1 page tall option. This creates a blank space at the bottom of printed area.

Is there any way I can get Excel to stretch the vertically side of things so that it fills the entire page?

Any help will be very much appreciated.

Many thanks
John