Tip of the Day - Excel 2007: How to Print a Portion of a Spreadsheet

Setting the Print Area in Microsoft Office Excel

Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:

1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.