How to Freeze Multiple Rows and or Columns in Excel using Freeze Panes

Freeze panes in Excel means to freeze certain rows and columns that you want to see always even while scrolling up and down, left and right.
Freezing 1st row or 1st column is easy and straightforward, but freezing multiple rows and columns together requires an additional step. Here you will understand how to freeze more than 1 rows and columns together.

SUBSCRIBE NOW!

Click this link to learn more awesome functions in Excel

Click this link to learn how to manage your personal finance using Excel

[aneesmohd]

another video taking 10 to 15 min to explain and analysis this small thing, you did this as fast and good explanation. THANKYOU ....

[vasangelis]

I was 100% sure before even opening the YouTube tab that there will be a guy with Indian accent who will solve my problem within a minute...😂

[wasiqfaiz]

thank you for explaining too quickly without any wastage of time

[azeryndernebel]

We need more 'How to' videos like this. Straight to the point - no muss, no fuss, clear and concise. Thank you for this.

[IngridTID]

Finally, a quick short explanation without any useless fillers and wasting of time. Thank you.

[MUJO]

This explanation was clear and straight to the point! Thank you. This helped me at work immensely.

[chiamakaezeobi]

You have no idea how useful this was. Thank you!

[renitalake]

So clear and concise! I've used excel for decades now but usually only need the first row to remain stationary. Today, at 48 years old, I get a doc with three top rows that need to remain on each page. BOOM! Quick and simple. Thank you~

[jaindia]

Very clear and concise explanation. You make it sound so simple. Thank you.

[JC-okyx]

AMAZING! I spent 20 minutes today trying to figure this out. That makes so much sense.

[PinchingPesos]

thank you for making this quick, painless, and simple. TWENTY THUMBS UP!

[Miliex_NNK]

Omg, this has been my biggest dilemma in freeze pane all these yrs!!! THANK

[shreyaghoshaluniverse]

I read many q/a on Google and literally wasted an hour though couldn't make it but you explained it in 2 minutes. Thank you so much.

[g.r.]

This was EXACTLY what I wanted to know...great video! Hello from Canada!

[ourfamilyadventure]

THANK After torturous searching on the internet, YOU EXPLAINED IT PERFECTLY AND CORRECTLY!!!! Great job!

[francisotia]

Thank you.
This is the first video I checked out on this topic and it gave me exactly what I was looking for.

[nisa]

Thank you so much. Right now I’m updating a document for work that needs this and today is my deadline. Thank you for explaining in detail! This really helps x)

[mrCetus]

Straight to the point and perfectly explained tutorial, you're a legend!!!

[fpost]

So simple! Searching for years. Other explain for minutes some weird stuff. Thank you!

[ayeaye]

Thank you so much, Sir. You explained at 2 mins. I can solve it in 2 seconds.