Freezing column and Row - Please Help!

ramki

New Member
Joined
Oct 13, 2006
Messages
23
Hi,

In excel I freezed the first column (A1). Then I tried to freeze the first Row. I could not able to do that. In Windows Menu -> Unfreeze panes is there. How to freeze the first row and first column in excel? Please Help!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
unfreeze, then select cell b2, ten freeze again. in general, freeze panes freezes everything above & to the left of the selected cell.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,917
Messages
5,545,024
Members
410,647
Latest member
bernardazar
Top