Microsoft Office Tutorials and References
In Depth Information
My Page Was Set Up!
use as print
titles on the
of the Page
Excel indicates the print-title columns 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.
3. Click OK or press Enter to close the Page Setup dialog box.
The dotted line showing the border of the row and/or column titles
disappears from the worksheet.
In Figure 5-7, rows 1 and 2 containing the worksheet title and column
headings for the Little Bo-Peep Pet Detectives client database are designated as
the print titles for the report in the Page Setup dialog box. In Figure 5-8, you
can see the Print Preview window with the second page of the report. Note
how these print titles appear on all pages of the report.
To clear print titles from a report if you no longer need them, open the Sheet
tab of the Page Setup dialog box and then delete the row and column ranges
from the Rows to Repeat at Top and the Columns to Repeat at Left text boxes.
Click OK or press Enter.