Microsoft Office Tutorials and References
In Depth Information
Printing part of a worksheet
Printing part of a worksheet
When you create a worksheet containing lots of data, you might
want to print just the section of the worksheet with the data
relevant to the point that you’re trying to illustrate. The good news
is that you can set a print area so that Excel prints as much or
as little of your worksheet as you like. The print area is outlined
with a dashed line, which lets you see 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.
2
3
Set a print area
1 Select cells that you want to print.
2 Click the Page Layout tab.
3 Click Print Area.
4 Click Set Print Area.
4
TIP Try to arrange your data so that the content to be printed
looks the same on the screen as it will on the printed page. You
can define print areas composed of 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.
1
Remove a print area
1 Click the Page Layout tab.
2 Click Print Area.
3 Click Clear Print Area.
1
2
3
Search JabSto ::




Custom Search