Forum Discussion

ltatum32's avatar
ltatum32
Copper Contributor
Nov 18, 2021

Fit All Rows

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

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    ltatum32 

    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

     

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources