up vote 8 down vote favorite
share [g+] share [fb]

How can I lock both column and rows and the same time using the 'freeze panes' in Excel ? I can manage to freeze either columns or rows but not both. I can do a similar thing with "split panes", but this isn't quite what I want.

link|improve this question
It allows him to scroll either horizontally or vertically and keep the applicable column or row in sight, so that in a large table he can always see the column AND row headers. Think BIG tables. – Lance Roberts Jan 6 '10 at 21:46
feedback

1 Answer

up vote 13 down vote accepted

Click on the cell just right of the column and below the row you want to freeze, and select "Freeze Panes".

So, if you want to freeze the row 1 and the column A, click on B2 and select "Freeze Panes".
If you want to freeze the rows 1 to 3 and the columns A&B, click on C4 and select "Freeze Panes".

link|improve this answer
Thank you so much - I've been bashing my head against this and would never have figured it out. Damn, how I hate Office 2007 for this sort of crap! – EMP Jul 5 '10 at 5:53
1  
The freeze panes behavior has not changed since Office 95 at least. – Martha Oct 29 '10 at 16:12
feedback

Your Answer

 
or
required, but never shown