Unlimited Web Space

Enjoy Unlimited web hosting

Nov 2, 2011

Freeze and Unfreeze panes in Microsoft Excel

This will make certain columns or rows freeze or fixed in Microsoft excel. Suppose you want to stroll on the large page of excel without going away from the first column(certain column). In other words, you need to view other columns or rows with respect to a fixed row, then you can use freeze and unfreeze in excel.
To freeze and unfreeze,

select the column or the row,
go to view, and click on the freeze panes.

The figure below shows Column A freeze so as to be viewed adjacent to column Z and AA, etc

Freeze panes Unfreeze panes

No comments:

Post a Comment