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.

"jknapp1005" wrote:

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,

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" wrote:

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" wrote:

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?

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

"jknapp1005" wrote:

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" wrote:

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" wrote:

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 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 FilePage SetupSheet you would be OK.


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 12:54:09 -0700, jknapp1005
wrote:

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" wrote:

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" wrote:

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?