How do I keep the first row from moving?

[Ryan Ashline]

I have Office 2000 and just exported a spread sheet from another
program. In the first row it has the titles for the information in
the colums. I need to sort the information different ways and would
like to be able to lock the first row. How can I do this?

Thanks for your help

Ryan

 

[Don Guillett]

place cursor where desired such as cell C2 then window>freeze pane

 

[Gord Dibben]

Ryan

Select A2 and Window>Freeze Panes.

Select B2 and Freeze Panes if you want column A to remain locked also.

Everything above and to the left of your selected cell will remain "frozen" as
you scroll.

Gord Dibben Excel MVP