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