Leila I never comment on RUclips but your demos have completely changed my work and your tutorials are clear, user friendly, and you do a great job explaining complicated subjects. You are a great teacher.
I thought I was an advance Excel user until I found this channel. There are so many good tricks and the explanation and video editing is so perfect. THANK YOU
I watch your videos on things I already know how to do because you drop little gems all the time. I never thought about using CTRL A once you have done a find all to highlight all the items you found. I typically do a find and replace for most items, but when you need to change the formatting this is a game changer. Thanks again Leila!
Don't you love it when you find a video as specific as this was for your current needs? Excellent Leila, you're a life saver. Found your channel a couple of days ago and your tips and lessons have been a game changer. Thank you!
Thanks Leila. This is a great trick for in unprotecting specific cells after you've set your sheet up and is a great reminder of the power of Find! If you know ahead of time that you want to do this, I typically create a custom cell style which not only sets the background and font colours, but also the cell protection status. One can then apply that cell style whenever you would have coloured a cell yellow.
Sis, You are the best teacher for me. Because of you, I came to know excel functions, can write complex formulae, and awesome VBA codes now I am using VBA and Python for my data analysis. Honestly, you changed my life. All the best to you.
I really feel blessed that I found your channel Leila. Thank you so much for bringing such innovative ideas. Just because of you learning Excel has become my favorite hobby. Thank you so much again.
This did n't work initially for me. Then I started again from the scratch. It's working now. This is really cool!!! and would be of use in future. I can shine as an excel expert in my office with your awesome excel tips.
Your insights reveal how little of Excel I really comprehend. Have you ever came across an issue where protected sheets don't allow the A-Z filter to be used in a dataset once the sheet is protected? I did this for a group of users to protect embedded columns of cells with formulas to find that they have lost the option to filter that way so I had to remove the protection and consequently expose those columns of cells to accidental deletions or overwrites.
Hi Leila, I love your videos! I've an easier way to do this. Modify the cell format of a cell style and uncheck the locked feature from there, and use that cell style for your input variables. All the other cells will get locked apart from that. And if you ever want to lock them again, you can simply do that by modifying that cell style again.
Queen of Excel, the more I watch your excel tutorials, the more I feel I know very little in excel. Please keep up the good work. I can't wait to have another new release from u.
@@LeilaGharani Just wanted to come back after using it a few times. This has saved loads of time and fiddling around etc. Thank you so much for sharing!
This is awesome! I have a uniform ordering spread sheet that requires values to be entered in specific cells that are spread out on the worksheet skipping over descriptions, and cells containing formulas. Before I was having to use the arrow keys to move around the worksheet but with this trick I can just tab between cells that I need to edit!
Grab the file I used in the video from here 👉 pages.xelplus.com/lock-cells-color-file
Leila I never comment on RUclips but your demos have completely changed my work and your tutorials are clear, user friendly, and you do a great job explaining complicated subjects. You are a great teacher.
I thought I was an advance Excel user until I found this channel. There are so many good tricks and the explanation and video editing is so perfect.
THANK YOU
It's great to have you here. I'm glad you find the tutorials helpful.
I watch your videos on things I already know how to do because you drop little gems all the time. I never thought about using CTRL A once you have done a find all to highlight all the items you found. I typically do a find and replace for most items, but when you need to change the formatting this is a game changer. Thanks again Leila!
Never done this before. Creative way of using Find to solve this efficiently.
It's all about efficiency :)
Wow! Cool combination of tricks, Teammate : )
Thanks Mike. Looking forward to your tips series.
Don't you love it when you find a video as specific as this was for your current needs? Excellent Leila, you're a life saver. Found your channel a couple of days ago and your tips and lessons have been a game changer. Thank you!
Glad it was helpful Javier!
You're always amazing me. Hands down Queen of Excel.
:) Glad you like it Wesley.
@@LeilaGharani Hello Leila, how I can protect excel several worksheets (Not all of them) as userinterfaceonly
Such a fantastic person you are . You truly amazing making learning so easy
I'm very happy to hear that.
You are the best!. So easy to follow. The way you speak and explain it, spot on!
Thank you for the kind words! Glad you like it.
Thanks Leila. This is a great trick for in unprotecting specific cells after you've set your sheet up and is a great reminder of the power of Find! If you know ahead of time that you want to do this, I typically create a custom cell style which not only sets the background and font colours, but also the cell protection status. One can then apply that cell style whenever you would have coloured a cell yellow.
That's a great solution too. Many thanks for the input Jason!
Sis, You are the best teacher for me. Because of you, I came to know excel functions, can write complex formulae, and awesome VBA codes now I am using VBA and Python for my data analysis. Honestly, you changed my life. All the best to you.
I really feel blessed that I found your channel Leila. Thank you so much for bringing such innovative ideas. Just because of you learning Excel has become my favorite hobby. Thank you so much again.
You are so welcome!
This woman is not only beautiful but very very smart, great vid, It will help me fill out my forms very fast with my macro, thank you
its so easy, which am not aware till date.. wow learning so easily..
Your videos provide complete information (all small hints & tipps) and that makes them very valuable!
Wow so simple yet so effective
Thank you Leila. I learn more from you than any other source. Thank you 🙏
This did n't work initially for me. Then I started again from the scratch. It's working now. This is really cool!!! and would be of use in future. I can shine as an excel expert in my office with your awesome excel tips.
Shine away! :)
Your insights reveal how little of Excel I really comprehend. Have you ever came across an issue where protected sheets don't allow the A-Z filter to be used in a dataset once the sheet is protected? I did this for a group of users to protect embedded columns of cells with formulas to find that they have lost the option to filter that way so I had to remove the protection and consequently expose those columns of cells to accidental deletions or overwrites.
So simple and effective...Thanks!
Simplicity is a virtue :)
You are amazing Leila...hatsoff
Fantastic way of explaining. Thanks
You are the only who explain it very well! Thanks
You are a great teacher, you drive me crazy to fall in love with excel.
I liked the application of this concept used here with yellow cells, well put
Glad you like the little twist.
Thank you for this tip! I create tools where others can only edit yellow cells. This will save me a lot of time!
Excellent. I'm glad to hear that.
3:50 mindblown! 🧠🤯Years of using Excel, missed that little gem💪
Glad you found something useful!
Hi Leila, I love your videos!
I've an easier way to do this. Modify the cell format of a cell style and uncheck the locked feature from there, and use that cell style for your input variables. All the other cells will get locked apart from that. And if you ever want to lock them again, you can simply do that by modifying that cell style again.
Nice solution!
You have a great ability to articulate. I like way you explain.
that was brilliant! Using for your purposes functionalities that were really designed to do something else is boss.
Your techniques are amazing, learnt a lot from your videos, Thanks Leila
You are in a different level thank you
Mam thank you very much for your support i was very much difficult to implement this. Now I can do this. Thank you ❤️❤️
Awesome ! You have a way …. Such simple and easy way of teaching… God bless
Great.. whenever I see your video I learning something new.. thanks.
As usual, you are the best of the best!!!
Glad you like it!
Thank you for this knowledge. Please teach us to how to protect multiple sheets at once. Thank you
I can think of few other methods, but I like yours better
Queen of Excel, the more I watch your excel tutorials, the more I feel I know very little in excel. Please keep up the good work. I can't wait to have another new release from u.
Thanks for the kind words Eric. New video coming up very soon. Not about Excel but I hope you'll still like it.
Excellent video using Find. I have added a lock/unlock shortcut to my QAT - saves having to press Ctrl+1
Love it! Thanks 😊
Thanks and Love from Afghanistan...
Queen of Excel. truly excellent.
:) Glad you like it.
This lady is a BEAST, truly easy way to teach and share all this great shorcuts/knowledge
I'm happy you like my BEAST mode Rigoberto :)
One can expect surely something new and different to learn from your post always...thanks...
I'm glad you like the little twist.
Your explanation is very clear. Glad I'd found this channel. Thank you Leila 😊😊
My pleasure. Glad to have you here :)
You are such a brilliant, lots of love from Dubai
Awesome tip...you have been really helpful.
Wow.. Everytime I watched I get simple n useful excel trick..
Thanks
Glad to hear that
Very useful video,
You make me perfect by your every lectures, love you mam...
Very happy it's helpful!
You're the best Ms Gharani !
Your videos are well done and very usefull. Thank you Leila!
You're very welcome!
Thanks for the explanation
Man Using Excel for ages and that trick was just brilliant.. !
Glad you like it :)
Brilliant! I’m smarter for having watched it.
Excellent tip!!!
Thanks a lot for making learning excel so much fun.
What a fascinating skill !!!
So easy and so useful. Thanks Leila.
My pleasure Hélène. Glad you like it.
Short and nice video! Thanks!
Glad you like it.
That is a very neat trick. Will definitely use this, to think i have been doing it the long way for so long! Thank you.
Glad it was helpful Steven!
@@LeilaGharani Just wanted to come back after using it a few times. This has saved loads of time and fiddling around etc. Thank you so much for sharing!
Big fan. You are doing a great service to the business world by uploading these videos. Keep up the good work.
Thanks, will do!
You never failed to amaze me. Thanks for sharing
My pleasure Maria. Glad you like the video.
thank you
Att, Gledson Programador Excel VBA
My pleasure.
Tips are great. Worthy subscribing this channel.
Welcome aboard!
This is awesome! I have a uniform ordering spread sheet that requires values to be entered in specific cells that are spread out on the worksheet skipping over descriptions, and cells containing formulas. Before I was having to use the arrow keys to move around the worksheet but with this trick I can just tab between cells that I need to edit!
That's great Eric. That's exactly an application where this can be helpful.
You are a TREASURE, Leila
Thank You
Superb technique Leila, love this find by color pattern ..thanks for sharing valuable contents...keep sharing..you rocks !
My pleasure. Glad you find the tutorial helpful.
Very useful. I have been wondering how to do that for a long time. Thanks Leila.
My pleasure. Glad it's helpful Peter.
Can't think of a simpler way..anyone can make things complex but when you find solutions in simplicity we have an expert!
Amazing, I took your excel course online and it's one of the best course I've ever had!
Wow, thanks! Glad you like the course!
I've used this for formatting before, bit never thought to use it to protect cells, genius!
Glad you like it Christopher.
Thanks, it's an essential tutorial.
Something new to learn… Thanks, Leila.
You're very welcome Luís.
Thanks i tried this many times now i can fo it with your clear explanation thank you again
Very useful video. Thanks Leila.
My pleasure Luciano. Glad you find the tutorial useful.
Hi Leila, Deeply appreciated, Nice video
Glad it was helpful Amir!
Very useful keys shared. Thanks
I learned a lot from you.thank you so much.
You are so welcome, Joseph!
This video was really good 👌 Thanks and keep on sharing! Bought a course in udemy.
Me too
Great! Thanks for your support.
Hi 👋 Leila It was really helpful and the way you illustrate with simple examples which are easy to grasp is really amazing Keep the good work going
You're so welcome!
Very Useful , thanks
Nice one. I use locked cells a lot. Now it will be much faster!
Great! I'm happy it's helpful Erica.
Love all videos made by you! Thank you very much.
I'm happy to hear that :)
I'm happy to hear that :)
Hey I like the way u teach step by step it helps me learn more things for my daily needs excel activity
Glad to hear that
Awesome! Perfect timing as i'm currently building similar worksheet. This will save me a lot of time! Tqvm!
Great! Glad the tutorial is helpful.
Creative and beautiful Queen of Excel. Thank you
My pleasure. Glad you like it.
Wow!! Amazing!! And love your voice too! Thanks and it is very useful!!
I'm glad to hear that :)
This is Great! Thanks Leila
My pleasure Karen.
Excellent tip and video tutorial Leila, Thank you so much
My pleasure Wayne. Glad you like the video.
Hi mam - Easy and very understanding explain ation
Wow! Mam you are genius 🙏
It's s an easy way. Thank you very much.
My pleasure. Glad you like it.
Ingenious solution!
I'm glad you like it.
*Amazing lesson Leila*
*Thanks for sharing*
*Ontime Edu* 👌👌🙌
You're very welcome. Glad you like the video.
You are amazing! I’m your fan
Wow! Never had the idea of this trick. Thank you very much.
My pleasure. Glad you like the little twist.
I love this lesson
Wow. That is a magical trick...