Recently I have been asked a similar question from several independent users of Excel. It seems they have a long document that will exceed one page when printed. The column headings that make the printed information make sense on the first page need to be repeated on the second, third, and subsequent pages. If the data is "static", the column headings can be copied and pasted to the proper rows with no trouble. But what happens if the data is "dynamic"? The questions received came from people with a dynamic table. The energy and effort to copy/paste every time the rows changed make the copy/paste process inefficient at best. Fortunately, Excel has just the thing for this situation. (This tutorial uses Excel 2003. Other versions may have slightly different procedures.)
For purposes of this exercise, imagine a "lengthy" listing of contacts with the following column headings. Again imagine the user wishes to have the same column headings printed on subsequent pages.
The first thing to do is to create the entire document and then tell Excel what you want it to do for you when you print. Check out the File + Page Setup feature.
Depending on the last previous use of this feature, you may revert to the following dialog wizard. This may be the panel you want. If not, click on the Sheet Tab to open the proper wizard.
Now you are ready to begin.
Simply enter the beginning and ending row(s) you want repeated. In the example below, the request is to repeat row 1. Note that a $1:$3 would repeat the first three rows. You could have a "heading" you wish displayed on the first page and then repeat the columns headings on all subsequent pages. Simply enter the beginning row and ending row and you should see the requested row repeated. The column headings do not have to be in row 1all the time.
The "proof" of the process is illustrated in the following Print Preview screens.
Screen 1
Screen 1 displays the column headings. Selecting Next will display the second screen.
In this example, the total listing would require only two pages. The Previous button is highlighted to indicate the document is finished. Note the column headings will appear above the appropriate columns. That was fairly easy!