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.

Remove a Print Area

• Click the Page Layout tab.

• Click Print Area.

• Click Clear Print Area.

Tip

Try to arrange your data so the content to be printed looks the same on the screen as it will on the printed page. You can define print areas from multiple parts of the same worksheet, but you should keep that technique in reserve for when your worksheet data appears on more than one page.