How to Freeze Pane or cell in Excel
when you are using Excel it is some time required to Keep some data always visible on top , especially when table is very large and you need to keep the header visible when browsing the lower rows of table , the solution to this problem is to freeze the pane and this is how you can do it .
Go to view tab in Excel 2007 and 2010 then in Window option there is option Freeze Pane in freeze panes there is three option
Freeze Panes (it keep the rows and coulombs visible depend on the selection)
Freeze Top Row (it freeze top row while rest of the sheet scrolls)
Freeze First Coulomb ( this option freeze first coulomb )