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!
@SarahLovesU229 күн бұрын
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 :)
@askingwhy1233 жыл бұрын
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!
@michaelmontgomery80954 жыл бұрын
Worth watching. Clear, concise, good job. Thanks from Cape Town!
@sklee16442 жыл бұрын
I watched many times, but finally I got it work for me. Thanks for sharing. I wish I could find you two years ago.
@alanrichardson8923 Жыл бұрын
At last! A straightforward explanation for locking and protected cells in Excel. Thanks Jon I will be back to Excel Campus again!
@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! :)
@mukwera91314 жыл бұрын
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.
@Kunanakuyalstainde4 жыл бұрын
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!
@syammaddukuri70163 жыл бұрын
thanks ..,got the real one after watching somany videos ....
@TBeau57 Жыл бұрын
I finally got them to work after watching this video.
@ExcelCampus Жыл бұрын
That's great, T! 😀
@ajlong404 Жыл бұрын
This was perfect. And your microphone sounds terrific.
@voiceInDetroit4 жыл бұрын
great job. no wasted time. You taught me a lot in a short video.
@maryandbrianbaulkhamhills87473 жыл бұрын
Echo the comments below. Great presentation and easy to follow. Thanks heaps
@blike224 жыл бұрын
You're an absolute legend. Thanks champ.
@ExcelCampus4 жыл бұрын
No problem, blike22! 👍
@azaz7415 жыл бұрын
Thanks Jon ,for the lesson it was really useful , i will put it on practice...
@ExcelCampus5 жыл бұрын
Thanks AZ! Happy to hear you will be putting it to good use. 🙂
@ketsyprophete3 жыл бұрын
Thank you!! This video is so easy to follow and understand!
@weekender88354 жыл бұрын
Spot on. Clear and concise. Look forward to other videos from you.
@vangiehorvath26772 жыл бұрын
Simple and easy to follow, thank you so much.
@haydeeportillo34263 ай бұрын
Very easily explained.
@ExcelCampus3 ай бұрын
Thanks for your feedback! 😀
@rustynail86924 жыл бұрын
thanks for sharing knowledge for free.
@billchow75722 жыл бұрын
Clear and concise. Good
@lorieadams48284 жыл бұрын
Thank you for your video! This was very helpful and easy to follow and implement while watching!
@speaktruth28302 жыл бұрын
Hi Jon, This video was very much helpful and beautifully explained. cheers !!!
@maureendowling21832 жыл бұрын
Very helpful thanks
@MsMusicalways10 ай бұрын
Thank you!!!
@russelllarge20913 жыл бұрын
Very useful and could follow easy. Thanks
@tesfayedesalegn53403 жыл бұрын
Thank you.
@krishnamurthygp6022 Жыл бұрын
Simple n wonderfully explained.. cheers jon😊👍
@ExcelCampus Жыл бұрын
Glad you liked it, @krishnamurthygp6022 ! 😀
@poonama4 Жыл бұрын
Thank you so much - it was really helpful.
@SamBeast5963 жыл бұрын
Thanks from Purdue!
@viveksharma95604 жыл бұрын
Excellent explained
@supersql84063 жыл бұрын
Exactly what I was looking for!! Thx u!!
@PokerFather043 жыл бұрын
always great explanations! and examples! you, sir...are my hero! :)
@sairarcher3 жыл бұрын
Good piece of information! Very helpful.
@letstalkaboutoccupationalh8764 Жыл бұрын
Thanks for sharing
@ExcelCampus Жыл бұрын
Thanks for watching! 😀
@layengphan36342 жыл бұрын
Clear instructions and certain of great help !
@dardangjoshi62833 жыл бұрын
Very helpful. Thank you!
@narayanmhaskar3 жыл бұрын
EXCELLENT AND VERY USEFUL
@jocelynberlin9573 жыл бұрын
Thank you... it help me a lot
@nephneph18693 жыл бұрын
Thank you so much.. this is very informative. Will subscribe.
@bijuc.h43714 жыл бұрын
thanks, simple explanation done
@mikevanwyngaardt38524 жыл бұрын
Very user friendly, thank you
@ororos7722 жыл бұрын
Thanks for the tips
@nitinc237311 ай бұрын
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.?
@yulinliu8505 жыл бұрын
Very helpful tips! Thanks!
@jesin1003 жыл бұрын
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.
@avinashattri94943 ай бұрын
Thank you 💯💯
@wayneedmondson10655 жыл бұрын
Hi Jon.. thanks for the great review on Lock and Protect. Always insightful and useful tips from your channel. Thumbs up!
@pottiepotgieter15922 жыл бұрын
Is there a way to protect a cell but allow people to use only a drop down list from that cell?
@bestscenes14695 жыл бұрын
I just Love your vids. Thanks
@mohammadalali65463 жыл бұрын
really amazing, simple, brief, and effective explanation, just a question, any videos for the most important uses?
@rickkeev49195 жыл бұрын
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.
@rajamanikamr47795 жыл бұрын
I like very much for your all interesting lessons
@alexandramerino97937 ай бұрын
You are awesome!🎉
@ExcelCampus7 ай бұрын
Thanks, Alex! 😀
@drsteele47495 жыл бұрын
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.
@russelvarias23694 жыл бұрын
thank you so much for this
@BeauKnowsMultifamily4 жыл бұрын
bad ass, love this feature.
@crz65914 жыл бұрын
Wow, thank you so much for this...
@steelhub13064 жыл бұрын
thank you very much
@unitedworldcare94974 жыл бұрын
Thank you Sir
@aqibishfaq13135 жыл бұрын
Very helpful video thanks for sharing your knowledge
@davidlatin98967 ай бұрын
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.
@f.el-blmhc13083 ай бұрын
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?
@bOyal10004 жыл бұрын
Thanks
@samipiyash93225 жыл бұрын
Good tutorial
@ExcelCampus5 жыл бұрын
Thanks Sami! 🙂
@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!
@CarlitoCulpable Жыл бұрын
Hi, do you know how to remove handles or adjustments points on a text box in Excel? Please help
@icequeenvanilla5 жыл бұрын
Tnx for video ☺️
@anenlightenedmisfit62622 жыл бұрын
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.
@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?
@mikeknopfler29284 жыл бұрын
clear as a bell
@harigokul44504 жыл бұрын
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.
@Zipo2143 жыл бұрын
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!
@johnadams55865 жыл бұрын
Thank you Jon very much :(
@GangadharMK4 жыл бұрын
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
@arqnagauri Жыл бұрын
thanks bro
@ExcelCampus Жыл бұрын
You're welcome, Muhammad! 😀
@mujunikilligye50725 жыл бұрын
Your definitely amazing. Nice content man.
@ojomichael62132 жыл бұрын
Very good lessons thanks!! But if the content is copy to a new sheets are the cell still locked.?
@madhavdamani97992 жыл бұрын
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.
@jtweber332 жыл бұрын
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!
@chinabono89955 жыл бұрын
Very good!!!
@AMP11119114 жыл бұрын
Can the user add lines if they need to if the page is protected?
@YouGotPropofol4 жыл бұрын
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.
@cbcity8732 Жыл бұрын
👌
@rajeshsinghjadham98995 жыл бұрын
good video sir
@jesuspaalisbojr73202 жыл бұрын
How to lock the formula in the excel.
@nbforme5 жыл бұрын
Is there a way to select all locked or all unlocked cells to quickly format them?
@kangtri36833 жыл бұрын
Thank You...
@richardamey99475 жыл бұрын
Really useful; thanks for sharing.
@nitinc237311 ай бұрын
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.?