Forum Discussion
How to freeze Rows & columns at the same time
Apparently, Freeze Panes is already active.
So first select Unfreeze Panes from the Freeze Panes dropdown.
Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.
Apparently, Freeze Panes is already active.
So first select Unfreeze Panes from the Freeze Panes dropdown.
Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.
- So simple, but not clear in the standard instructions! Thanks for solving a super annoying issue for me!
HansVogelaar thanks Hans. I didn't think about the need to unfreeze everything before applying the custom freezing option. Years later, just wanted to let everyone know that this fix is still valid. For the life of me, I couldn't figure out why Freeze Panes was not showing up as an option for me. Unfreezing and then placing the cursor in the first active cell outside the range I wanted frozen worked perfectly.
Good to hear that!
- Worked, thanks much. For some reason it worked for me in cell B2, guess it is a formatting thing.
- Thank you, this works perfectly!
It works. Thanks for your great advice.
It's so simple but can be frustrating if you don't know how!
Thanks Hans HansVogelaar
Your faultless advice worked perfectly.
Excel help is surprisingly unclear and suggests freezing column A first - which of course freezes that column and then you can't freeze rows.
But you've explained how to freeze Excel Rows & Columns at the same time 101% clearly & accurately.
So ... THANK YOU again.
cn
- I had the same problem but I still can get only half of the solution to work. Clearly I am missing the point. Sometimes I get the top row to freeze but not the left most column to freeze. Or vice a versa. Help. I used to be able to freeze both with the beta version of excel years ago but as the product evolved I could no longer accomplish the task of getting both the top row and left column freeze at the same time. Help!
If the first item in the Freeze Panes drop down is Unfreeze Panes, select that.
Select the cell below the last row that you want to keep visible, and to the right of the last column that you want to keep visible.
So for example, if you want to freeze the first row and first column, select cell B2.
And if you want to freeze the first two rows and the first three columns, select cell D3.
Then select Freeze Panes > Freeze Panes.
