Printing Excel Sheet To Fit Page - In the scale to fit group, in the width box, select 1 page, and in the height box, select automatic. Web on the page layout tab, select page setup. Secondly, from the page layout ribbon >>. Web shrink a worksheet to fit on one page. In the page setup dialog box, select the page tab. Go to page layout > dialog box launcher on the bottom right. This will open the print preview screen. Columns will now appear on one page, but the rows may. Click on the print option. Web below are the steps to fit data on one page while printing:
Secondly, from the page layout ribbon >>. Columns will now appear on one page, but the rows may. On the page tab, select the fit to check box. Web on the page layout tab, select page setup. Click the page layout tab on the ribbon. In the scale to fit group, in the width box, select 1 page, and in the height box, select automatic. In the page setup dialog box, select the page tab. Go to page layout > dialog box launcher on the bottom right. Click on the print option. Web below are the steps to fit data on one page while printing: This will open the print preview screen. The steps are given below. To fit your document to print on one. Web shrink a worksheet to fit on one page. Firstly, you have to open your worksheet. In the tall box, enter 0 so that the number of pages tall is unspecified.