header row

[nospam]

Hi,

simple question - I hope.

I have a worksheet with the first row that has titles for each column.

I want to be able to scroll down the worksheet but still keep the header
(first row) at the top of the screen so I can see the titles of each of
the columns.

I thought this was easy but I cant do it.

I thought freeze pane was it but that picks its own boundaries.

Any help will be most appreciated.

Thanks

[VoG via OfficeKB.com]

Click in A2, Window | Freeze Panes.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

[Paul B]

freeze panes is what you want, click in A2 and then freeze pane, or if you
also want to keep some of the columns on the left click somwhere like C2

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"nospam" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> simple question - I hope.
>
> I have a worksheet with the first row that has titles for each column.
>
> I want to be able to scroll down the worksheet but still keep the header
> (first row) at the top of the screen so I can see the titles of each of
> the columns.
>
> I thought this was easy but I cant do it.
>
> I thought freeze pane was it but that picks its own boundaries.
>
> Any help will be most appreciated.
>
> Thanks
>
>

[Anne Troy]

Hi. Here's the "rules" for Freeze Panes:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"nospam" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> simple question - I hope.
>
> I have a worksheet with the first row that has titles for each column.
>
> I want to be able to scroll down the worksheet but still keep the header
> (first row) at the top of the screen so I can see the titles of each of
> the columns.
>
> I thought this was easy but I cant do it.
>
> I thought freeze pane was it but that picks its own boundaries.
>
> Any help will be most appreciated.
>
> Thanks
>
>

[Ragdyer]

See if this old post helps explain things:

http://tinyurl.com/2qdzt

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"nospam" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> simple question - I hope.
>
> I have a worksheet with the first row that has titles for each column.
>
> I want to be able to scroll down the worksheet but still keep the header
> (first row) at the top of the screen so I can see the titles of each of
> the columns.
>
> I thought this was easy but I cant do it.
>
> I thought freeze pane was it but that picks its own boundaries.
>
> Any help will be most appreciated.
>
> Thanks
>
>

[nospam]

Anne Troy <[email protected]> writes
>Hi. Here's the "rules" for Freeze Panes:
>http://www.officearticles.com/excel/...soft_excel.htm
>


Thanks for that.













>*******************
>~Anne Troy
>
>www.OfficeArticles.com
>www.MyExpertsOnline.com
>
>
>"nospam" <[email protected]> wrote in message
>news:[email protected]...
>> Hi,
>>
>> simple question - I hope.
>>
>> I have a worksheet with the first row that has titles for each column.
>>
>> I want to be able to scroll down the worksheet but still keep the header
>> (first row) at the top of the screen so I can see the titles of each of
>> the columns.
>>
>> I thought this was easy but I cant do it.
>>
>> I thought freeze pane was it but that picks its own boundaries.
>>
>> Any help will be most appreciated.
>>
>> Thanks
>>
>>
>
>

[nospam]

VoG via OfficeKB.com <[email protected]> writes
>Click in A2, Window | Freeze Panes.
>
>

Brilliant - Thanks