How to do header row?

How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at the top
of each page.

TIA

How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at the top
of each page.

If you mean for printing purposes, File -- Page Setup -- Sheet -- Rows to
repeat at top.

If you mean so that it appears on-screen at each pagebreak, you can't per
se.

You can lock e.g. row 1 in place by selecting A2 then choosing Freeze Panes
from the Window menu.

HTH,
Andy

filepage setupsheetself explanatory from there

--
Don Guillett
SalesAid Software

"Marianne" wrote in message
...
How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at the top
of each page.

TIA

Yes - that did it! Thanks a lot. You saved me a lot of
time.



-----Original Message-----
How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at the
top
of each page.

If you mean for printing purposes, File -- Page Setup --
Sheet -- Rows to
repeat at top.

If you mean so that it appears on-screen at each
pagebreak, you can't per
se.

You can lock e.g. row 1 in place by selecting A2 then
choosing Freeze Panes
from the Window menu.

HTH,
Andy


.