MVP #63: How To Freeze Row(s) And Column(s) Simultaneously In Excel

Yesterday, I found a three weeks old email that I didn't remember noticing. It's the downside to getting too many emails a day. My smartphone says I have over 120,000 unread emails, and I think I get over 100 emails a day. This particular email was from someone who is interested in our Excel training. He wanted to know how to freeze beyond the "Top Row" and "First Column" option. 

His exact question was, "How can I freeze a worksheet both horizontally and vertically at the same time? "

Technically, he meant how can I freeze row(s) and column(s) simultaneously in Excel. 

It is a common question that people also ask during our training sessions. I have a very interesting way of explaining it such that you can't get it wrong but I am unable do that via an article. It's a mix of captivating stories and live demonstration.

However, I'll give you a summary answer that will guide you if you have such problem in Excel. It is very easy to implement and remember too.

You click on the cell below the row you want to freeze and after the column you want to freeze. Then you click on View menu, Freeze Panes, Freeze Panes.

Below is an illustration of how to freeze row 1 and column 1 at the same time. It can be applied to any number of rows and any number of columns.

And that's it!


  1. Thank you very much. I do not know which is more simple: your answer, or me! LOL


You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.