Click the Page tab in the Page Setup dialog box. Under Scaling, select Fit to. In the Fit to Boxes, select 1 page(s) wide by 1 tall to fit your document on one page. Note: Excel will shrink your data to fit on the number of pages specified.