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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.