I watched several different videos and read several different instructions and I finally understand this simple task of "locking" cells because of this video! Thank you!!!!!
Outstanding!!! I'm impressed how you have clarified the a somewhat "confusing" subject with a clear, concise, examples. And your spoken volume and enunciated were great (something so many other people totally fail at). After your video, I asked myself how did I ever consider this subject to be difficult and confusing... the answer is rooted in Microsoft's HELP. I read it a few times and each time I came away MORE confused... Thanks VERY much. You are a real Pro.
Awesome!!! Everyone explains how to "lock cells" and protect worksheet, but when I follow their instructions, either I can't type anywhere on the document, or I can still type over all my formulas. Your explanation was absolutely the best and took only a few seconds to do.... Pitty I wasted almost half an hour watching other's videos to no avail!! You're the best!! Thanks :)
Ralph! Thank you for your explanation of LOCKED and UNLOCKED - I've been trying to stop users changing certain cells but allow them to input to others for some time but couldn't get it right. Now I've got it sussed! Thanks!
Thank you for being a sensible person... All of these other tutorials literally have you locking the entire spreadsheet which makes no sense for the purpose of excel.
Not only did you save me hours of hassle but I got a free coffee as I am now king of spreadsheets! (I'll have to let them down gently - but first coffee!)
Hi! I want to create a weekly inventory sheet for my coffee shop with a starting data already using an iPad just save paper and time. Its like all they have to do is just mark the day where a particular stock has been used so that at the end of the week we already know how many products has been actually utilized. My concern is how can we make sure all the data that has been previously input can't be modified?
I wrote a SelectionChange macro in the worksheet. After protecting the worksheet, I got an 'Application-defined or object-defined error' every time I select a different cell in the worksheet. Seems like to protect worksheet function doesn't work well with worksheet event procedures.
Hello Ralph. Thanks for the video! Could you please show what the code would look like if I wanted to leave more than one sheet visible? Let's say I want to veryhide 8 sheets and leave 5 visible. Thanks a lot!
I type 8digits in a cell, when I enter it appear #### regardless of the width of the cells. when I wanna print that paper datas are all ###, but I can see it when I select on that cells. what's wrong? pls help. I noticed only on that cells in that particular column. pls reply me and ease my project.
Hi... What if I have to lock just the filters button but not the pivot table below? I want all others to extract data from the pivot table but not disturb the filters. Please help!
Awesome, I need a help from you, i.e. I need to know that if i have 29 rows and 30 columns at 1 sheet for the month of january to december and then a similar sheet (sheet number 13) if i make to cumulate the all 12 months at 13th sheet???? Then what is the process?????
hi, thanks for your nice video. But my question is how to luck a sheet with password so for example 3 different users are allowed to access only one page each with their passwords. considering that we already have made cell protections in a way that other users can only access specified cells as you mentioned?
hi Ralph, if I have multiple worksheets in my excel and I don't want anyone to be able to delete them, do you know what I should do? Thanks for your help mate
Can you add & remove rows & columns in protected table? I want to protect formulas in my table but when I protect the cells which the formulas in the sturucture of table is not working((
Thanks so much, I have another question, what if in my spreadsheet they want to add a row or a column because there's more data required but the sheet is protected, what can I do?
I watched several different videos and read several different instructions and I finally understand this simple task of "locking" cells because of this video! Thank you!!!!!
Outstanding!!! I'm impressed how you have clarified the a somewhat "confusing" subject with a clear, concise, examples. And your spoken volume and enunciated were great (something so many other people totally fail at). After your video, I asked myself how did I ever consider this subject to be difficult and confusing... the answer is rooted in Microsoft's HELP. I read it a few times and each time I came away MORE confused... Thanks VERY much. You are a real Pro.
Concise; with a simple example; good analogy with locked and open doors. The best on on UA-cam... better than Office tutorial.
Thank you.
Awesome!!! Everyone explains how to "lock cells" and protect worksheet, but when I follow their instructions, either I can't type anywhere on the document, or I can still type over all my formulas. Your explanation was absolutely the best and took only a few seconds to do.... Pitty I wasted almost half an hour watching other's videos to no avail!! You're the best!! Thanks :)
Ralph! Thank you for your explanation of LOCKED and UNLOCKED - I've been trying to stop users changing certain cells but allow them to input to others for some time but couldn't get it right. Now I've got it sussed! Thanks!
Excellent presentation ... I look forward to viewing more of your videos.
Ralph, your tutorial was easy to learn, with clear message & very good speech to understand!!! Thank you!👍
Excellent instruction! Simple straight forward! Hope to use more of your videos Ralph! Thank you!
Thank you for your video. It was much better than the others I watched.
Ralph, thank you. Great explanation. the door makes so much sense.
The best explanation I have encountered to date. Thank you very much!
Very straight forward. Your explanation to locked and unlocked makes sense.
Very clear on something that I found so baffling to comprehend. Very helpful - thank you!
Thank you so much. Plain English and easy to understand. You are awesome.
VERY VERY GOOD EXPLAIN .....EASY TO UNDERSTAND.....THANKS SIR
The best explanation I've seen thus far. Thanks
absolutely superb video! To the point, easy to understand and quick! Keep up the great work!
Thanks so much, Ralph. Easy and clear, tried for the first time, though have been using Excel for ages as a dummy :).
Ralph, thank you! Great analogies made it so much easier to understand.
Found this really helpful always had a problem understanding how to lock cells but due to this tutorial i'm sure i can master this thanks.
Thank you for being a sensible person... All of these other tutorials literally have you locking the entire spreadsheet which makes no sense for the purpose of excel.
First I've found that is easy to understand. Love your analogies. Great job! I shut and locked the door :)
Perfect Ralph!! You solved a big problem! Waiting for some more knowledgeable videos like this!
Easy to follow instruction. The video has been of help for what I needed to do in my Excel sheet. Thanks a lot
Omgoodness, I always wanted to know how to protect the whole spreadsheet, now I know and I could make use of it. Thanks
best explanation ever thanks a lot to you sir!!!!!
Thank you, your style and approach are excellent
Many thanks.
Excellent tuition, made so clear and easy to follow.
Precise & Great explanation , Hats off
Thank you so much for this. I was working on an excel file with important data. This works great for what i want to do. Thanks again.
Thanks! Well explained without any rambling or frills.
Splendid! Great, thank you Ralph
Not only did you save me hours of hassle but I got a free coffee as I am now king of spreadsheets! (I'll have to let them down gently - but first coffee!)
this method is really useful for office purpose
Thank u very much... U solved 100% of my accounting issue.
Thank you for this easy and comprehensive video
CLEAR AF! Just what I needed!
Strong work! Easy to take in
Very helpful video
Thanks for sharing your knowledge
Great video and analogy!
Hi Ralph,
Thanks, very well explained.
Thanks for making it easy to understand
Good Examples...really learnt lot...
Hi! I want to create a weekly inventory sheet for my coffee shop with a starting data already using an iPad just save paper and time. Its like all they have to do is just mark the day where a particular stock has been used so that at the end of the week we already know how many products has been actually utilized. My concern is how can we make sure all the data that has been previously input can't be modified?
Thanks ,so clear and easy and explain logic
fantastic work and the analogy was perfect!
Thanks! Exactly what I needed
I wrote a SelectionChange macro in the worksheet. After protecting the worksheet, I got an 'Application-defined or object-defined error' every time I select a different cell in the worksheet. Seems like to protect worksheet function doesn't work well with worksheet event procedures.
Many thanks....this is what i need today..
NICE!!! Thanks for posting! I've always been trying to figure out how to do this.
the best video, very clear thanks.
is there a way to allow the user to change the color fill of the unlocked cell?
Hello Ralph. Thanks for the video! Could you please show what the code would look like if I wanted to leave more than one sheet visible? Let's say I want to veryhide 8 sheets and leave 5 visible. Thanks a lot!
good work Ralph
Thanks! Super clear instructions
so glad you got wight to the point and was very helpfully thanks you so much we enjoined you clip
Hello Ralph, how I can locked the all data in the sheet, but Group, Filters, Vlookup function still work,?
Great explanation! Bravo.
I type 8digits in a cell, when I enter it appear #### regardless of the width of the cells. when I wanna print that paper datas are all ###, but I can see it when I select on that cells. what's wrong? pls help. I noticed only on that cells in that particular column. pls reply me and ease my project.
Awesome! Thanks Ralph
Thanks for the help Ralph
Hi! thank you for this. Can I hide columns / worksheets to not allow others visibility to some columns?
yes you can hide and protect
Thanks Team,,,,,,,,well explain.Thanks one again
thank u please make more videos - excellent teacher!
you are AMAZING well done!!! I saw a lot of videos and your is great
Hi... What if I have to lock just the filters button but not the pivot table below? I want all others to extract data from the pivot table but not disturb the filters. Please help!
very clear. I like the door analogy
Thanks Ralph........easy way to explain
Thanks for the clear explanation!.
Thank you so much. It was really helpful and I could use the feature
Very well explained.
Thanks for the help Ralph Phillips.
Thanks for this video it's make my work more easy. Happy New Year 2018
Hello!!
I have used the same method to protect few area, but when i copy paste in some shared folders, protection is not working
Brilliant. Also, haven't coded for about 5 years but cannot remember how to right justify numeric values in a msgbox. Struggling to find any info.
Great tutoring!!
fanatstic tutorial...very useful. thank u so much
Awesome,
I need a help from you, i.e.
I need to know that if i have 29 rows and 30 columns at 1 sheet for the month of january to december and then a similar sheet (sheet number 13) if i make to cumulate the all 12 months at 13th sheet???? Then what is the process?????
Thank you Ralph.
Really easy and simple .. Thankss a lot...
Hi sir, may I know why the QR codes generated are not support in photo viewer?
hi, thanks for your nice video.
But my question is how to luck a sheet with password so for example 3 different users are allowed to access only one page each with their passwords.
considering that we already have made cell protections in a way that other users can only access specified cells as you mentioned?
Excellent Tutorial,, your a star...
Kudos! Very clear and concise.
hi Ralph, if I have multiple worksheets in my excel and I don't want anyone to be able to delete them, do you know what I should do?
Thanks for your help mate
EXCELLENT VIDEO. Thank You.
Can you add & remove rows & columns in protected table? I want to protect formulas in my table but when I protect the cells which the formulas in the sturucture of table is not working((
Great help for 2018 still
thank you mr.ralph philips
good work
Really Helpfull.
Thank you so much!
Thanks so much, I have another question, what if in my spreadsheet they want to add a row or a column because there's more data required but the sheet is protected, what can I do?
thank you, no nonsense explanation, very clear.
Fuck off😜
Thank heap.. easy to learn..
thanks to make this video its very Help to me
when locking individual cells I have noticed that you can not change the colour of any unlocked cells, is this normal?
It's also possible to protect some specific cells with data validation without using password
Thank you Ralph ! Best video on this info :)
Nice job. Thank you.
hi, i have required vba code in excel who manuplate data in listbox more than 10 columns, can u help plz
Can you lock different sheets with different passwords?