Splitting Panes and locking rows and columns in excel is very useful option not all of us could be aware of it.
When you are working with big excel sheet, This option will be very useful because you can view two areas of a worksheet and lock rows or columns into one place by splitting panes and locking rows and columns. Lets see how to do this.How to Freeze Panes in Excel 2010
1- Splitting Panes:
When you split panes, you can scroll in the two areas of the worksheet that you’ve split, and all areas remain visible. You’ll see more of what we mean in just a minute.
The Splitting option work as the following in excel, it is Splitting the cells above and right to your active cell, in the below figure you can see the i clicked split while the active cell was K4 so the excel split the worksheet into 4 areas, above and right to the active cell.
To unfreeze, follow the same steps, but select Unfreeze Panes.
2- Locking Rows and Columns by Freezing Panes:
When you Freezing Panes in Excel , you select rows and columns that remain visible when you scroll in the worksheet. You freeze panes to keep row and column labels visible as you scroll through.
To freeze rows or columns, go to the View tab and click Freeze Panes in the Window group.
See This Excel Tutorial Video for more practices: