Microsoft Office Tutorials and References
In Depth Information
My Page Was Set Up!
Putting out the print titles
Excel’s Print Titles feature enables you to print particular row and column
headings on each page of the report. Print titles are important in multipage
reports where the columns and rows of related data spill over to other pages
that no longer show the row and column headings on the first page.
Don’t confuse print titles with the header of a report (see “From Header to
Footer” later in this chapter). Even though both are printed on each page,
header information prints in the top margin of the report; print titles always
appear in the body of the report — at the top, in the case of rows used as print
titles, and on the left, in the case of columns.
To designate rows and/or columns as the print titles for a report, follow
1. Click the Print Titles button on the Page Layout tab on the Ribbon or
The Page Setup dialog box appears with the Sheet tab selected (see
To designate worksheet rows as print titles, go to Step 2a. To designate
worksheet columns as print titles, go to Step 2b.
2a. Click in the Rows to Repeat at Top text box and then drag through the
rows with information you want to appear at the top of each page in
the worksheet below. If necessary, reduce the Page Setup dialog box
to just the Rows to Repeat at Top text box by clicking the text box’s
For the example shown in Figure 5-7, I clicked the Collapse/Expand
button associated with the Rows to Repeat at Top text box and then
dragged through rows 1 and 2 in column A of the Little Bo-Peep Pet
Detectives – Client List worksheet. Excel entered the row range $1:$2 in
the Rows to Repeat at Top text box.
Excel indicates the print-title rows in the worksheet by placing a dotted
line (that moves like a marquee) on the border between the titles and
the information in the body of the report.
2b. Click in the Columns to Repeat at Left text box and then drag through
the range of columns with the information you want to appear at the left
edge of each page of the printed report in the worksheet below. If
necessary, reduce the Page Setup dialog box to just the Columns to Repeat at
Left text box by clicking the text box’s Collapse/Expand button.