Header Row Repeated on Each Page

[Musette]

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.

 

[Tyro]

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

Tyro

 

[Musette]

Tyro:

Thank you for your help and quick response. It worked perfectly!