Setting the Print Area

When you're ready to print your worksheet, you can choose several printing options. The print area is the section of your worksheet that Excel prints. You can set the print area when you customize worksheet printing or any time when you are working on a worksheet. For example, you might want to print a different range in a worksheet for different people. In order to use headers and footers, you must first establish, or set, the print area. You can design a specific single cells or a contiguous or non-contiguous range.

Set the Print Area

Select the range of cells you want to print.

Click the File menu, and then point to Print Area.

Click Set Print Area.

Clear the Print Area

Click the File menu, and then point to Print Area.

Click Clear Print Area.