Scale a worksheet for printing

You can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.

What do you want to do?


Shrink or enlarge a worksheet for a better fit on printed pages

  1. Click anywhere in the worksheet that you want to print.
  2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup. The Page Setup dialog box appears.
  3. On the Page tab, under Scaling, click Adjust to, and then enter the percentage of the normal size that you want to use in the Adjust to box.

 Tip   To reduce a worksheet to fit the printed pages, enter a percentage that is smaller than 100%. To enlarge a worksheet to fit the printed pages, enter a percentage greater than 100%.

Top of Page Top of Page

Fit a worksheet to the paper width of printed pages

  1. Click anywhere in the worksheet that you want to print.
  2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup. The Page Setup dialog box appears.
  3. On the Page tab, under Scaling, click Fit to.
  4. In the first Fit to box, enter 1 to fit the worksheet to the width of one page.
  5. In the second Fit to box, delete the value so that the number of pages tall is unspecified.

 Notes 

  • Microsoft Office Excel ignores manual page breaks when you use the Fit to option.
  • When you change the values for Fit to, Excel shrinks the printed image or expands it up to 100 percent, as necessary. To see the how much the image will be adjusted for your new values, click OK to close the dialog box, and then reopen the dialog box (Page Layout tab, Page Setup group, Dialog Box Launcher Button image next to Page Setup). The Adjust to box on the Page tab shows the percentage that the printed size will be adjusted.
  • Printed data does not exceed the specified number of pages. Excel does not stretch the data to fill the pages.

Top of Page Top of Page

Print a worksheet on a specific number of pages

  1. Click anywhere in the worksheet that you want to print.
  2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup. The Page Setup dialog box appears.
  3. Under Scaling, click Fit to.
  4. To print a worksheet on a specific number of pages, in both Fit to boxes, enter the number of pages (wide and tall) on which you want to print the work.

 Notes 

  • Excel ignores manual page breaks when you use the Fit to option.
  • When you change the values for Fit to, Excel shrinks the printed image or expands it up to 100 percent, as necessary. To see the how much the image will be adjusted for your new values, click OK to close the dialog box, and then reopen the dialog box (Page Layout tab, Page Setup group, Dialog Box Launcher Button image next to Page Setup). The Adjust to box on the Page tab shows the percentage that the printed size will be adjusted.
  • Printed data does not exceed the specified number of pages. Excel does not stretch the data to fill the pages.

Top of Page Top of Page

 
 
Applies to:
Excel 2007