This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Excel 2007 Windows XP
Can the first TWO rows be frozen - I only find freeze top row.
TIA
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Use freeze panes and it will freeze all rows above the currently selected cell and also all columns to the left of cell. So if you want the 2 top rows and no columns put select cell in A3 and select freeze panes
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET5%3C/text%3E%3C/svg%3E)
Sure. Click in cell A3 (for example) then View / Window group / click on Freeze Panes / click on Freeze Panes again.
If my comments have helped please Vote As Helpful.
Thanks.
I suspect that the reason it hasn't been selected as a top answer is because to some people it does not appear to help. The problem that I (and the original poster I suspect) was having is that if you have alreadyfrozen the top row (or first column) then 'freeze panes' is not an option on the drop down list. In this instance the reply appears not to help.
So the key is whether or not you already have panes frozen. If you don't have existing frozen panes, then this post is indeed extremely helpful.
However, if you have any panes frozen then in order to freeze multiple panes, you first have to unfreeze all panes before you can do so.
However, you are right, the answer is good, as long as you unfreeze all panes firstbefore you follow the instructions.
I think the common problem here is that it is instinctual to select the ROW(s) we want to freeze, and it isn't working. The instructions say "based on current selection" so you figure "okay, I've got what I want frozen selected, why isn't it working?" They didn't write the instructions very well, lol.
Do not select the entire row and expect it to freeze those rows. Instead, select the FIRST cell in column A of the row you do not wish to freeze, then select Freeze Panes.
Also, if you wish to freeze columns as well as rows, this same applies, but you will then need to select the cell further down the row. For example, let's say you want to freeze the first two rows AND the first two columns. You will need to select cell C3. This will cause Columns A and B to freeze, and it will cause rows 1 and 2 to freeze. Always select the first cell you don't want frozen, contrary to the way the instructions sound, lol.
Duh - I was in A3 but I clicked on Top row instead of freeze panes. Thanks for your time