Excel > Excel 2007 Foundation > Printing a Worksheet

Adjusting size and scale

Excel worksheets can become very large. It is possible to select a different paper size in Excel to accommodate your spreadsheet. You can also adjust the scale of the printed worksheet so that it stretches or shrinks to your specifications.

Adjusting the paper size

  1. Click the Page Layout tab on the Ribbon
  2. Click the Size button in the Page Setup group
  3. Selecting a page size
  4. Select the paper size you want to use from the list
  5. The layout of the worksheet will adjust to the new page size settings.

Scaling to fit

You can specify how many pages wide and tall you want the data to fit to when printed, or enter a percentage for the data to scale to.

  1. Click the Page Layout tab on the Ribbon
  2. There are 3 options to choose from in the Scale to Fit group

  • Width: Select the maximum width in number of pages for your printout
  • Height: Select the maximum height in number of pages for your printout
  • Scale: Use the arrow buttons or enter a percentage to stretch or shrink the printout to a percentage of its actual size

    Scale options on the ribbon

  1. Adjust the scale as required using the relevant scaling command
  2. The worksheet is scaled to fit the new settings.

It is recommended to check Print Preview after making such changes to see the printout on screen prior to printing.

Scaling to fit from Print Preview

You can also adjust the scale of a printed worksheet from the Print Preview screen.

  1. From the Print Preview screen click the Page Setup button from the Print group on the Ribbon
  2. The Page Setup dialogue box opens
  3. In the Scaling panel of the Page tab are the 3 scaling options. Adjust as necessary

    Scaling in page setup

    In the example above, scale to fit options had already been set. By opening Page Setup I can see what percentage Excel had scaled the worksheet to after setting it to 1 page wide and 2 pages tall.

  4. Click Ok
  5. The worksheet is scaled to fit the new settings.

Follow us on

Facebook  Twitter  You Tube