Microsoft Office Tutorials and References
In Depth Information
PRINT MULTIPLE AREAS
of a workbook
You can print noncontiguous areas of your worksheet,
thereby limiting your printing to the information that
is of relevance. This feature involves little more than
selecting the cells you want to print.
There are many reasons why you may want to print
noncontiguous areas of your worksheet. For example,
if you have sales data for several products, each in a
column, you can select and print only the columns
that are of interest to you. You select noncontiguous
areas of the worksheet by pressing and holding the
Ctrl key as you click and drag. After you select areas,
you set them as the print area.
When printing noncontiguous areas of your worksheet,
you may have column headings or row labels you
want to print with each selection. You can specify the
rows you want to repeat at the top or the columns you
want to repeat down the side of every page you print.
When you print a worksheet with multiple selected
areas, each area prints on its own page.
Press and hold the Ctrl key as
you click and drag to select each
area you want to print.
Click the Page Layout tab.
Click Print Area.
Click Set Print Area.
Click Print Titles.
The Page Setup dialog box
Click the Sheet tab.
The areas you selected in Step 1
are shown here.
Click and drag the columns or
rows you want to repeat or type
Click Print Preview.