Print Selected Area From Excel 2007 Excel 2007 offers a variety of ways to print selected areas of your workbook. You can print just the worksheet, a specific range, or all sheets in the workbook. ..
With the spreadsheet open highlight the rows and / or columns you want to print out.
Next, click on the Print Layout Tab on the Ribbon. In the Page Setup section click Print Area and then Set Print Area. This will show a perforated outline around the selected rows and columns.
Now just hit the Quick Print or go to the Office Button and Print. Now only the selected area will be printed out! Simple but effective tip! Also, this can save printer ink and paper which is always good for Green Computing.