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
>
>
> --
> Hywel
> ------------------------------------------------------------------------
> Hywel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14824
> View this thread: http://www.excelforum.com/showthread.php?threadid=345804
>
>
> 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.
Place cursor in cell A2>Windows>Freeze Panes
If you also want to lock column A, as you scroll across the screen, place
the cursor in B2 before applying the freeze.
--
Regards
Roger Govier
"ldalton" <ldalton@discussions.microsoft.com> wrote in message
news:B4874F00-1390-47C5-9456-FEC1E653DC54@microsoft.com...
>
>
> "dumo13" wrote:
>
>> 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.
> 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 wrote:
>
> "dumo13" wrote:
>
>> 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.
Place the cursor in cell A2 and select Window | Freeze Panes.
Question
Reply
Top
Answer
Notify me of replies