header row
 

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

Click in A2, Window | Freeze Panes.


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

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" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message
...
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 writes
Click in A2, Window | Freeze Panes.



Brilliant - Thanks

Anne Troy 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" wrote in message
...
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