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!
/ @excelrush
Click this link to learn more awesome functions in Excel
• Learn Excel's Tricks
Click this link to learn how to manage your personal finance using Excel
• Personal Finance

[@aneesmohd9641]

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

[@zionsdaughter2391]

Very helpful. Watching from Malawi. Africa

[@liakat26]

strong and clear teaching words are used to explain easily a trick. from Dhaka. sir thanks for sharing your knowledge.

[@amitpoonia1123]

Thank u alot without wasting even a second..

[@iZacq]

How to Freeze column on Top & on the Right side ❓️
Cant find any videos of it, is it not possible ?
Please

[@wasiqfaiz]

thank you for explaining too quickly without any wastage of time

[@Excelrush]

Glad it helped! Do subscribe to the channel

[@thanhtando]

still not quick enough

[@faizkhan-dj9ti]

True

[@shilpamanchanda8421]

Yes ty fr quick short vid

[@azeryndernebel1554]

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.

[@1991MUJO]

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

[@jaindia1661]

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

[@renitalake3580]

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~

[@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.

[@JC-ok4yx]

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

[@svetlanazoubkova5554]

Was struggling for sooo long and in the end its that easy. Thank you for the clear and on-point advice! :)

[@Miliex_NNK]

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

[@jyotiyadav810]

It was exactly what I needed. Clear, simple and straight to the point. Thank you very much.

[@g.r.2985]

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

[@mrCetus]

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

[@baijayantasenchowdhury9806]

Effective and time saving. I hate long videos when I'm stuck with office work. Thanks for making is concise and getting to the point right from the get go.

[@BlkTechGurla]

Short, sweet, and so effective! Thank you! Here's your crown king. 👑

[@nisa6361]

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)

[@neeki4eva]

Amazing! Straight to the point. Very clear, exactly what I needed. Thank you

[@francisotia4370]

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

[@stefaniemorris5187]

Looked at a bunch of things before this and only this one made sense and worked immediately. Thank you for making my day easier!

[@marisarobertsonphysics980]

I did not know excel changed how to freeze panes - thank you for such a great explanation!!

[@louiseb189]

God bless your soul! I almost went crazy looking for figuring this ou!

[@ourfamilyadventure326]

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

[@mwhite7844]

!!!!!!!!!!!!!!THANK YOU!!!!!!!!! WOW! OMG! Thank you! I spent an hour trying to figure this out in excel help, on different websites, and looking at slow, 10-minute tutorials that did not answer this simple question. You did it clearly and concisely, and in less than two minutes!!! Liked and subscribed. If you're in Washington State, I owe you at least a cup of coffee. THANK YOU!!!!

[@ayeshasiddiqua4351]

Thank u so much , U have clear my major doubt .....no words to say for solving my problem , many thanks
allah bless u happy life
thanks once again

[@Capataro]

Thank you, great, quick and easy explanation!

[@teamrush42]

This is great!! Spent 15 minutes trying to figure it out and you explained it in 2!!! Thank you!!

[@tonyrodriguez2003]

That is just what I was looking for. Thank you for your straight and to-the-point video.

[@prachandrakayastha4556]

Thank you sir ! Respect from Himalayan Kingdom of Nepal

[@amandamishellesalcedo3626]

THIS WAS SO USEFUL THANK YOU VERY MUCHHHH!!!!

[@bajer111]

You have no idea how much I've been struggling with this function over the years. Glad I finally dicided to find out how it really works! Thanks!

[@johnchrys5716]

Excellent Thank you.Spent for ages looking at how to do this and your the first one to actually make it clear. WELL DONE 100%

[@tejaannepu439]

THANKS FOR THE CLEAR EXPLANATION

[@the_salahcar]

thank you so much sir , in just two minutes you told very important thing. thanks a lot.

[@PinchingPesos]

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

[@CassandraLegge]

Every single time, I forget how to do this and then come back to this video. Thank you for the quick, concise tutorial!

[@navneetsaini6698]

Never seen just 2 min solution explanation in just 2 minutes for the 2 hour work

[@georgia2354]

Clear, concise, quick video, exactly what I needed! Thank you! 😁

[@josequispe8241]

Thank you dude.. I have this very long row for keeping grades for my students. It was difficult to keep on track their names.. now I won't missgrade them anymore..

[@nataliekimani699]

Hi! Thank you so much for the clear explanation. It was brief and you made it easy for anyone to understand. Well done!!!🎉

[@JahangirAlam-bl1fx]

Very nice. It was helpfull to me. Thanks

[@zigzagg6697]

Your explanation is good but i have a problem I'm using old Ms Excel version "Not have A freeze pane Option, instead of Showing 'Unfreeze pane' " Pls tell me How to do the same in this version also...

[@Laura-zx9mp]

this was so helpful. Also, straight to the point and well explained. Thank you!

[@adreuter]

This is the easiest and straight to the point video ever. You saved me and my job.

[@prabhuarumugam5398]

Hi Bro! Thank you So Much! It was really helpful! Your Explanation is crisp clear. Once again Thanks!

[@fpost337]

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

[@army1157kit]

Did the job in Seconds and LOVE IT .. I just looked at another video it went on for over 5 min with the same answer...

[@AllInOne-jg5qx]

I wonder why I found this video is on second in RUclips list. It's the best and should at first. You taught how to freeze only first row and column and also custom option. All I wanted to know.
Well. Good Work.

[@charlesbrown9027]

Explained in a simplest way.Thank you so much ,so useful

[@ToddBeal]

Thank you for this! I've been using Excel for years and did not know this.

[@jasont.greene4003]

Thank you so much! I was always able to freeze either the top or the left but never at the same time, so thank you for explaining how to freeze both at the same time!

[@mlbjr]

crazy helpful! thank you! exactly what i needed without the fluff.

[@stormyweather7200]

Thank you for helping countless people with their college assignments good sir. You're doing God's work

[@martinfernandez882]

Thank you! Simple, not drawn out, very helpful.

[@antoniaking4719]

THANK YOU!!! I always forget how to do this! And you explained it so plainly and perfectly-it helped a lot!!!

[@privateeyety5735]

Clear and simple, had such a hard time finding a clear answer to this. Thank you!

[@amitabhabhattacharya4051]

The kind of teacher who needs to explain only once. Thanks a lot.

[@nesco713]

What!! I thought I knew excel....amazed! And simple to do! Thank you

[@pemberlycottage]

Thanks so much for this quick and simple explanation of what to do. I truly appreciate this video for helping me out.

[@marlenea.5279]

Great explanation, thank you so much. It worked for me!

[@charleneross3382]

Thank you for the short and simple explanation!

[@edsonr.2017]

I love it - some videos take 10 minutes to explain things - here, I found the solution to my problem in less than 2 minutes - super !
thanks so much :)

[@alicebethapudi7241]

Thanks for the quick explanation. Awesomeness!

[@priyankaranjan3983]

Thank you for explaining in such a simple way without wasting time

[@rajmejari6563]

Nothing better than such an explanation... thanks a lot

[@marandadavis2440]

THANK YOU! I could never get the right pane to freeze - no where have I seen it explained to select the cell just below and just to the right of where you want the freeze to occur. You helped me tremendously!

[@rob_fig]

Perfect explanation for years of frustration. Thank you!

[@arjiecanillo8929]

Very helpful. Clear and consise. Saves a lot of time.

[@ayeaye436]

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

[@LordRamInMyHeart]

Thank you so much. It's very short and very helpful

[@jessicamergen1954]

what a great explanation, fast, simple, clear. Exactly what I needed!

[@rocioquinonesmontano6495]

Loved it, easy explanation and now I can freeze only the columns that I need. Much appreciated, blessings!

[@swatikewlani1038]

Thank you for this quick explanation.

[@savi3sounds]

thank you so much for posting this. I am watching from Trinidad West Indies.

[@fifaham]

We need online tutorials like yours; they are short and to the point.

[@BlackLegGez]

Thanks brother! short and simple explaination 👏👏

[@hanakambay4958]

You are Amazing, really you can explain things in a simple way

[@dziggy983]

Thank you very much for quick explanation. Cheers

[@hanleeshankpm-guru2050]

Thank you so much!! You explain so well!

[@alejandracerda2322]

I love your way of explaining. Clear and concise. Thanks a lot.

[@CaptMdFaizurRahman]

Hello Sir, Very simply you have shown the solution! Wonderful. Many Thanks

[@kiritpatel5464]

Wonderful and sensible explanation. Many thanks.

[@stephenessilfie5664]

Concise and precise. You make using Excel simple than imagine. Thank you

[@janel_206]

Thank you! This was quick and easy!!

[@Art3miz]

Dude, thank you, exactly what I was looking for in a very simple and short video.

[@JYawe11]

Been of much help. Thank you!

[@luisasolisp]

Great and easy explanation. Many thanks.

[@ga-dx1fg]

Thank you! Worked perfect.

[@starmazaheri7448]

Short and to the point. The yellow highlight really helped. Thanks a lot Sir.

[@drdavekatz]

Thank a lot! Short and clear! Great!

[@elwoodbluesmorris2120]

Awesome video, explained just what I needed to know easily and to the point. Thank you.

[@BCF2017]

Thanks a lot 😊 for not wasting the time of others and quick solution 👍🏾👌

[@elmaestroinnes2520]

Excellent clarity. Thank you!

[@siddarthdutta3974]

Thank you for this! Perfect 2 minute video explaining this concept. Really appreciate it!

[@aminatlamidi2950]

Wow. Thanks for this video. I have been struggling with this for long

[@user-tz6up1hq3x]

Made it so simple. Thank you for sharing.

[@SG-dd9wd]

You just solved a lifelong riddle, thank you so much!

[@geetalikhera7913]

Thanks so much. I was struggling so much how to do this. Even excel help didn’t explain as well as you did

[@neelankusekhar9949]

Thanks a lot for the precise explanation.

[@SurajMaurya-kp9zx]

I'm grateful for this knowledge because the video was really helpful.