Freeze top pane:
Suppose you have a long list of names and with the column headers in the first row, then you would prefer to keep the first row static while scrolling through the list of names.
To freeze the top row, just click on the cell A2 in the sheet and use the option Window-->Freeze Panes.
Now, you will notice that even when you scroll down, the column headers remain static.
Freeze left pane:
If you want the first column in the sheet to be static/frozen, you can click on the cell B1 and then freeze the panes.
Freeze top and left panes:
If you want both the top and the left panes to be frozen, simply use the option on the cell B2. You will be able to scroll horizontally and vertically through your sheet keeping the first row and first column immovable.
The idea is you should always select the first movable cell when you select the ‘Freeze Panes’ option.
To unfreeze the panes, use the option Window-->Unfreeze Panes.
Freeze left pane:
If you want the first column in the sheet to be static/frozen, you can click on the cell B1 and then freeze the panes.
Freeze top and left panes:
If you want both the top and the left panes to be frozen, simply use the option on the cell B2. You will be able to scroll horizontally and vertically through your sheet keeping the first row and first column immovable.
The idea is you should always select the first movable cell when you select the ‘Freeze Panes’ option.
To unfreeze the panes, use the option Window-->Unfreeze Panes.
Fantastic Roshan! This was difficult to find even in Excel Help. The illustration with pictures was helpful... Good Work Keep it up!!! - Krishna
ReplyDeleteGreat help!! Thanks!!
ReplyDeleteThanks!! :)
ReplyDeleteThank you..it helped me....!!! Thanxz a ton..
ReplyDeleteThank-U Very much it help to known that option
ReplyDeleteAwesome. Thanks so much.
ReplyDelete