Microsoft Excel: How to Make a Wide Report Fit to One Page Wide by Many Pages Tall
written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011
Problem: After creating a wide report, it is printing four pages wide. You want to make it fit one page wide.
slide 1 of 2
Strategy: Ultimately, you will set the Page Setup to print to one page wide by pages tall. Before you can do that, you should follow these steps.
1) Eliminate extra columns from the print range. This worksheet has some lookup tables beyond column X that you do not want to print. Highlight columns A through X and select File – Print Area – Set Print Area.
2) Make the columns narrower. Select the data in A6:X130. From the menu, select Format – Column – AutoFit Selection.
3) Look for headings that could be on two lines. Sales Rep in cell D5 is an example of a heading that could be on two lines to save width in the column. Prior Year in X5 has already been split into two lines. (See Cross Reference.)
4) Change the orientation to Landscape. From File – Page Setup, go to the Page tab and select Landscape in the orientation section.
5) Adjust the margins. On the Margins tab of the File – Page Setup dialog, set the left and right margins at 0.25". Adjust the top and bottom to 0.5" and the footer margin to 0.25".
6) Finally, go to File – Page Setup. On the Page tab, choose the radio button for Fit to. Leave the second spin button at 1 Page(s) Wide. Using your mouse, highlight the 1 in the spin button for Tall. After the 1 is highlighted, hit the Delete key on the keyboard in order to leave this entry completely blank.
Result: The report will fit on one page wide and three pages tall.
Summary: The secret to having the report constrained to one page wide and any number of pages tall is to use the Page Setup dialog and leave the entry for pages tall completely blank.