Lets see how to do this.How to Freeze Panes in Excel 2010
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. Splitting Panes and locking rows and columns in excel is very useful option not all of us could be aware of it.
