Fit Excel Sheet To One Page. Web to print the worksheet on a single page, use the scale to fit feature in excel. Go to page layout > dialog box launcher on the bottom right.
How to Fit to Page in Excel (Print on One Sheet)
In the page setup dialog box, select the page tab. In the ribbon, go to page layout > scale to fit. Web shrink a worksheet to fit on one page. Click the width box and from the drop down, choose 1 page. In the scale to fit group, in the width box, select 1 page, and in the height box, select automatic. Click on the print option. This will open the print preview screen. Web below are the steps to fit data on one page while printing: Go to page layout > dialog box launcher on the bottom right. Columns will now appear on one page, but the rows.
In the page setup dialog box, select the page tab. Click on the print option. Web shrink a worksheet to fit on one page. Web below are the steps to scale down the sheet while printing: This will open the print preview screen. Web to print the worksheet on a single page, use the scale to fit feature in excel. In the page setup dialog box, select the page tab. Columns will now appear on one page, but the rows. In the ribbon, go to page layout > scale to fit. Go to page layout > dialog box launcher on the bottom right. Click the width box and from the drop down, choose 1 page.