Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
It is easier to read a list that spans many pages when the column titles are included on each page.
On the Layout tab, under Print, click Repeat Titles.
Click the Rows to repeat at top box.
Without closing the Page Setup dialog box, click the row number of the row that you want to repeat, and then click OK.
Tip: Don't close the Page Setup dialog box until after you select the row. Drag the dialog box out of the way if it covers the row number that you want to click.
To repeat more than one row on each page of a printout, drag across the row numbers.
You can repeat columns on the left side of each printed page by using the Columns to repeat at left box.