Subscribe

Lesson 89 of 104 2 min Updated Completed

How to Set and Clear a Print Area

A print area tells Excel to print only certain cells, every time you print that sheet. It’s saved with the workbook.

  1. Select the cells to print. Here, B2:C9.

    The range B2:C9 selected

  2. Click Page Layout > Print Area > Set Print Area.

    Set Print Area on the Page Layout tab

  3. Save the workbook.

  4. To check, click File > Print (Ctrl + P). Only the print area appears.

    The print preview showing only the print area

Clear the print area

The quickest way is Page Layout > Print Area > Clear Print Area.

You can also delete it in Name Manager, because Excel stores the print area as a name:

  1. Click Formulas > Name Manager.

  2. Select Print_Area and click Delete.

    Deleting Print_Area in Name Manager

Check the print preview again (Ctrl + P) to make sure the whole sheet prints.