Go into Page Setup. Select the Sheet tab. In Rows to Repeat at top, enter
$1:$1

Tyro

"Musette" wrote in message
...
I want the Header Row (Row #1) to automatically appear at the top of each
page.

I have done this before, but can't remember how I did it. Hope you can
help.