Тёмный
No video :(

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

Excel Rush
Подписаться 23 тыс.
Просмотров 2,3 млн
50% 1

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

Опубликовано:

 

22 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 1,4 тыс.   
@aneesmohd9641
@aneesmohd9641 3 года назад
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 3 года назад
Very helpful. Watching from Malawi. Africa
@liakat26
@liakat26 3 года назад
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 3 месяца назад
How to Freeze column on Top & on the Right side ❓️ Cant find any videos of it, is it not possible ? Please
@vasangelis
@vasangelis Год назад
I was 100% sure before even opening the RU-vid tab that there will be a guy with Indian accent who will solve my problem within a minute...😂
@wasiqfaiz
@wasiqfaiz 4 года назад
thank you for explaining too quickly without any wastage of time
@Excelrush
@Excelrush 4 года назад
Glad it helped! Do subscribe to the channel
@thanhtando
@thanhtando 4 года назад
still not quick enough
@faizkhan-dj9ti
@faizkhan-dj9ti Год назад
True
@shilpamanchanda8421
@shilpamanchanda8421 10 месяцев назад
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
@IngridTID 3 года назад
Finally, a quick short explanation without any useless fillers and wasting of time. Thank you.
@1991MUJO
@1991MUJO 4 года назад
This explanation was clear and straight to the point! Thank you. This helped me at work immensely.
@renitalake3580
@renitalake3580 3 года назад
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~
@chiamakaezeobi7565
@chiamakaezeobi7565 17 дней назад
You have no idea how useful this was. Thank you!
@jaindia1661
@jaindia1661 6 лет назад
Very clear and concise explanation. You make it sound so simple. Thank you.
@JC-ok4yx
@JC-ok4yx 4 года назад
AMAZING! I spent 20 minutes today trying to figure this out. That makes so much sense.
@shreyaghoshaluniverse
@shreyaghoshaluniverse 3 года назад
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.
@Miliex_YT
@Miliex_YT Месяц назад
Omg, this has been my biggest dilemma in freeze pane all these yrs!!! THANK YOU!!!!!!!❤❤❤
@nisa6361
@nisa6361 2 года назад
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)
@g.r.2985
@g.r.2985 5 лет назад
This was EXACTLY what I wanted to know...great video! Hello from Canada!
@stefaniemorris5187
@stefaniemorris5187 3 года назад
Looked at a bunch of things before this and only this one made sense and worked immediately. Thank you for making my day easier!
@baijayantasenchowdhury9806
@baijayantasenchowdhury9806 2 года назад
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.
@jyotiyadav810
@jyotiyadav810 2 года назад
It was exactly what I needed. Clear, simple and straight to the point. Thank you very much.
@mrCetus
@mrCetus 2 года назад
Straight to the point and perfectly explained tutorial, you're a legend!!!
@AllInOne-jg5qx
@AllInOne-jg5qx 2 года назад
I wonder why I found this video is on second in RU-vid 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.
@francisotia4370
@francisotia4370 Месяц назад
Thank you. This is the first video I checked out on this topic and it gave me exactly what I was looking for.
@svetlanazoubkova5554
@svetlanazoubkova5554 4 года назад
Was struggling for sooo long and in the end its that easy. Thank you for the clear and on-point advice! :)
@louiseb189
@louiseb189 4 года назад
God bless your soul! I almost went crazy looking for figuring this ou!
@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!
@mwhite7844
@mwhite7844 3 года назад
!!!!!!!!!!!!!!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!!!!
@marisarobertsonphysics980
@marisarobertsonphysics980 4 года назад
I did not know excel changed how to freeze panes - thank you for such a great explanation!!
@ayeshasiddiqua4351
@ayeshasiddiqua4351 5 лет назад
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
@adreuter
@adreuter Год назад
This is the easiest and straight to the point video ever. You saved me and my job.
@bajer111
@bajer111 2 года назад
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!
@navneetsaini6698
@navneetsaini6698 4 года назад
Never seen just 2 min solution explanation in just 2 minutes for the 2 hour work
@prachandrakayastha4556
@prachandrakayastha4556 5 лет назад
Thank you sir ! Respect from Himalayan Kingdom of Nepal
@jasont.greene4003
@jasont.greene4003 2 года назад
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!
@priyankaranjan3983
@priyankaranjan3983 3 года назад
Thank you for explaining in such a simple way without wasting time
@the_salahcar
@the_salahcar 5 лет назад
thank you so much sir , in just two minutes you told very important thing. thanks a lot.
@zigzagg6697
@zigzagg6697 2 года назад
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...
@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%
@ourfamilyadventure326
@ourfamilyadventure326 2 месяца назад
THANK YOU!!!!! After torturous searching on the internet, YOU EXPLAINED IT PERFECTLY AND CORRECTLY!!!! Great job!
@tejaannepu439
@tejaannepu439 6 лет назад
THANKS FOR THE CLEAR EXPLANATION
@neeki4eva
@neeki4eva 4 года назад
Amazing! Straight to the point. Very clear, exactly what I needed. Thank you
@amitabhabhattacharya4051
@amitabhabhattacharya4051 9 месяцев назад
The kind of teacher who needs to explain only once. Thanks a lot.
@teamrush42
@teamrush42 2 года назад
This is great!! Spent 15 minutes trying to figure it out and you explained it in 2!!! Thank you!!
@Capataro
@Capataro 6 лет назад
Thank you, great, quick and easy explanation!
@georgia2354
@georgia2354 3 года назад
Clear, concise, quick video, exactly what I needed! Thank you! 😁
@ayeaye436
@ayeaye436 Год назад
Thank you so much, Sir. You explained at 2 mins. I can solve it in 2 seconds.
@mattenright7641
@mattenright7641 Год назад
I've worked professionally in production for over a decade and never knew this. Thank you.
@amandamishellesalcedo3626
@amandamishellesalcedo3626 4 года назад
THIS WAS SO USEFUL THANK YOU VERY MUCHHHH!!!!
@JahangirAlam-bl1fx
@JahangirAlam-bl1fx 5 лет назад
Very nice. It was helpfull to me. Thanks
@stormyweather7200
@stormyweather7200 2 года назад
Thank you for helping countless people with their college assignments good sir. You're doing God's work
@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 :)
@tonyrodriguez2003
@tonyrodriguez2003 3 месяца назад
That is just what I was looking for. Thank you for your straight and to-the-point video.
@souviknaskar2934
@souviknaskar2934 3 года назад
Usually I do not “ Like “ RU-vid 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 3 года назад
Thank you so much for the kind words!
@army1157kit
@army1157kit 9 месяцев назад
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...
@windproductreviews
@windproductreviews 3 года назад
I spent way too much time trying to figure this out on my own. thanks!
@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!!
@PinchingPesos
@PinchingPesos Месяц назад
thank you for making this quick, painless, and simple. TWENTY THUMBS UP!
@InstrumentalKINGblog
@InstrumentalKINGblog 2 года назад
been struggling with this for years, who knew I could learn this feature in minutes! thank you bhai!
@ToddBeal
@ToddBeal Год назад
Thank you for this! I've been using Excel for years and did not know this.
@fpost337
@fpost337 2 года назад
So simple! Searching for years. Other explain for minutes some weird stuff. Thank you!
@marandadavis2440
@marandadavis2440 2 года назад
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!
@user-eg5sm3jt3x
@user-eg5sm3jt3x Год назад
Ur a genius! Everyone knows how to do the bloody first row! You have explained the next few rows!
@fifaham
@fifaham 3 года назад
We need online tutorials like yours; they are short and to the point.
@Will_-it3mh
@Will_-it3mh 7 месяцев назад
it's always the indian guys that have the best tutorials. thx man u the goat
@pemberlycottage
@pemberlycottage 2 года назад
Thanks so much for this quick and simple explanation of what to do. I truly appreciate this video for helping me out.
@josequispe8241
@josequispe8241 9 месяцев назад
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..
@dilpreetsingh1998
@dilpreetsingh1998 14 дней назад
Thank you so much sir.... I was really puzzled since a long time for this and you just explained that simple and the most important trick within seconds... Finally I know how to do it.
@ben-uy1ud
@ben-uy1ud Год назад
NEVER KNEW IT WAS SO EASY .....THANK YOU !!
@shannonpotato7604
@shannonpotato7604 2 года назад
This made me go "Ohhhhhhhhh" enthusiastically when I did it on my file. XD Thank you for your help!
@antoniaking4719
@antoniaking4719 Год назад
THANK YOU!!! I always forget how to do this! And you explained it so plainly and perfectly-it helped a lot!!!
@rob_fig
@rob_fig 10 месяцев назад
Perfect explanation for years of frustration. Thank you!
@SG-dd9wd
@SG-dd9wd 7 месяцев назад
You just solved a lifelong riddle, thank you so much!
@marifecolambo9325
@marifecolambo9325 2 года назад
Thank you for this simple explanation. I got it right away. It is helpful when I input the grades of my pupils.
@starmazaheri7448
@starmazaheri7448 2 года назад
Short and to the point. The yellow highlight really helped. Thanks a lot Sir.
@DinianaVarca522
@DinianaVarca522 2 года назад
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
@geetalikhera7913
@geetalikhera7913 Год назад
Thanks so much. I was struggling so much how to do this. Even excel help didn’t explain as well as you did
@Hombeesilu
@Hombeesilu 2 года назад
Thanks a lot 😊 for not wasting the time of others and quick solution 👍🏾👌
@martinfernandez882
@martinfernandez882 Год назад
Thank you! Simple, not drawn out, very helpful.
@mlbjr
@mlbjr Год назад
crazy helpful! thank you! exactly what i needed without the fluff.
@archinoobz2522
@archinoobz2522 2 года назад
i was using excel for first time and this helped me a lot and it was quick explanation thank you so much
@BlkTechGurla
@BlkTechGurla 2 месяца назад
Short, sweet, and so effective! Thank you! Here's your crown king. 👑
@rajmejari6563
@rajmejari6563 Месяц назад
Nothing better than such an explanation... thanks a lot
@maximumpotential3796
@maximumpotential3796 Год назад
Thankyou. I can now increase my productivity at work and decrease chance of errors. 👍👍
@timoteosuello8929
@timoteosuello8929 2 года назад
Other videos takes longer time to explain, yours is very fast and easy. Very helpful. Thank you so much.
@kareljenis
@kareljenis 2 года назад
Finally after years of struggling...thanks a lot
@jasleentoor2528
@jasleentoor2528 День назад
Thanks so much . That worked for me i was having hard time freezing middle rows .
@asgaraliize
@asgaraliize 2 года назад
Thanks for explaining in detail without wasting time it is really useful
@charlesbrown9027
@charlesbrown9027 9 месяцев назад
Explained in a simplest way.Thank you so much ,so useful
@Alok218
@Alok218 18 дней назад
What a simple explanation in a small time. Thanku
@user-hr4ti8me5y
@user-hr4ti8me5y 7 месяцев назад
This is how a video explanation shud be. Thanku so much❤❤
@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
@CS-gk2xp
@CS-gk2xp 3 года назад
Thank you sir You gave right information without wasting time
@bholster8073
@bholster8073 2 года назад
in 30 seconds you solved my problem.. thank you.
@manjotkaur5791
@manjotkaur5791 3 года назад
Thank you for solving my problem. This is very quick and easy. I had tried so many options not working. Very helpful video.
@toast5732
@toast5732 7 месяцев назад
I found the exact video I needed to complete my assignment. THANK YOU!
@nataliekimani699
@nataliekimani699 4 месяца назад
Hi! Thank you so much for the clear explanation. It was brief and you made it easy for anyone to understand. Well done!!!🎉
@privateeyety5735
@privateeyety5735 2 года назад
Clear and simple, had such a hard time finding a clear answer to this. Thank you!
@hanakambay4958
@hanakambay4958 4 месяца назад
You are Amazing, really you can explain things in a simple way
@savi3sounds
@savi3sounds 2 года назад
thank you so much for posting this. I am watching from Trinidad West Indies.
@helpingindians3289
@helpingindians3289 3 месяца назад
good explanation without wasting time thank you
@danny2131
@danny2131 2 года назад
Finally a explanation right to the point thank you
@alejandracerda2322
@alejandracerda2322 Год назад
I love your way of explaining. Clear and concise. Thanks a lot.
@muhammadayaz7288
@muhammadayaz7288 9 месяцев назад
❤❤❤❤ Very informative Brother last one year I tried but today I found the solution
Далее
Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
2:53
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
How to Freeze Panes in Excel
3:36
Просмотров 431 тыс.
Creating Easy Data Entry Forms in Excel
9:52
Просмотров 3 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19
SUPER EASY Excel Data Entry Form (NO VBA)
6:22
Просмотров 2 млн