Fit All Rows

Occasional Visitor

My worksheet is printing very small when I try to fit all rows on one page.  In addition, it's leaving about a quarter of the page blank.  I'm printing in landscape mode.

1 Reply


With your permission, if I may recommend, insert the file (without sensitive data).

Use this file to explain your problem and what you want to achieve.

Knowing the Excel version and the operating system would be of great advantage (for you) to get a concrete and quick solution proposal / approach.


In your case, it could range from the wrong printing area of the worksheet to the scaling of the worksheet.


However, it is probably the page setup in the print preview that is preset, but nobody really knows.

Here is a link with information on how to check / change the settings, if it is due to the page setting.

Scale the sheet size for printing


Hope I was able to help you with this info.


Thank you for your patience and understanding




I know I don't know anything (Socrates)