repeat first row at the top of page?

[Guest]

How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down
the page, row one will always be at the top of the worksheet.
I can make it repeat itself as the first line on each new page, but I need
it be at the top of the worksheet as I scroll down so I can easily see the
column headings.

 

[Hywel]

One way of doing this is with 'freeze panes'.
If you want Row 1 to always be visible click in Cell A2, go to Window >
Freeze panes.

If you wanted it to show the columns as well, then perform the same,
but have cell B2 selected.

It won't change the way that the document prints however.

Hope this helps,
Hywel
Manchester UK

 

[Guest]

Thanks champ, that's what I'm after!

 

[ldalton]

How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down
the page, row one will always be at the top of the worksheet.
I can make it repeat itself as the first line on each new page, but I need
it be at the top of the worksheet as I scroll down so I can easily see the
column headings.

 

[curious]

How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down
the page, row one will always be at the top of the worksheet.
I can make it repeat itself as the first line on each new page, but I need
it be at the top of the worksheet as I scroll down so I can easily see the
column headings.