How to do header row?

[Marianne]

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

 

[Andy Brown]

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

 

[Don Guillett]

file>page setup>sheet>self explanatory from there

 

[Marianne]

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