repeat first row at the top of page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
dumo13 said:
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.
Click to expand...
 
dumo13 said:
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.
Click to expand...
 
Back
Top