Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I lock both column and rows at 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.

share|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
up vote 24 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".

share|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
The freeze panes behavior has not changed since Office 95 at least. – Martha Oct 29 '10 at 16:12

Additional Help

Freeze or Lock Rows and Columns

I found it Very Difficult to figure out how to do this for the Top row and for a couple of Columns. I did figure it out however,

First Split the panes

Excel 2010

and then move the large black Lines to the rows and columns that you want Static (or Fixed)

you can click Freeze panes > Freeze Panes and then click Split or you can just click Split. if you do anything else in the Freeze Panes and then Try to Split it will only Give you One Thick Black Line.

if your focus is in the are that is Static (Fixed/Locked) and try to scroll you will scroll only that pane.

I am using Excel 2010

share|improve this answer

I was also struggling with the same problem of freezing the first row and the first column at once. The solution is quite simple:

  1. Select field B2.
  2. Click on the "Freeze Panes" button.
  3. Done.

(Works in Excel 2013 on Windows 8 Professional)

share|improve this answer
  1. Click on Cell, from where you want to freeze the pane.
  2. Click on Split, a thick bar will appear. If you see closely you will find that it has created a pane.
  3. In my case I selected Cell B10.
  4. Click on Freeze pane, then again click freeze pane option. There you go you have frozen a column and row at a time.
share|improve this answer

Here is a VBA snippet that may help with this.

With ActiveWindow
    .SplitColumn = 1
    .SplitRow = 0
End With
ActiveWindow.FreezePanes = True

With ActiveWindow
    .SplitColumn = 1
    .SplitRow = 1
End With
ActiveWindow.FreezePanes = True
share|improve this answer

Key is to simply click the Freeze Panes button rather than select the arrow on button. Clicking the Freeze Panes button will freeze both rows and columns according to the pane you've selected, whereas selecting the menu arrow on the Freeze Panes button forces you to select only one option.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.