Getting Rid of the Print Area

If you want to print a specific set of data within a worksheet, you set a print area to define what you want printed. The print area is used to define exactly what range you want printed. At some point you may need to delete the print area. (By "delete" I mean to get rid of the special area designation, not the information contained within that area.)

To clear the print area, follow these steps:

1. Display the Page Setup tab of the Ribbon.
2. In the Page Setup group, click Print Area. Excel displays a menu containing two choices.
3. Choose Clear Print Area from the menu.

Pretty easy, huh? Well, there are other ways you can go about clearing the print area, as well. This is one that I like to use from time to time:

1. Make sure the Formulas tab of the Ribbon is displayed.
2. In the Defined Names group, click Name Manager. Excel displays the Name Manager. (Click here to see a related figure.)
3. Look in the list of defined names for one called Print_Area. This is the definition of your print area. (If you don't see an entry by this name, there is no print area defined in your worksheet.)
4. Select the Print_Area entry and click on Delete. The entry is removed, and your print area is now deleted.
5. Click on Close to close the Name Manager.