Microsoft Office Tutorials and References
In Depth Information
Adjusting Page Layout
Setting Security and Printing Options
Indicating Repeating Rows and
In Chapter 11, “Managing Large Amounts of Data,”
you learned how to freeze worksheet titles so they
remained on the screen even when you scrolled to
other areas of the worksheet. If your worksheet will
be more than one printed page in height or width,
you may want to print one or more rows or columns
on each page—in effect, “freezing” titles for each
page. To specify which rows and columns should be
repeated on each page, follow these steps:
1. Choose Page Layout>Page Setup>Print Titles.
The Page Setup dialog box opens.
2. On the Sheet tab, type a dollar sign ($)
followed by the row numbers or column letters
you want to print as titles in the Print Titles
section. Entering $1:$1, as you see in Figure
12-20, repeats rows 1 and 2 at the beginning
of each page. If you want a specific column on
each page, enter $A:$A (or whatever columns
you want) in the Columns to repeat at left box.
Specifying which columns and rows to print on
Printing Gridlines and
Although by default you see them on your screen,
Excel does not print the gridlines that divide the
rows and columns. The same is true for the row
and column headings. It would be extremely
difficult to tell where Column D is if it wasn’t
referenced at the top. Sometimes you want to print the
gridlines or the row and column headings so while
viewing the printout, you don’t have to rely on any
borders you’ve added.
3. Click OK.
Collapse Dialog Button
Click the Collapse Dialog button on the right
to collapse the Page Setup dialog box so you
can select the rows or columns you want to
include. Click the button again to return to
the Page Setup dialog box.