Software

Set a print area to keep Excel from printing what you don't want

When you need to prevent Excel from printing certain cells, you can define a print area that excludes them. Here are the steps you need to follow.

There are times when you don't want Excel to print everything on your worksheet. For example, your worksheet might include a lookup table or a named range that's used only in your formulas. Rather than having to select the cells you want to print or to hide cells each time you print the worksheet, you can define a print area that excludes those cells from printing. Follow these steps:

  1. Select the cells you want Excel to print on the active sheet.
  2. Go to File | Print Area | Set Print Area. (In Word 2007, click the Page Layout tab and then click the Print Area button in the Page Setup group. Select Set Print Area.)

Now when you print the active worksheet, only the area you selected will print. If you wish to print the entire sheet without clearing the Print Area, click the Ignore Print Areas check box in the Print dialog box:


Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks