Header rows

[jknapp1005]

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?

 

[Sean Timmons]

In worksheet view, go to your print section and page setup. On Sheet tab,
udner Tows to repeat at top: enter 1:1 to show row 1.

 

[jknapp1005]

Sean,

That didn't work at all. When I went to the page setup area the line you
described was greyed out, and the button to the right didn't work either. Is
there a step that is missing?

 

[Sean Timmons]

Looks like you should be in Page Layout then Print titles...

 

[Gord Dibben]

In earlier versions if you went to page setup while in Print Preview the
"rows to repeat at top" would be grayed out.

If you went in from File>Page Setup>Sheet you would be OK.


Gord Dibben MS Excel MVP