Print Areas

Tips, Tricks, and Answers

The following articles are available for the 'Print Areas' topic. Click the article's title (shown in bold) to see the associated article.

Designating a Print Area
Many people, when they print a worksheet, print the entire thing. You don't have to, however. You can specify that Excel print only a portion of a worksheet by designating a print area, as described in this tip.

Getting Rid of the Print Area
The print area is used to specify, well, the area you want printed in a worksheet. If you need to delete a print area, there are several techniques you can use.

Printing Multiple Ranges at Once
Need to print more than one portion of your worksheet? If you use named ranges for the different ranges you want to print, you can apply the technique in tip to print whatever named ranges you want.