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

Пікірлер: 1 400

  • @aneesmohd9641
    @aneesmohd96413 жыл бұрын

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

  • @zionsdaughter2391

    @zionsdaughter2391

    2 жыл бұрын

    Very helpful. Watching from Malawi. Africa

  • @liakat26

    @liakat26

    2 жыл бұрын

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

  • @amitpoonia1123

    @amitpoonia1123

    2 жыл бұрын

    Thank u alot without wasting even a second..

  • @iZacq

    @iZacq

    Ай бұрын

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

  • @wasiqfaiz
    @wasiqfaiz3 жыл бұрын

    thank you for explaining too quickly without any wastage of time

  • @Excelrush

    @Excelrush

    3 жыл бұрын

    Glad it helped! Do subscribe to the channel

  • @thanhtando

    @thanhtando

    3 жыл бұрын

    still not quick enough

  • @faizkhan-dj9ti

    @faizkhan-dj9ti

    Жыл бұрын

    True

  • @shilpamanchanda8421

    @shilpamanchanda8421

    8 ай бұрын

    Yes ty fr quick short vid

  • @azeryndernebel1554
    @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
    @IngridTID3 жыл бұрын

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

  • @jaindia1661
    @jaindia16615 жыл бұрын

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

  • @1991MUJO
    @1991MUJO4 жыл бұрын

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

  • @miloufromsaigon
    @miloufromsaigon3 жыл бұрын

    Mr.Indian-man saves our lives again

  • @amitabhabhattacharya4051
    @amitabhabhattacharya40516 ай бұрын

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

  • @renitalake3580
    @renitalake35803 жыл бұрын

    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~

  • @JC-ok4yx
    @JC-ok4yx4 жыл бұрын

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

  • @user-eg5sm3jt3x
    @user-eg5sm3jt3x10 ай бұрын

    Ur a genius! Everyone knows how to do the bloody first row! You have explained the next few rows!

  • @ayeaye436
    @ayeaye436 Жыл бұрын

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

  • @shreyaghoshaluniverse
    @shreyaghoshaluniverse3 жыл бұрын

    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.2985
    @g.r.29855 жыл бұрын

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

  • @CassandraLegge
    @CassandraLegge Жыл бұрын

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

  • @nesco713
    @nesco713 Жыл бұрын

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

  • @jyotiyadav810
    @jyotiyadav8102 жыл бұрын

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

  • @mrCetus
    @mrCetus2 жыл бұрын

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

  • @souviknaskar2934
    @souviknaskar29342 жыл бұрын

    Usually I do not “ Like “ KZread video whereas the Mentors say unnecessary talks and ask Like, Share and Subscribe the channel in the beginning of the video. I liked your video very much what you did is you came to the topic in 10 seconds since started the video. You didn’t let my time waste and you have provided the exact accurate content I expected. As my observation you deserve 10/10 in this topic. Who waste my time with highlighting channel, talk out of the topic instead of staring the topic. I directly give them “ 👎🏼“ first then I start listening to them. My time is so valuable. Even they provide right solutions at the end but let my time waste very beginning, how relevant the video is, I don’t care. Nice to meet you! I will subscribe your channel.

  • @Excelrush

    @Excelrush

    2 жыл бұрын

    Thank you so much for the kind words!

  • @dr.muhammadafnantalib5941
    @dr.muhammadafnantalib59412 жыл бұрын

    Short, comprehensive and beautifully explained.

  • @svetlanazoubkova5554
    @svetlanazoubkova55543 жыл бұрын

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

  • @neeki4eva
    @neeki4eva4 жыл бұрын

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

  • @mattenright7641
    @mattenright7641 Жыл бұрын

    I've worked professionally in production for over a decade and never knew this. Thank you.

  • @mwhite7844
    @mwhite78443 жыл бұрын

    !!!!!!!!!!!!!!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!!!!

  • @navneetsaini6698
    @navneetsaini66984 жыл бұрын

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

  • @louiseb189
    @louiseb1893 жыл бұрын

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

  • @starmazaheri7448
    @starmazaheri74482 жыл бұрын

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

  • @fpost337
    @fpost3372 жыл бұрын

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

  • @marisarobertsonphysics980
    @marisarobertsonphysics9804 жыл бұрын

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

  • @prachandrakayastha4556
    @prachandrakayastha45565 жыл бұрын

    Thank you sir ! Respect from Himalayan Kingdom of Nepal

  • @adreuter
    @adreuter Жыл бұрын

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

  • @Will_-it3mh
    @Will_-it3mh4 ай бұрын

    it's always the indian guys that have the best tutorials. thx man u the goat

  • @ayeshasiddiqua4351
    @ayeshasiddiqua43515 жыл бұрын

    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
    @Capataro5 жыл бұрын

    Thank you, great, quick and easy explanation!

  • @helpingindians3289
    @helpingindians328910 күн бұрын

    good explanation without wasting time thank you

  • @iplanes1
    @iplanes124 күн бұрын

    Excellent presentation style - all content, no waffle

  • @amandamishellesalcedo3626
    @amandamishellesalcedo36264 жыл бұрын

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

  • @zigzagg6697
    @zigzagg66972 жыл бұрын

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

  • @AllInOne-jg5qx
    @AllInOne-jg5qx Жыл бұрын

    I wonder why I found this video is on second in KZread 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.

  • @tonyrodriguez2003
    @tonyrodriguez2003Ай бұрын

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

  • @the_salahcar
    @the_salahcar5 жыл бұрын

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

  • @tejaannepu439
    @tejaannepu4396 жыл бұрын

    THANKS FOR THE CLEAR EXPLANATION

  • @ben-uy1ud
    @ben-uy1ud Жыл бұрын

    NEVER KNEW IT WAS SO EASY .....THANK YOU !!

  • @ajay-s1i1n8g9h
    @ajay-s1i1n8g9h Жыл бұрын

    Bahut bahut shukriya bhai ji Preshan ho gaya tha Itni sari videos dekh ke

  • @Excelrush

    @Excelrush

    Жыл бұрын

    Do subscribe to the channel!

  • @ajay-s1i1n8g9h

    @ajay-s1i1n8g9h

    Жыл бұрын

    @@Excelrush 👍👍👍👍👍

  • @georgia2354
    @georgia23543 жыл бұрын

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

  • @JahangirAlam-bl1fx
    @JahangirAlam-bl1fx5 жыл бұрын

    Very nice. It was helpfull to me. Thanks

  • @yadunandan9287
    @yadunandan92872 жыл бұрын

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

  • @InstrumentalKINGblog
    @InstrumentalKINGblog Жыл бұрын

    been struggling with this for years, who knew I could learn this feature in minutes! thank you bhai!

  • @shannonpotato7604
    @shannonpotato76042 жыл бұрын

    This made me go "Ohhhhhhhhh" enthusiastically when I did it on my file. XD Thank you for your help!

  • @DinianaVarca522
    @DinianaVarca5222 жыл бұрын

    THIS IS THE EXPLANATION THAT I'M LOOKING FOR, NO COMMERCIALS JUST DIRECT TO THE POINT! IF I COULD GIVE YOU 100 LIKES I DID IT ALREADY!

  • @Excelrush

    @Excelrush

    2 жыл бұрын

    Thank you!! Appreciate

  • @kareljenis
    @kareljenis2 жыл бұрын

    Finally after years of struggling...thanks a lot

  • @edsonr.2017
    @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 :)

  • @army1157kit
    @army1157kit6 ай бұрын

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

  • @nisa6361
    @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)

  • @rob_fig
    @rob_fig7 ай бұрын

    Perfect explanation for years of frustration. Thank you!

  • @savi3sounds
    @savi3sounds2 жыл бұрын

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

  • @johnchrys5716
    @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%

  • @josequispe8241
    @josequispe82416 ай бұрын

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

  • @martinfernandez882
    @martinfernandez882 Жыл бұрын

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

  • @benjaminnelson1014
    @benjaminnelson101420 күн бұрын

    What a legend. Thank you, sir!

  • @ToddBeal
    @ToddBeal Жыл бұрын

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

  • @teamrush42
    @teamrush422 жыл бұрын

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

  • @priyankaranjan3983
    @priyankaranjan39833 жыл бұрын

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

  • @stefaniemorris5187
    @stefaniemorris51873 жыл бұрын

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

  • @user-hr4ti8me5y
    @user-hr4ti8me5y4 ай бұрын

    This is how a video explanation shud be. Thanku so much❤❤

  • @baijayantasenchowdhury9806
    @baijayantasenchowdhury98062 жыл бұрын

    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.

  • @vasangelis
    @vasangelis Жыл бұрын

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

  • @charlesbrown9027
    @charlesbrown90276 ай бұрын

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

  • @stormyweather7200
    @stormyweather72002 жыл бұрын

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

  • @fifaham
    @fifaham2 жыл бұрын

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

  • @abhishekg5167
    @abhishekg51673 жыл бұрын

    This video deserves a billion views and likes.

  • @windproductreviews
    @windproductreviews3 жыл бұрын

    I spent way too much time trying to figure this out on my own. thanks!

  • @muhammadayaz7288
    @muhammadayaz72887 ай бұрын

    ❤❤❤❤ Very informative Brother last one year I tried but today I found the solution

  • @bholster8073
    @bholster80732 жыл бұрын

    in 30 seconds you solved my problem.. thank you.

  • @pemberlycottage
    @pemberlycottage2 жыл бұрын

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

  • @iQamarAmerica
    @iQamarAmerica Жыл бұрын

    I learn something new today. Thank you so much quick clear learning video. Short and sweet tracing keep making more video keep rocking.

  • @bajer111
    @bajer1112 жыл бұрын

    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!

  • @jeetenpathak5016
    @jeetenpathak50164 ай бұрын

    Superb explained in a shortest way🎉

  • @danny2131
    @danny21312 жыл бұрын

    Finally a explanation right to the point thank you

  • @nataliekimani699
    @nataliekimani699Ай бұрын

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

  • @ratanasath6704
    @ratanasath67042 жыл бұрын

    OMG! Love this. Your video is short and straightforward.

  • @ameedaammu23
    @ameedaammu232 ай бұрын

    Thank you so much for explaining very quickly..

  • @asgaraliize
    @asgaraliize2 жыл бұрын

    Thanks for explaining in detail without wasting time it is really useful

  • @hanakambay4958
    @hanakambay49582 ай бұрын

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

  • @grecar11
    @grecar11 Жыл бұрын

    Genius! I wish I had found this sooner. THANK YOU!

  • @sazharper8768
    @sazharper8768 Жыл бұрын

    THANK YOU! I read loads online and just could not get the row and column to freeze… I watch your video, try it, et voila !!! 👍 cheers!!

  • @LoneWolfieee
    @LoneWolfieee Жыл бұрын

    Thank you omgosh. I was Suffering in work trying to make spreadsheet and that helped so much. Back to work I go haha

  • @maximumpotential3796
    @maximumpotential3796 Жыл бұрын

    Thankyou. I can now increase my productivity at work and decrease chance of errors. 👍👍

  • @CookwitchCreations
    @CookwitchCreations2 жыл бұрын

    THANK YOU SO MUCH. Simple once you know, but infuriating when you don't!

  • @SG-dd9wd
    @SG-dd9wd4 ай бұрын

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

  • @timoteosuello8929
    @timoteosuello8929 Жыл бұрын

    Other videos takes longer time to explain, yours is very fast and easy. Very helpful. Thank you so much.

  • @marandadavis2440
    @marandadavis24402 жыл бұрын

    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!

  • @Laura-zx9mp
    @Laura-zx9mp2 жыл бұрын

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

  • @CaptMdFaizurRahman
    @CaptMdFaizurRahman2 жыл бұрын

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

  • @sarahs1212
    @sarahs12122 жыл бұрын

    So fast and simple, thank you.

  • @jessicamergen1954
    @jessicamergen1954Ай бұрын

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

  • @apurvatiwari6412
    @apurvatiwari6412 Жыл бұрын

    Thanks you are last minute Savior. keep on uploading this type of short video

  • @fairness3840
    @fairness38404 ай бұрын

    Knowledge is power! Thank you very much. Namastey😉

  • @arjiecanillo8929
    @arjiecanillo89296 ай бұрын

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

  • @pokcay
    @pokcay2 жыл бұрын

    Jesus Christ, i was 30 years old when i discover this. Thank you!