How to Reduce a Worksheet Size in Excel 2007

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Reduce a Worksheet Size in Excel 2007
(Medioimages/Photodisc/Photodisc/Getty Images)

When working with data in a worksheet using the Microsoft Office Excel 2007 spreadsheet software, you can make sure that the size of the worksheet meets your preferences. For example, if you want to print a worksheet that is a little over one page you can reduce the size of the worksheet so that it fits on one printed page. You can also use the Scale feature at any time to reduce the size of your worksheet. Reducing the worksheet size will also help to reduce the saved file size.

Skill level:


  1. 1

    Open the Microsoft Excel 2007 file on your computer that contains the worksheet for which you want to reduce the size.

  2. 2

    Click the "Page Layout" button from the bottom of the application to switch to the Page Layout view.

  3. 3

    Select the "Page Layout" tab and then select the "1 page" option from the "Width" drop-down menu in the "Scale to Fit" group.

  4. 4

    Select the "Automatic" option from the "Height" drop-down menu.

  5. 5

    Click the "Scale" drop-down menu to select a smaller scale size if you want to reduce the worksheet size even more. Click "OK" to save your changes.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.