Office 2010: Freeze or lock rows and columns

Lock rows and columns by freezing panes
1. To lock rows, select the row below where you want the split to appear.
To lock columns, select the column to the right of where you want the split to appear.
To lock both rows and columns, click the cell below and to the right of where you want the split to appear.
2. On the View menu, click Freeze Panes.
3. To unlock rows, click Unfreeze Panes on the View menu.
ที่มา: Freeze or lock rows and columns