How to Freeze Panes in Excel 2010
— Position the cell cursor based on what you want to freeze (row, column)
— In the Window group of the View tab, choose Freeze Panes and Freeze Panes (of Freeze top row if this is what you want).
— In the Window group of the View tab, choose Freeze Panes, Unfreeze Panes to unlock the fixed rows and columns.