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 :)
@trumpexcel
Жыл бұрын
Thank you so much for the kind words. Glad you found the video useful 🙂
@tanveerahmed5747
5 жыл бұрын
Superb video, I logged in to KZitem 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!
@simbarashenindi2233
4 жыл бұрын
Wow... clear and straight to the point. You are undisputedly one of the world's best. Hats off to you
@ab500a2
2 жыл бұрын
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!!
@Aggiemayson
3 жыл бұрын
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!
@UncleAL2006
4 жыл бұрын
Clear and concise - others just seem to babble on and on. Thank you for making this so clear.
@hillaryjones3106
4 жыл бұрын
I like that you quickly go over the concept within excel as well as the steps. Thank you!
@ernestchieke900
3 жыл бұрын
You are a great tutor. I now understand the concept of Locked and protected cell. Thank you.
@templeexecutivecoaching7384
4 жыл бұрын
This tutorial was created two years ago, and it's still awesome!
@kingsleyemeka2136
4 жыл бұрын
Sir, God bless you... You're truly a wonderful teacher... Your explanation are very clear...
@user-wq2cg8su8p
5 жыл бұрын
love the tip about selecting all formulas, you saved me a coffee break :-)
@yusubali1116
2 жыл бұрын
Very clearly spoken and easily understandable. Thanks.
@SimonPedersen1
Жыл бұрын
Spot on. Very useful. Clear and concise language. Many thanks!
@lilibeth.llamadoavena6088
2 күн бұрын
well explained. Thank you.
@attiarauf9383
4 жыл бұрын
Overall your way of teaching is very nice
@sowmyasankar4471
3 жыл бұрын
You are a great teacher. Very useful video
@billowabdi6346
5 жыл бұрын
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.
@mohammedyusuf4358
3 жыл бұрын
I really liked the way you explained in a very simple manner... Very helpful
@DorothyGaleRoofingGroup
5 жыл бұрын
Your a beast! Thanks, this just saved me tons of re-occurring work with finding and selecting cells with formulas.
@trumpexcel
5 жыл бұрын
Glad you found it useful!
@nevilgunatunga
Жыл бұрын
it was very clear to understand. thanks to the publisher.
@pmarie25
2 жыл бұрын
Thank you !! I’m tired of other co-workers changing shared reports!
@jaylehyeh2441
2 жыл бұрын
Best video of all time
@Shannonishere
3 жыл бұрын
Just what I was looking for. Thank you!!!
@Abqscanner
3 жыл бұрын
Great video! Thank you for explaining it so clearly! Appreciate the tip to select all cells with formulas. Saved me a ton of time!
@ryanlalonde4895
3 жыл бұрын
Very concise description of the feature, thank you!
@PaulCecchettiMusic1
3 жыл бұрын
So helpful- quick and to the point. Thanks!
@neruismite
2 жыл бұрын
I have been looking of this since long. Amazing Explanation. Keep the good work
@abhijitnayak9408
2 жыл бұрын
It's truly informative & very easy to understand
@chalkie247
2 жыл бұрын
I found this video VERY useful...thank you very much!
@gyanendrapradhan9823
Жыл бұрын
This was exactly what I was looking for...thanks a ton
@MonkeyPuzzlePWADTeam
7 ай бұрын
Great explanation, thank you!
@trumpexcel
7 ай бұрын
Glad you found it useful!
@hmroque4382
2 жыл бұрын
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.
@jju2131
4 жыл бұрын
Thank you very well explained.
@sunlifescarletemerald6319
5 жыл бұрын
Excellent video sir, thank you so much. Clear and thorough.
@c1zacc324
7 жыл бұрын
Thank you so much for this! Super clear and very helpful! Love the short handcuts!!!
@dpkoli
3 жыл бұрын
Very simple but very usefull. Thanks a lot.
@christophergill9239
Жыл бұрын
GREAT VIDEO!!!!!!
@trumpexcel
Жыл бұрын
Thanks.. Glad you found it useful :)
@jiriblazek3920
3 жыл бұрын
Exellent, just what I was looking for. Many thanks.
@DiscJokeyDarkSigns
4 жыл бұрын
Thank you for this great video!
@josiahpaul4238
5 жыл бұрын
i was doing it wrong all the while and was yelling as to why excel was so complicated lol! GREAT HELP BRUH!
@michaelmueller2949
5 жыл бұрын
Great video that allowed me to figure out what I needed to know. Thank you
@wiprovsnl
4 жыл бұрын
Wow super thank you sir it works perfectly
@ankitjbp0761
2 жыл бұрын
VERY HELPFUL THANKS
@hamzaabdirizak5646
Жыл бұрын
That’s so useful thank you 🙏
@aliav7137
3 жыл бұрын
thank a lot man this was very helpful
@mikepalmer2709
5 жыл бұрын
Very well explained, most useful, thank you
@reynald7267
3 жыл бұрын
Very Helpful to me... Thank you so much!!!!
@ProStreetFalcon1
5 жыл бұрын
It REALLY WORKED ! Thank you.
@sarahmelton6294
4 жыл бұрын
Thank you - this video was incredibly helpful!
@Saifullah-yy6ul
2 жыл бұрын
very helpful just what you need to know to the point shot and precise thank you !!
@MARWAN-ABDELFATTAH
5 жыл бұрын
Thank you for your efforts
@nicollettegyles6859
Жыл бұрын
Very helpful!
@1066sgp
Жыл бұрын
Just what I was looking for...thanks
@JohnSmithessexfiresafety
3 жыл бұрын
Brililant thankyou - well explained.
@carolopiyo2487
4 жыл бұрын
Your instruction was excellent. I finally got it!
@302maaz
7 жыл бұрын
your teaching skill is awesome
@US-mx6se
Жыл бұрын
Wonderful beyond limits👌👌👌
@lopi9560
3 жыл бұрын
Awesome! Thank you!
@LiaqatAli-bc5mv
4 жыл бұрын
Great.. Great... Great...Awesome...found what I wanted..Thanks
@DoraKage
5 жыл бұрын
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?
@mohamednoorullahyunusansar749
5 жыл бұрын
Very well explained super nice
@mc-ti5uq
2 жыл бұрын
great explanation. thank you :)
@cliffnetto
6 жыл бұрын
Simply explained, super easy to understand
@justchill2436
4 жыл бұрын
Superb Yaaaaar Thanks Yaaar Very Much Thank you Thank you Thank you
@maaritvaga9456
4 жыл бұрын
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!!
@trumpexcel
4 жыл бұрын
Thanks for commenting Maarit... Glad you found the video useful!
@sanjayshrestha1935
4 жыл бұрын
Thank you!! I was really searching for this
@donaldtait5755
7 жыл бұрын
Nice, a really clear how-to. Many thanks!
@anonymousproxy131
3 жыл бұрын
Thank you - great vid
@skipdeedon9939
3 жыл бұрын
Thanks so much!
@finalruner
5 жыл бұрын
Thank you. This video actually helped compared to the other ones. The lock property is weird
@viralvyas9946
4 жыл бұрын
nice video sir , greatly explained
@twes619
3 жыл бұрын
Thank you! Thumbs up and subbed.
@fokhrulabedin
2 жыл бұрын
Thank you!
@prashantjadhav007
5 жыл бұрын
Excellent technique. Thanks for this video
@marciawright8908
2 жыл бұрын
Thank you so much.
@hinanaz8060
4 жыл бұрын
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?????
@paultaylor2957
4 жыл бұрын
protect the sheet by using a password and they cant unprotect it unless they know the password
@jsingle76
3 жыл бұрын
This was super helpful! Thanks :)
@Pratapbrazil
6 жыл бұрын
Amazing.......deserve like.....
@judydistrito4026
2 жыл бұрын
Thank you very much
@cedricagion8249
5 жыл бұрын
Thank you. This video is very helpful.
@shubhinagpal2657
3 жыл бұрын
Very useful video for me,
@angmingzhen
3 жыл бұрын
Amazing. Thank you!
@smitamodi9632
7 жыл бұрын
Perfect explanation and very useful
@mkgvip
6 жыл бұрын
Very nice and simple way explained, Thanks!
@sggy8939
5 жыл бұрын
THANK U FOR YOUR GOOD INFORMATION
@hoteldinameugorje7326
6 жыл бұрын
Thank you, this was the best explanation I have found on youtube ;)
@angshumanchowdhury5685
4 жыл бұрын
Excellent sir 🙏🙏🙏
@jiajiaphotography
3 жыл бұрын
Thank you 😊
@paigequeenb8257
7 жыл бұрын
Perfect. This is exactly what I needed. This would have helped a lot last semester...
@shihtzufan
2 жыл бұрын
Thanks so much :)
@stanefreesolutionsptyltd2590
6 жыл бұрын
you are a champion mate thank you
@gppowis
3 жыл бұрын
Thank you.
@lindagomes94
4 жыл бұрын
Such a useful video ..so well explained !!!! Thanks a ton (y)
@ericahinwood
4 жыл бұрын
Such a great tutorial, thank you so much!!
@AbhishekThakur-uh6lc
4 жыл бұрын
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.
@skillsforchildren
2 жыл бұрын
Thanks!
@tpc2008
Жыл бұрын
Thank you so much for this! I wonder how to do the same with Google Sheet?
@jenoaj3902
3 жыл бұрын
Thanks a lot
@nirmalmaharjan1748
6 жыл бұрын
exactly what i was looking for. thanks mate
@ConstructionEntrepreneurs
5 жыл бұрын
Keep up the great work. This is exactly what I was looking for.
Пікірлер: 212