In Excel 2007 header rows don't appear to be the same as in Word. In Word if
you select the header row in a table you can have that repeat as the header
row in a table across pages.

Is there a way to do that in Excel? I really don't understand what is going
on with header rows in Excel. When you create a header row in a table it
automatically chooses to do a data sort, and there is no option to repeat the
header row across the pages that I can see. Am I looking in the wrong place,
or is the header row function in Excel entirely different?