I've used Excel for years at a basic level but have never heard a clearer, better explanation than this about locking cells. I've constantly wondered why, if I have to lock the cell to protect it, the box was already ticked when I went to format. Now I finally understand and you've saved me so much confusion. Thank you so much for taking the time to make this video - I've subscribed as I know I'll learn far more from you as time goes on :)
Superb video, I logged in to UA-cam again just to like this video. the unique thing about you is you stick to the point unlike beating about the bush as others. Thank you very much!
OMG, Thank you, thank you, thank you!!!!! I have been trying to figure out how to do this for MONTHS!! Couldn't find any useful videos or tutorials and then I just happen to come across your video and you explain it so perfectly!! Thank you so so so so much!!
the select-all-corner-arrow was one of the most useful tools I ever learned. You can do so much with it. I'm suuuuper glad someone has made a video using that tool. Excellent!
Thank you for a clear step by step instruction. Just a question: what if I want to insert a row between protected cells. For example, it is a list of resale items and I need to add a new item? Do I unprotect all first and redo protection all over again.
Thanks so much. I like your method of teaching especially how you explain concepts. I always feel bad when I don't find my search from among your videos. Kudos and keep on with the great work.
THANK YOU SO MUCH FOR REALLY INFORMATIVE VIDEO.. I HAVE ONE QUESTION. WHEN WE WILL GIVE THIS SHEET TO ANYBODY ELSE HE OR SHE CAN UNPROTECT THE SHEET?????
thank you for the info. it really helped. im just dissapointed at how user unfriendly the whole process is. i mean, uncheck a checkbox (labeled "lock") to lock a cell instead of the other way around? what the hell?
This trick is so helpfull...plz tell me one more thing...whenever i want to unprotect the sheet... By just one click on unprotect sheet it opens...i want passwrd evrytime,whenever i want to unprotect the sheet.
I've used Excel for years at a basic level but have never heard a clearer, better explanation than this about locking cells. I've constantly wondered why, if I have to lock the cell to protect it, the box was already ticked when I went to format. Now I finally understand and you've saved me so much confusion. Thank you so much for taking the time to make this video - I've subscribed as I know I'll learn far more from you as time goes on :)
Thank you so much for the kind words. Glad you found the video useful 🙂
Wow... clear and straight to the point. You are undisputedly one of the world's best. Hats off to you
Superb video, I logged in to UA-cam again just to like this video.
the unique thing about you is you stick to the point unlike beating about the bush as others.
Thank you very much!
OMG, Thank you, thank you, thank you!!!!! I have been trying to figure out how to do this for MONTHS!! Couldn't find any useful videos or tutorials and then I just happen to come across your video and you explain it so perfectly!! Thank you so so so so much!!
Clear and concise - others just seem to babble on and on. Thank you for making this so clear.
the select-all-corner-arrow was one of the most useful tools I ever learned. You can do so much with it. I'm suuuuper glad someone has made a video using that tool. Excellent!
You are a great tutor. I now understand the concept of Locked and protected cell. Thank you.
well explained. Thank you.
Overall your way of teaching is very nice
Very clearly spoken and easily understandable. Thanks.
Sir, God bless you...
You're truly a wonderful teacher... Your explanation are very clear...
Wow super thank you sir it works perfectly
You are a great teacher. Very useful video
This tutorial was created two years ago, and it's still awesome!
love the tip about selecting all formulas, you saved me a coffee break :-)
GREAT VIDEO!!!!!!
Thanks.. Glad you found it useful :)
Spot on. Very useful. Clear and concise language. Many thanks!
I like that you quickly go over the concept within excel as well as the steps. Thank you!
Superb Yaaaaar Thanks Yaaar Very Much Thank you Thank you Thank you
Thank you very well explained.
Best video of all time
it was very clear to understand. thanks to the publisher.
That’s so useful thank you 🙏
thank a lot man this was very helpful
I really liked the way you explained in a very simple manner... Very helpful
Thank you for a clear step by step instruction. Just a question: what if I want to insert a row between protected cells. For example, it is a list of resale items and I need to add a new item? Do I unprotect all first and redo protection all over again.
Brililant thankyou - well explained.
Thank you !! I’m tired of other co-workers changing shared reports!
Great explanation, thank you!
Glad you found it useful!
Just what I was looking for. Thank you!!!
VERY HELPFUL THANKS
Awesome! Thank you!
Very concise description of the feature, thank you!
Wonderful beyond limits👌👌👌
Very helpful!
Your a beast! Thanks, this just saved me tons of re-occurring work with finding and selecting cells with formulas.
Glad you found it useful!
nice video sir , greatly explained
It's truly informative & very easy to understand
So helpful- quick and to the point. Thanks!
Excellent video sir, thank you so much. Clear and thorough.
I have been looking of this since long. Amazing Explanation. Keep the good work
great explanation. thank you :)
Thank you - great vid
I found this video VERY useful...thank you very much!
This was exactly what I was looking for...thanks a ton
Thank you! Thumbs up and subbed.
Thanks so much. I like your method of teaching especially how you explain concepts. I always feel bad when I don't find my search from among your videos. Kudos and keep on with the great work.
Thank you for this great video!
Great video that allowed me to figure out what I needed to know. Thank you
Very simple but very usefull. Thanks a lot.
Thanks so much!
Exellent, just what I was looking for. Many thanks.
Great.. Great... Great...Awesome...found what I wanted..Thanks
Thank you!
Very Helpful to me... Thank you so much!!!!
Very useful video for me,
Thank you so much.
Very well explained super nice
Great video! Thank you for explaining it so clearly! Appreciate the tip to select all cells with formulas. Saved me a ton of time!
Thank you - this video was incredibly helpful!
Just what I was looking for...thanks
Very well explained, most useful, thank you
very helpful just what you need to know to the point shot and precise thank you !!
super thanks sir
It REALLY WORKED ! Thank you.
Your instruction was excellent. I finally got it!
Excellent sir 🙏🙏🙏
Thank you very much
Thank you for your efforts
Thank You so much for your very helpful videos. I have been able to perform my work swiftly and accurately as a result. Deepest Thanks!!
Thanks for commenting Maarit... Glad you found the video useful!
i was doing it wrong all the while and was yelling as to why excel was so complicated lol!
GREAT HELP BRUH!
Thank you so much for this! I wonder how to do the same with Google Sheet?
Thanks so much :)
THANK YOU SO MUCH FOR REALLY INFORMATIVE VIDEO.. I HAVE ONE QUESTION. WHEN WE WILL GIVE THIS SHEET TO ANYBODY ELSE HE OR SHE CAN UNPROTECT THE SHEET?????
protect the sheet by using a password and they cant unprotect it unless they know the password
Thank you 😊
Simply explained, super easy to understand
Thank u so much.. Can u pls tell me can we lock table formatting and how we can do that?
Thank you!! I was really searching for this
Excellent technique. Thanks for this video
Superb
thank you for the info. it really helped. im just dissapointed at how user unfriendly the whole process is. i mean, uncheck a checkbox (labeled "lock") to lock a cell instead of the other way around? what the hell?
Thanks!
Thank you.
Thank you so much for this! Super clear and very helpful! Love the short handcuts!!!
Brilliant.
Thanks a lot
Thank You Sir...😇👌
Amazing.......deserve like.....
Thank you. This video actually helped compared to the other ones. The lock property is weird
Thank you. This video is very helpful.
This was super helpful! Thanks :)
U are amazing guy 🥰😍
So nice sir thanks
Very nice and simple way explained, Thanks!
Amazing. Thank you!
This trick is so helpfull...plz tell me one more thing...whenever i want to unprotect the sheet... By just one click on unprotect sheet it opens...i want passwrd evrytime,whenever i want to unprotect the sheet.
THANK U FOR YOUR GOOD INFORMATION
Such a useful video ..so well explained !!!! Thanks a ton (y)
your teaching skill is awesome
you are a champion mate thank you