How to do header row?

  • Thread starter Thread starter Marianne
  • Start date Start date
M

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
 
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.
Click to expand...

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