How to Set Print Area in Excel 2007

1. Open the Excel 2007 worksheet in which you want to define a print area.
2. Click a cell and drag the cursor over the rest of the cells you want to print to select them.
3. Go to the Page Setup group located on the Page Layout tab, and click 'Print Area.' Click 'Set Print Area' to define the selected cells as the area of the spreadsheet you want to print.