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 set a single cell or a contiguous or non-contiguous range.

Set the Print Area

Select the range of cells you want to print.

Click the Page Layout tab.

Click the Print Area button, and then click Set Print Area.

[View full size image]