Make a worksheet fit the printed page

If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page.

How

  1. Click the View tab on the ribbon and then click Page Layout.

    Page Layout on the ribbon

    Tip: Alternately, click Page Layout on the status bar.

    Page Layout button in status bar
  2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.

    Scale to Fit group on Page Layout tab

    To print your worksheet on just one page, in the Height box, select 1 page. That said, if you do this, however, the resulting printout may be hard to read, because Excel shrinks the data to fit. To see how much scaling is used, look at the number in the Scale box. If it's a low number, you may need to make other adjustments before you print. For example, you may need to change the page orientation from portrait to landscape or target a larger paper size. For more information, see the tips below.

  3. To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Tips: 

  • Once you finish working in Page Layout, you can go back to Normal view. To do that, click View > Normal.

  • To preview the worksheet before printing, press CTRL+F2.

  • If your worksheet has a lot of columns, you may need to switch the page orientation from portrait to landscape. To do this, go to Page Layout > Page Setup > Orientation, and click Landscape.

  • Consider using a larger paper size to accommodate a lot of printed columns. To switch the default paper size, go to Page Layout > Page Setup > Size, and then choose the size you want.

  • Use the Print Area command (Page Setup group) to exclude any columns or rows that don't need to be printed. For example, if you want to print columns A through F, but not columns G through Z, set the print area to include only columns A through F.

  • Page Layout view isn't compatible with the Freeze Panes command. If you don't want to unfreeze the rows or columns in your worksheet, you can skip Page Layout view and instead use the Fit to options on the Page tab in the Page Setup dialog box. To do that, go to Page Layout tab, and in the Page Setup group, click the Dialog Box Launcher Button image at the bottom-right side. Alternatively, press ALT+P, S, P.

See Also

Quick start: Print a worksheet

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×