Header rows

  • Thread starter Thread starter jknapp1005
  • Start date Start date
J

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?
 
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.
 
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?
 
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
 
Back
Top