Thursday, March 12, 2009

Freeze panes in a Excel sheet

At time u may need to check the table's heading. But by default it will not be shown if u scroll down.
For that u need to freeze the panes.

Here I am giving the steps for Office 07.

1. Click on the row below the table heading or a row below the place where u want to freeze.

2. Goto view tab.

3. select freeze panes

4. In that select Freeze Panes.

U can also freeze a particular row or column.


The above is the original Sheet.

Below is the unfreezed one.


At last the use of freezing panes

No comments:

Post a Comment

Page Counter