Office XP Excel

If you want a Header, go to View>Header Footer.
If you want to repeat the same row on each page, go to File>Page set up.
On the sheet tab enter the row(s) to repeat at top IE
1:1 or 1:3

The disadvantage of doing it as a header is that you don't have all the formatting features. I would suggest using the Merge and Center button on the Formatting Toolbar.

If you have data in columns A to G, highlights cells A1:G1, and click on Merge and Center. This will allow you to insert, delete or resize columns - and continue to have the text centered on your page.