Freeze top row and multiple columns in Excel
To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll (source).
Select I2
. Now go to the View
ribbon and click Freeze Panes
. Choose the first option which will freeze the columns and rows to the left and above your selection.
This should work for both Microsoft Excel 2007 and 2010