How to Repeat Header Rows in Excel Spreadsheets

To repeat a set of header rows in Excel

• Go to File > Page Setup
• Click on the "Sheet" Tab
  
• Click on the pyramid icon next to the "rows to repeat at top" field.
• Select the cells to be repeated
• Click on the pyramid icon again to return to the Sheet options
• Click OK.

Here's a screenshot from the Office 2004 Mac version.