Header Row Repeated on Each Page
 

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.

Header Row Repeated on Each Page
 

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.

Header Row Repeated on Each Page
 

Tyro:

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

"Tyro" wrote:

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.