omg! I was trying to get a tutorial on how to do this and it was so confusing! I came here, and just like that I'm all set! You just gained a new subscriber from a 5 year old video :)
@Evolve816
3 жыл бұрын
Out of the 8 videos I've watched and multiple resources on the internet, you are the only one that I've found so far that has explained this correctly. No one ever mentions the defaults within Excel, and the order of operations from most is not detailed in the best way. THANK YOU MY GOOD WISE SIR!
@askingwhy123
3 жыл бұрын
This video not only taught me exactly what I needed to know in under three minutes, it also restored some of my faith in humanity! You've got a friend in Germany!
@JessyAleppy
Жыл бұрын
I really got what exactly i am looking for! Other channels not covered the topic the way you covered in detailed manner. Love you lot 🥰😍
@ExcelCampus
Жыл бұрын
Thanks for your feedback, Manju! :)
@sklee1644
2 жыл бұрын
I watched many times, but finally I got it work for me. Thanks for sharing. I wish I could find you two years ago.
@michaelmontgomery8095
4 жыл бұрын
Worth watching. Clear, concise, good job. Thanks from Cape Town!
@alanrichardson8923
Жыл бұрын
At last! A straightforward explanation for locking and protected cells in Excel. Thanks Jon I will be back to Excel Campus again!
@mukwera9131
4 жыл бұрын
Many thanks !!! I have watched a couple of videos on this subject and yours is the only one that makes sense - the secret to unlocking this mystery was your comment, "This is a 2 step process" - Once again - thankyou. I "get it" now.
@Kunanakuyalstainde
4 жыл бұрын
I knew how to protect cells prior to seeing your video, but your explanation is the best, very simple and straight forward for anyone to pick up and run with. Kudos!
@TBeau57
Жыл бұрын
I finally got them to work after watching this video.
@ExcelCampus
Жыл бұрын
That's great, T! 😀
@syammaddukuri7016
3 жыл бұрын
thanks ..,got the real one after watching somany videos ....
@ajlong404
Жыл бұрын
This was perfect. And your microphone sounds terrific.
@azaz741
5 жыл бұрын
Thanks Jon ,for the lesson it was really useful , i will put it on practice...
@ExcelCampus
5 жыл бұрын
Thanks AZ! Happy to hear you will be putting it to good use. 🙂
@voiceInDetroit
4 жыл бұрын
great job. no wasted time. You taught me a lot in a short video.
@maryandbrianbaulkhamhills8747
3 жыл бұрын
Echo the comments below. Great presentation and easy to follow. Thanks heaps
@ketsyprophete
3 жыл бұрын
Thank you!! This video is so easy to follow and understand!
@maureendowling2183
2 жыл бұрын
Very helpful thanks
@haydeeportillo3426
2 ай бұрын
Very easily explained.
@ExcelCampus
2 ай бұрын
Thanks for your feedback! 😀
@weekender8835
4 жыл бұрын
Spot on. Clear and concise. Look forward to other videos from you.
@MsMusicalways
10 ай бұрын
Thank you!!!
@vangiehorvath2677
2 жыл бұрын
Simple and easy to follow, thank you so much.
@billchow7572
2 жыл бұрын
Clear and concise. Good
@lorieadams4828
4 жыл бұрын
Thank you for your video! This was very helpful and easy to follow and implement while watching!
@speaktruth2830
2 жыл бұрын
Hi Jon, This video was very much helpful and beautifully explained. cheers !!!
@rustynail8692
4 жыл бұрын
thanks for sharing knowledge for free.
@poonama4
Жыл бұрын
Thank you so much - it was really helpful.
@krishnamurthygp6022
Жыл бұрын
Simple n wonderfully explained.. cheers jon😊👍
@ExcelCampus
Жыл бұрын
Glad you liked it, @krishnamurthygp6022 ! 😀
@blike22
4 жыл бұрын
You're an absolute legend. Thanks champ.
@ExcelCampus
4 жыл бұрын
No problem, blike22! 👍
@russelllarge2091
3 жыл бұрын
Very useful and could follow easy. Thanks
@tesfayedesalegn5340
3 жыл бұрын
Thank you.
@kangtri3683
3 жыл бұрын
Thank You...
@supersql8406
3 жыл бұрын
Exactly what I was looking for!! Thx u!!
@letstalkaboutoccupationalh8764
Жыл бұрын
Thanks for sharing
@ExcelCampus
Жыл бұрын
Thanks for watching! 😀
@SamBeast596
3 жыл бұрын
Thanks from Purdue!
@sairarcher
3 жыл бұрын
Good piece of information! Very helpful.
@viveksharma9560
4 жыл бұрын
Excellent explained
@nephneph1869
2 жыл бұрын
Thank you so much.. this is very informative. Will subscribe.
@dardangjoshi6283
3 жыл бұрын
Very helpful. Thank you!
@layengphan3634
2 жыл бұрын
Clear instructions and certain of great help !
@narayanmhaskar
3 жыл бұрын
EXCELLENT AND VERY USEFUL
@jocelynberlin957
3 жыл бұрын
Thank you... it help me a lot
@mohammadalali6546
3 жыл бұрын
really amazing, simple, brief, and effective explanation, just a question, any videos for the most important uses?
@PokerFather04
3 жыл бұрын
always great explanations! and examples! you, sir...are my hero! :)
@drsteele4749
5 жыл бұрын
Thanks, Jon. Good info. Long ago I put the QAT below the ribbon, where it displays slicker and many more icons than will fit up top.
@wayneedmondson1065
5 жыл бұрын
Hi Jon.. thanks for the great review on Lock and Protect. Always insightful and useful tips from your channel. Thumbs up!
@ororos772
2 жыл бұрын
Thanks for the tips
@jesin100
3 жыл бұрын
Hello John, thanks for putting this video across, really helpful. But I do have a small question. How can one apply a filter to a table that has few columns locked in it. Is there a way to do it? Looking forward to your reponse.
@rickkeev4919
5 жыл бұрын
Jon, another good video. I would remind folks to not lose their password as the warning states. Additionally, I would have also include the Go To special process to select all formula cells at 1 time to protect.
@yulinliu850
5 жыл бұрын
Very helpful tips! Thanks!
@mikevanwyngaardt3852
4 жыл бұрын
Very user friendly, thank you
@bijuc.h4371
4 жыл бұрын
thanks, simple explanation done
@alexandramerino9793
6 ай бұрын
You are awesome!🎉
@ExcelCampus
6 ай бұрын
Thanks, Alex! 😀
@bestscenes1469
5 жыл бұрын
I just Love your vids. Thanks
@avinashattri9494
2 ай бұрын
Thank you 💯💯
@russelvarias2369
3 жыл бұрын
thank you so much for this
@BeauKnowsMultifamily
4 жыл бұрын
bad ass, love this feature.
@richardamey9947
5 жыл бұрын
Really useful; thanks for sharing.
@rajamanikamr4779
5 жыл бұрын
I like very much for your all interesting lessons
@crz6591
4 жыл бұрын
Wow, thank you so much for this...
@aqibishfaq1313
5 жыл бұрын
Very helpful video thanks for sharing your knowledge
@steelhub1306
4 жыл бұрын
thank you very much
@unitedworldcare9497
4 жыл бұрын
Thank you Sir
@pottiepotgieter1592
2 жыл бұрын
Is there a way to protect a cell but allow people to use only a drop down list from that cell?
@icequeenvanilla
5 жыл бұрын
Tnx for video ☺️
@samipiyash9322
5 жыл бұрын
Good tutorial
@ExcelCampus
5 жыл бұрын
Thanks Sami! 🙂
@bOyal1000
4 жыл бұрын
Thanks
@jtweber33
2 жыл бұрын
Your videos are always very thorough, and so well explained. Thank you for your work! I do have a specific scenario that wanted to see if you have a solution for: on a co-authored shared file, I would like to customize protection options for specific users. I have a shared file where I want everyone to be able to edit the specified unlocked cells, but only allow specific users to filter or sort the data. Or, if possible, I want to only allow specific users to filter & sort when they're in private view and not in the default view. If you have a solution for that scenario that would be much appreciated!
@nitinc2373
11 ай бұрын
I have an Excelsheet,In this the Range is ("A1:G10"),I want when I Edit in cell A4 that cell should be locked for Editing & Deleting,but the user can edit in B4, after eding in B4 this cell should be locked for Editing & deleting and so on,how to do this.?
@adisuissa6067
Жыл бұрын
Hey, this video was super helpful, one question if anyone can help. after locking the cells and protecting the sheet if i want to search (ctrl F) for a company in the spreadsheet it wont let me find the company becasue the formulated cells is there a way around this? Appreciate it!
@mikeknopfler2928
4 жыл бұрын
clear as a bell
@ojomichael6213
2 жыл бұрын
Very good lessons thanks!! But if the content is copy to a new sheets are the cell still locked.?
@madhavdamani9799
2 жыл бұрын
No. If you copy it in a separate tab, one would be able to see all the locked and hidden cells as well. Not sure if there is any trick to take care of this drawback.
@johnadams5586
5 жыл бұрын
Thank you Jon very much :(
@chinabono8995
5 жыл бұрын
Very good!!!
@f.el-blmhc1308
3 ай бұрын
Hi, How can I only lock from editing a few cells without having to unlock all of the other cells in a spreadsheet that needs to be constantly updated with new information? With the steps in this video I will have to manually continue to unlock cells as new information is added to the spreadsheet?
@arqnagauri
Жыл бұрын
thanks bro
@ExcelCampus
Жыл бұрын
You're welcome, Muhammad! 😀
@lisajack9217
Жыл бұрын
Great tutorial. One question though. Within the cells that people can "edit" - the cells that are "unlocked" - I want those cells to be able to be merged and centered but that option is not available on the home screen after I protect the sheet. Is there a way that you can merge and center cells within the unlocked cells? If so, how?
@mujunikilligye5072
5 жыл бұрын
Your definitely amazing. Nice content man.
@YouGotPropofol
3 жыл бұрын
Great thanks. I don't get why they didn't design it where you can just select cells and lock them without all this protect sheet stuff.
@CarlitoCulpable
Жыл бұрын
Hi, do you know how to remove handles or adjustments points on a text box in Excel? Please help
@davidlatin9896
6 ай бұрын
The Lock Cell icon set up in Quick Access Toolbar only indicates locked cells when the sheet is Unprotected! Is this a bug? It would be nice if it indicates locked cells for Protected sheets.
@nitinc2373
11 ай бұрын
I have an Excelsheet,In this the Range is ("A1:G10"),I want when I Edit in cell A4 that cell should be locked for Editing & Deleting,but the user can edit in B4,ah=fter eding in B4 this cell should be locked for Editing & deleting and so on,how to do this.?
@rajeshsinghjadham9899
5 жыл бұрын
good video sir
@Zipo214
3 жыл бұрын
Can you lock and protect individual cells dynamically? So if I have a cell that requires a number to be entered before the next set of cells, but I dont want someone to enter data into those cells until they finish entering in the first cell, but I also want the color to change as I go.
@JM-dn1hj
Жыл бұрын
How do you protect the cells/ sheet from mobile iOS/Android users? I protected my sheets/cells and in excel they could not be accessed, BUT a colleague accessed them using his mobile!
@anenlightenedmisfit6262
2 жыл бұрын
Can anybody tell me what is the difference between this example, - "$A$1" vs "$A1" vs "A$1"? I know they are for locking cells rows and columns but they are not the same. Still messing up with my calculations.
@GangadharMK
4 жыл бұрын
Sir., I Have trying to lock the cells that has formulas but I have not be able to.. Below are the Steps being followed.. 1.Click Ctrl+1 2.Uncheck Lock options 3.Go to special and click On Formulas 4.Locked Option is selected 5.Protect Sheet But I am Unable to
@AMP1111911
4 жыл бұрын
Can the user add lines if they need to if the page is protected?
@harigokul4450
3 жыл бұрын
How to use the pivot option on protecting worksheets? I have tried, but the pivot option not visible after protecting the sheet with a password. pls, help me out.
@cbcity8732
Жыл бұрын
👌
@jesuspaalisbojr7320
2 жыл бұрын
How to lock the formula in the excel.
@nbforme
5 жыл бұрын
Is there a way to select all locked or all unlocked cells to quickly format them?
Пікірлер: 103