Microsoft Office Tutorials and References
In Depth Information
Setting worksheet options
button on the Page Layout tab (a quick way to display the Page Setup dialog box). Click in
the Print Area box, and then drag to select the cells on the worksheet you want to include.
When you do this, the dialog box collapses so that you can see more of the worksheet, and
Excel inserts the cell range reference of the area you select in the Print Area box, as shown
in Figure 11-11. You can select multiple nonadjacent cell ranges by selecting a range,
typing a comma, and then selecting the next range. Each range you select prints on a separate
To remove a print area definition, you can return to the Page Setup dialog box and
delete the cell references. You can also use the Define Name dialog box to do this by
pressing Ctrl+F3 and deleting the name Print_Area. For more information, see “Naming
cells and cell ranges” in Chapter 12, “Building formulas.”
Specifying rows and columns to print on every page
On most worksheets, the column and row labels that identify your data appear in only the
first couple of columns and top few rows. When Excel breaks up a large report into pages,
those important column and row labels might appear only on the first page of the printout.
You use the Print Titles feature to force Excel to print the contents of one or more columns,
one or more rows, or a combination of columns and rows on every page of a report.
Suppose you want to print the contents of column A and rows 1 and 2 on all the pages of
the report shown in Figure 11-11:
Click the Print Titles button on the Page Layout tab to display the Page Setup dialog
box, open to the Sheet tab.
2. Click in the Rows To Repeat At Top text box, and then select the headings for the first
two rows. (To select multiple contiguous row headings, drag through them.)
Click in the Columns To Repeat At Left text box, and then select the column A
heading (or any cell in column A).
4. Click OK.
Figure 11-12 shows the result in Page Layout view. Notice that the column containing the
product numbers appears on both pages displayed in Page Layout view. If you did not use
print titles, the first column on the second page of the printout would display the August
totals column instead of the product numbers. You can specify separate print titles for each
worksheet in your workbook. Excel remembers the titles for each worksheet.