Microsoft KB Archive/52167

Excel: Deleting a Print Area Last reviewed: November 1, 1994 Article ID: Q52167

SUMMARY In Microsoft Excel, you can print out only a portion of a worksheet through use of a print area. Once set, there are two ways to delete a print area in Microsoft Excel. Method 1 Remove the print area by setting the entire document as the print area, as follows: Select the entire document by clicking in the upper left-hand corner of the worksheet. From the Options menu, choose Set Print Area. Method 2 Use Formula Define Name to delete the defined name Print_Area, as follows: From the Formula menu, choose Define Name. Select Print_Area from the list box. Click the Delete button. The first method of deleting a print area is particularly useful if Define Name is not available because you are using custom menus.

KBCategory: kbother KBSubcategory: Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 Last reviewed: November 1, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.