View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Musette Musette is offline
external usenet poster
 
Posts: 11
Default 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.