How to set print area in excel 2007

Written by amanda delgado
  • Share
  • Tweet
  • Share
  • Email

You don’t have to waste paper on an entire Microsoft Excel 2007 worksheet when you only need certain parts of it printed. Microsoft’s spreadsheet program allows you to set a specific print area, which you can save if you plan to print out the same spreadsheet cells on a regular basis. You can change the print area at any time or clear it if you need to print the whole worksheet. Earlier versions of Excel require sorting through menus and toolbars to find the right commands. Excel 2007’s Page Layout tab, which you’ll find above the ribbon in Excel 2007, provides a straightforward way to perform these functions.

Skill level:


  1. 1

    Open the Excel 2007 worksheet in which you want to define a print area.

  2. 2

    Click a cell and drag the cursor over the rest of the cells you want to print to select them.

  3. 3

    Go to the Page Setup group located on the Page Layout tab, and click "Print Area." Click "Set Print Area" to define the selected cells as the area of the spreadsheet you want to print.

Tips and warnings

  • To add cells to your saved print area, select the additional cells you want to print. Click "Print Area" in the Page Setup group, and then choose "Add to Print Area."
  • If you need to clear the print area, click any cell within the print area. Go to the Page Setup group, and click "Clear Print Area."

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.