Forum Discussion

binishsam's avatar
binishsam
Copper Contributor
May 24, 2021

Print Area is Not Fitting My Page for Excel 2019

My print area is not fitting in one page. If I scale it to page, multiple lines are missing.

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    binishsam 

     

    By scaling your worksheet for printing, you can make your data fit to one page. You can shrink your Excel document to fit data on a designated number of pages using the Page Setup option in the Page Layout tab.
     
    1. Click Page Layout. ...
    2. Select the Page tab in the Page Setup dialog box.
    3. Select Fit to under Scaling.
    4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ...
    5. Press OK at the bottom of the Page Setup dialog box.

    Scale a worksheet

     If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page.

     

     

    Hope I was able to help you with this information

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

     

Resources