Wow...i watched many videos but cannot understand....but after watching your video sir...i am clearly understand that and did successfully...thanks for clear clarification....
Thank u so much sir...your videos are so help full for me..whitout computer course any body can learn easily about MS Excel ..if they watch your videos.
Thank you for such an informative video. I have some grouping in my sheet and I want to unprotect those groups such that the user can expand or collapse the group but can't edit the data in those cells.
Can we have method to automatically "unlock" (for any operation) a otherwise "locked cell" in protected sheet depending on value of another cell ? Let's say I have a worksheet in which all the cells are protected in column O. My column D has drop down menu to select from @ 58 list. What I want to achieve is if someone select from drop-down "subtotal" in any row in column D, respective cell in that row in column O shall be unlocked for subtotal. How we can achieve this. Looking forward and thanks in advance.
Kindly help me to solve this issue , i had created a dashboard for sales tracker pipeline and its working fine , but when i tried to apply hide/protect the formulas and the validations given in the table's conditional formatting and dropdown list box are not working after the first row in the table. Kindly assist me on this. Jogesh David Ross.
What if I only need to lock formulas so no one can edit them? I selected all the formulas in the worksheet first by using Ctrl+G and then I tried to lock them but it doesn't work.
Thanks a lot for the video. Can you please tell which technolofy do use for touch based background? Its new to me and will really be thankfull if you could please share the name of technology.
Hi, I lock all formula cell in a spreadsheet, but when i do copy a table and paste in other sheet it is unlock. What I want make a table lock when i do copy in other sheet. Is it possible ? please reply
Hi Mahesh, In Protect Sheet dialog box, please select following options (1) Format Columns (2) Format Rows. You will be able to adjust Row Height & Column Width. Thank You!
Hi, can you please clarify that why do we need to "Protect" the sheet? Can we not just unlock the cells that we require to be editable and lock all the other cells in the sheet? What is the "extra" use of putting a password on the sheet?? Please clarify, thanks a lot..
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
This is the best explanation I have seen on locking and unlocking cells. It was clearly demonstrated. Thank you very much.
Wow...i watched many videos but cannot understand....but after watching your video sir...i am clearly understand that and did successfully...thanks for clear clarification....
Iam looking for this video from so many days . Thankyou sir ji
Thank u so much sir...your videos are so help full for me..whitout computer course any body can learn easily about MS Excel ..if they watch your videos.
Oo great teacher
मुझे इंग्लिश आती नहीं फिर भी आपके स्टाइल से मुझे help mil gya
I am so much pleased to have a excellent tutor like you. Keep going have a nice day all time.
Excellent, a great teacher just makes excel damn easy
Thank you. It helps me protecting my work from being copied.
Watching from Bangladesh. Thanks Bro
Very helpful and searching for this information from quite a long ago.
Thanks.
Superb. I got what I was looking for. Thank you so much.
Very informative channel.
Thanks alot
this helped me on my studies so much, thank you so nuch
Excellent Sir 👍👍🙏
Thank you sir. My colleague in my office would delete my data. It will do me a lot of good.
Excellent teaching sir....
It is really amaging..thank you
Very Very Useful Video...
Thank you for such an informative video. I have some grouping in my sheet and I want to unprotect those groups such that the user can expand or collapse the group but can't edit the data in those cells.
Brilliantly explained .
Bro very thankyou, your class helps me to complete my project, you are a great person,ur explanations and all fantastic
Thank you very much. Very helpful.
Can the same thing can done for multiple rows and columns which is not in an order
Wheather locking the cells will be possible in that condition
Very simple way to explain
Keep it up man
Thanks..very useful👍
is it posibel to allwo only one time add and protect from edit or delete
Great. Very useful
Super helpful. you are my life saver :)
Wow it's working ❤️❤️❤️❤️
Awesome Sir
Great.. thank you for your help with this
I was created a locked file with allow insert rows. I want to auto copy formula in locked cells. How its possible?
Very helpful. Thank you
Can we have method to automatically "unlock" (for any operation) a otherwise "locked cell" in protected sheet depending on value of another cell ?
Let's say I have a worksheet in which all the cells are protected in column O.
My column D has drop down menu to select from @ 58 list.
What I want to achieve is if someone select from drop-down "subtotal" in any row in column D, respective cell in that row in column O shall be unlocked for subtotal.
How we can achieve this.
Looking forward and thanks in advance.
Kindly help me to solve this issue , i had created a dashboard for sales tracker pipeline and its working fine , but when i tried to apply hide/protect the formulas and the validations given in the table's conditional formatting and dropdown list box are not working after the first row in the table. Kindly assist me on this.
Jogesh David Ross.
How I can use filter and sort for unlocked columns in protected sheet?
Can we insert row in between the rows
Nice explanation sir
Too good....thank u so much
Nice explanation.
Nice explaintion .thank you. How do we u protect formatting bar?
What if i want to protect the sheet but i need be able to insert row or change the font size?
Nicely explain....
great bro simplifed explanined
Find exact what I am looking for, Thanks
Excellent sir.
Excellent
thank you very much for the videos
What if I only need to lock formulas so no one can edit them? I selected all the formulas in the worksheet first by using Ctrl+G and then I tried to lock them but it doesn't work.
my exam got cancelled still watching your vids bc youre cute as a dandelion
Dil se like 😇👍
Thanks a lot for the video. Can you please tell which technolofy do use for touch based background? Its new to me and will really be thankfull if you could please share the name of technology.
Very Helpful. Thank you
Good teach and modern white board
amazing so nice sir good job try to give more good knowledge
If we want to lock 10 cells at different positions in sheet how can we do that
Thank you😊😊
Thank you 👍
How do I go back to my index from each hyperlinked sheet?
Very helpful, thanks
Thank you. Great!
Hi, I lock all formula cell in a spreadsheet, but when i do copy a table and paste in other sheet it is unlock. What I want make a table lock when i do copy in other sheet. Is it possible ? please reply
Hi
How to allow editing in row height and column width in locked sheet ?
Hi Mahesh,
In Protect Sheet dialog box, please select following options (1) Format Columns (2) Format Rows.
You will be able to adjust Row Height & Column Width.
Thank You!
@@ankursharma6157Thank you..
Hi, can you please clarify that why do we need to "Protect" the sheet? Can we not just unlock the cells that we require to be editable and lock all the other cells in the sheet? What is the "extra" use of putting a password on the sheet?? Please clarify, thanks a lot..
if i convert the Range to a Table so how can i protect the cell continuing the table fuction facilities.
plz guide
Thank you Sir....
U. r grate sir
Aap ka ye setup kitna ka pada tha
Amazing! I need Pandrive of full excel course of this tutorial, How can I get?
very helpful sir..
I couldn't save protected sheet plz help me out
Thanks. could you please share how to lock/protect formula on excel?
Very helpful. Thank you so much :)
Great
Sir , can we use vba code in shared file one drive
Thankyou so much sir
Awesome
1crore thanks sir🙏🙏🙏🙏🙏
I need a little help can you please ?
Thanks bro..
Thank you!
thank you sir
This is not unprotect excel workbook. How should I do to unprotect my book. I want to quit the game.
Thank You it is good
thank you so much yaar
Thanks sir.
IF WE FORGOT PASSWORD, SO WHAT IS THE PROCESS TO UNLOCK IT
sir i want practices data sheets please
Thanks sir
Thank you
Good
thankyou sir
Thank you :)
Thanks buddy
Good good
THANK YOU
Password forgot in the excel sheet so how to open
Thanks!!1
Thanx