how to freeze pane with only one row?

[symp news]

Hello all,
I am trying to create a view so that I can see my header row as I scroll
down a table with thousands of records/rows.
When I select this row1 and then go to Window->Freeze Panes, I get a pane
that contains the first 12 rows. I would like just the 1st row to be frozen
in this pane.
Have tried selecting the entire row and just the columns in the first row
that are required - to no avail.
Can anyone help me do this?
Thanks!

 

[Paul B]

symp news, select a cell in row 2 then freeze panes
--
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

 

[just me]

Thanks very much Paul.
simple answer that I somehow didn't comprehend from reading the help docs.