Adjusting Printout Scale

Worksheets can get very big, very fast. Often you want to still print an entire worksheet in a single sheet of paper. The ribbon tools make it easy to set the scaling. Display the Page Layout tab of the ribbon, and make your scaling adjustments using the settings in the Scale to Fit group. Using the Width and Height controls you can specify how many pages wide or high the printout should occupy. Changing these controls adjusts the value in the Scale control automatically, or you can explicitly use the Scale control to specify the percentage you want used when printing.

If you prefer, you can also set scaling the old-fashioned way by displaying the Page Setup dialog box and using the controls on the Page tab.

One of the tricks I often use is to set the Fit To settings to 1 page wide by 99 pages tall. In this way, I am sure the output will fit on one page across. Since my output isn't over 99 pages in length, no shrinking is done on this dimension. I end up with output that is 1 page wide by how ever many pages long Excel needs to print.