Note   This works for Excel 2010 and Excel 2007

If you want to print a specific selection on a worksheet, you can define an area that includes just that section. You can also add cells to that area and also clear it when you want to print the entire worksheet.

  1. On the worksheet, select the cells that you want to define as the print area.
  2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

 Note   The print area that you set is saved when you save the workbook.

— Crabby