How do I keep the first row from moving?

  • Thread starter Thread starter Ryan Ashline
  • Start date Start date
R

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
 
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
 
Back
Top