Set a Specific Area to Print

Highlight the area you want to print. Choose Page Layout => Page Setup => Print Area => Set Print Area. Dotted lines appear around the print area. When you print the worksheet, only the area contained within the dotted lines prints.

Whenever you fool with the Print Area, you need to keep in mind that after you define it, its cell range is the only one you can print (regardless of what other Print What options you select in the Print dialog box) unless you click the Ignore Print Areas check box and until you clear the Print Area.

To clear the Print Area (and therefore go back to the printing defaults Excel establishes in the Print dialog box) you just have to click Print Area | Clear Print File on the Page Layout tab or simply press Alt+PRC.

You can also define and clear the Print Area from the Sheet tab of the Page Setup dialog box opened by clicking the Dialog Box launcher in the Page Setup group on in the Ribbon's Page Layout tab. To define the Print Area from this dialog box, click the Print Area text box on the Sheet tab to insert the cursor and then select the cell range or ranges in the worksheet (remembering that you can reduce the Page Setup dialog box to just this text box by clicking its minimize box). To clear the Print Area from this dialog box, select the cell addresses in the Print Area text box and press the Delete key.