4. Change the orientation to Landscape by selecting Page Layout, Orientation, Landscape.
5. Adjust the margins by selecting Page Layout, Margins, Custom Margins. On the Margins tab of the Page Setup dialog, set the top, left, and right margins at 0.25 inch. Adjust the bottom to 0.5 inch and the footer margin to 0.25 inch. Alternatively, use Print Preview and click the Show Margins icon in the lower right. You can now drag the margins to a new location.
6. On the Page Layout tab, open the Width dropdown in the Scale to Fit group. Choose 1 page. (This is much easier than using the Page Setup dialog, as discussed in the following alternate strategy.)
Results: The report will fit on one page wide and three pages tall.
Alternate Strategy: You can use the Page Layout dialog to indicate that the report should fit to one page wide by <blank> pages tall. On the Page Layout tab of the ribbon, click the dialog launcher in the lower-right corner of the Page Setup group. Choose the Page tab of the Page Setup dialog. Choose Fit To. Leave the first spin button at 1 Page(s) Wide. Using your mouse, highlight the 1 in the spin button for Tall. After the 1 is highlighted, press Delete to leave this entry completely blank. Before Excel 2007, you followed this rather convoluted process to create a setting equivalent to step 6 above.