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.

Did You Know?

You can avoid repeating rows and columns . For best results when printing a multipage worksheet, you'll want to coordinate the print area with specified print titles so that columns or rows are not repeated on a single page.