Microsoft Office Tutorials and References
In Depth Information
Click in the Rows to Repeat at Top field, and then click anywhere on row one in the worksheet.
You’ll see Figure 9-20:
Figure 9–20. Row 1 will now repeat on the top of all the printed pages
That selection guarantees that the contents of row one—which contains the table header row—
will appear at the top of every printed page, even if the print is 100 pages long. Now page two of our
salesperson report looks like this (Figure 9-21):
Figure 9-21. The evidence!
The header row has been instated here as well, insuring a much more readable report. You can
also select the Columns to repeat at left option, which will allow a column or columns to likewise
appear on every print page on the left of the page. Thus if you have a column of months in the leftmost