Printing Part of a Worksheet

When you create a worksheet containing lots of data, you might want to print the section of the worksheet with the data relevant to the point you’re trying to illustrate. The good news is you can set a print area so Excel will print as much or as little of your worksheet as you like. The print area is outlined with a dashed line, so you can tell which cells will be printed and which won’t. When you set a Print Area, you can select cells in a single rectangle or select cells located in various areas of your worksheet.

Set a Print Area

  1. Select cells you want to print.

  2. Click the Page Layout tab.

  3. Click Print Area.

  4. Click Set ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.