When you have a huge amount of data under a common heading you are unable to see the heading when scrolled down the worksheet. What freeze panes does is it lets you freeze particular rows and columns of your choice so that you can see that frozen portion even when the rest of the datas are being scrolled. It makes your job much easier when you have thousands of data under one heading. Freezing and unfreezing panes changes the view of the data without changing the data itself.
Freezing a row-on the view tab in the window group, choose the freeze panes option then freeze the top row option, you will notice a line under the first row it means the row has been frozen, now when you scroll down the first row remains where it is while the rest of the data moves.
Freezing a column-the process is similar to freezing a row but instead of freeze top row option select freeze first column option a similar line will be visible besides the first column which means the first column is frozen and by scrolling to the right on the worksheet you will notice the first column stays where it was
Freezing both rows and columns-you can freeze both rows and columns simultaneously all you have to do is determine which row and column you want to select then select a cell accordingly as everything above and left to that cell will freeze by selecting freeze panes option. Now everything above and left to that cell will stay in place when you scroll and to unfreeze the panes just choosing unfreeze panes from freeze panes option.
What if you want to select more than one row or column or freeze something to the right side?
There is solution to that too first of all you will notice a little bar on top of the vertical scroll bar when you place your mouse there you will see that your mouse pointer has become a two headed arrow now left click the mouse button and drag down underneath the row you want to freeze and go to freeze panes option from the view tab and click it.
similarly there is a small bar on the right side of the horizontal scroll bar, placing your mouse pointer on it will show similar two headed arrow effect now click your mouse and drag it up to the column you want to freeze and click on the freeze panes option to freeze the column.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.