Choose the Page tab of the Page Setup dialog. On the Page Layout tab of the ribbon, click the dialog launcher in the lower-right corner of the Page Setup group.

Results: The report will fit on one page wide and three pages tall.Īlternate Strategy: You can use the Page Layout dialog to indicate that the report should fit to one page wide by pages tall. (This is much easier than using the Page Setup dialog, as discussed in the following alternate strategy.) On the Page Layout tab, open the Width dropdown in the Scale to Fit group.You can now drag the margins to a new location. Alternatively, use Print Preview and click the Show Margins icon in the lower right. Adjust the bottom to 0.5 inch and the footer margin to 0.25 inch. On the Margins tab of the Page Setup dialog, set the top, left, and right margins at 0.25 inch. Adjust the margins by selecting Page Layout, Margins, Custom Margins.

Change the orientation to Landscape by selecting Page Layout, Orientation, Landscape.

You therefore have to manually adjust the column width of columns D and X. Gotcha: The AutoFit command does not deal well with cells in which Alt+Enter was used, as in step 2. Select the data in A5:X130 and then select Home, Format, AutoFit Column Width. In cell C5, type Sales, press Alt+Enter, and type Rep. For example, Sales Rep in cell D5 could be on two lines to save width in the column.

Set long headings on two lines rather than one.

Because this worksheet has some lookup tables beyond column X that you do not want to print, highlight columns A through X and select Page Layout, Print Area, Set Print Area.

Eliminate extra columns from the print range.

Before you can do that, you should follow these steps: Strategy: Ultimately, you will set the Scale to Fit settings to print to one page wide by any number of pages tall.

Taping four pages together leads to copier jams.

Problem: After I create a wide report, it prints four pages wide.

Excel set print area to one page