sir,I just started watching your videos view weeks ago,,I must tell you this,you are the best and I love your explanations,,,Thanks I have really learned much from you.Bravo!!
You just need to change the property of drop down cells using right click format cells, and go to Protection. Under protection you will see Locked and Hidden, just uncheck Locked checkbox and then protect your sheet. It will be password protected leaving the drop down alone as not protected. You can view our channel for more information. th-cam.com/video/gD9fEM9WNfw/w-d-xo.html
Dear sir , I am following your excel tutorials and I found that these are very interesting and your presentation skills are also very good. I feel that it will be very easy to follow you if you could provide the worksheets in the description. Thank you
you all prolly dont give a shit but does any of you know of a trick to get back into an instagram account..? I was stupid lost my login password. I love any tricks you can give me
@Colson Landry i really appreciate your reply. I got to the site on google and I'm in the hacking process atm. Seems to take quite some time so I will get back to you later with my results.
Hi thanks for your videos, but these steps are not working in table, when applying these steps excel table then are not extending automatically,,, Please assist. thanks
how to protect sheet 1 sheet 2 sheet 3 in excel in which 3 users and one user use sheet 1 and so on how to lock on sheet 1,2,3 in different passwords ?
Good morning Can anyone tell me...if I close 1 excel workbook it's closing All the excels workbook....I want to close separately....I don't want to close all at once.
PLS. I try to protect a sheet which contain a created table with some formulas after I protected it the table can't increase automatically with formula> also when I try to open it with google sheet it give my an error with some formula> I use 2016 Microsoft excel. Thank you for your help
Hi, You can protect a sheet from Review menu. In case you are looking to hide it, then you can just right click on the sheet tab and select hide. You can review our channel for more excel learnings. th-cam.com/video/gD9fEM9WNfw/w-d-xo.html
I have question I have to protect the whole excel sheet but there are some specific cells where some one can entry the data how can I do this. Just to be informed the writer can't insert and any column and row
Right click on specific cell and click format, then go to protection tab and remove check from locked. after removing check, protect file again. that specific cell is editable now.
Hello sir. I am going to open any excel sheet. It shows it is opening but get out of the excel in Android phone and while opening the excel for the first time, it shows your organization protects the data.. Kindly guide and help sir for opening the same.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
No unnecessary timewasting intros, nothing extra, just simple, easy to catch and clear content. That's what we need. Amazing Work.
College student here in California learning Excel from you. YOU ARE THE BEST ON TH-cam!!!! THANK YOU!
Thank you sir. Simple explanation with clear content
sir,I just started watching your videos view weeks ago,,I must tell you this,you are the best and I love your explanations,,,Thanks I have really learned much from you.Bravo!!
Simplicity of teaching method makes you unique
simply made simple to understand.Thank you sir
Nice way to present, very informative and easy to understand
your teaching skill is too good
I learned more in this short video than I did on the hours of trying to get this Information before. Very easy to understand thank you
Thank for such an important information sir
A big hands of you
Best way of teaching I ever scene
MASHALLAH you are too good and confident :)
good presentation it is helpful thank u
Thank you for this very simple video to understand excel in better way..
Good information
I think it was special for me
I was need it
I salute you
To the point - what i needed
Short video but sweet, easy to remember.
Excellent Dear my friend
Thanks for good information
very neat presentation. Good.
HOW TO PROTECT SHEET CONTAIN SEARCHABLE DROPDOWN LIST
You just need to change the property of drop down cells using right click format cells, and go to Protection. Under protection you will see Locked and Hidden, just uncheck Locked checkbox and then protect your sheet. It will be password protected leaving the drop down alone as not protected.
You can view our channel for more information.
th-cam.com/video/gD9fEM9WNfw/w-d-xo.html
Very good video ❤️❤️❤️❤️❤️❤️❤️
Thank you so much bro for sharing this information.
Can I protect sheet with edit rights to multiple person for particular areas of a worksheet?
Dear sir , I am following your excel tutorials and I found that these are very interesting and your presentation skills are also very good. I feel that it will be very easy to follow you if you could provide the worksheets in the description. Thank you
you all prolly dont give a shit but does any of you know of a trick to get back into an instagram account..?
I was stupid lost my login password. I love any tricks you can give me
@Dario Thomas instablaster :)
@Colson Landry i really appreciate your reply. I got to the site on google and I'm in the hacking process atm.
Seems to take quite some time so I will get back to you later with my results.
@Colson Landry It did the trick and I now got access to my account again. I'm so happy:D
Thank you so much you really help me out!
@Dario Thomas No problem xD
Awesome sir 😎
Keep it up
Excellent Boss
DEAR SIR I LIKE YOUR VIDEO AND VERY VERY THANKS
How to enable search in Protected Worksheet.
Excellent
Nice....Teaching...
YOUR LESSON WAS HELPFULL!!
Is this touch screen computer how are u using the touch features???😃
Sir is there is any way to protect the sheet to share with defined personal only
It will work in Google sheet also?
nice presentation
How can we protect all the worksheets in single method in whole workbook?
Thank you😊😊😊😊😊😊😊
Thank you for this information
great
Hi Sir. How to protect a full row if i select "completed" from drop down list.
Hi thanks for your videos, but these steps are not working in table, when applying these steps excel table then are not extending automatically,,, Please assist. thanks
HAVE COMPLETE COMMAND ON HIS SUBJECT.
Good....
But how can I protect *particular cells* ?
I mean selected cells not the whole sheet.
th-cam.com/video/K23LzCiUcNo/w-d-xo.html
Hope, this helps.
What an amazing tutorial !!!
Thank u its useful
Can we copy the Data from protected Excel sheet ??
Can protect ,copy worksheet?
Nice
Protect the sheet option are available in the Google spreadsheet please give your suggestions
how do i protect multiple worksheets at once? (i have over 50)
Good guideance sir ji 👍
very useful thanks
Thank you very much sir,😊🙏
I have used marcros for multi selection dropdown..
After i protect the sheet..
Multiple select drop down option not working.
how to protect sheet 1 sheet 2 sheet 3 in excel in which 3 users and one user use sheet 1 and so on how to lock on sheet 1,2,3 in different passwords ?
Cool.. Thank u so much...
Thank you so much sir👏👏👍🤘
Thank you very much
Good morning
Can anyone tell me...if I close 1 excel workbook it's closing All the excels workbook....I want to close separately....I don't want to close all at once.
quick and easy !
PLS. I try to protect a sheet which contain a created table with some formulas after I protected it the table can't increase automatically with formula> also when I try to open it with google sheet it give my an error with some formula> I use 2016 Microsoft excel. Thank you for your help
Hi Sir, how do I protect a specific worksheet from being view?
Hi,
You can protect a sheet from Review menu. In case you are looking to hide it, then you can just right click on the sheet tab and select hide.
You can review our channel for more excel learnings.
th-cam.com/video/gD9fEM9WNfw/w-d-xo.html
I WANT TO PROTECT DATA . BEFORE OPEN THE WORKBOOK PASSWARD ENABLE . hOW I DO THIS
Sir 2007 doesn’t have option for info?
How to lock Excel work book before opening it. like in our mobile phone password enter
can we insert password for each sheet like as we are protecting workbook ?
so no one can enter any sheet without writing pass?
How can I copy and paste if some of cell is protected
I have question I have to protect the whole excel sheet but there are some specific cells where some one can entry the data how can I do this. Just to be informed the writer can't insert and any column and row
Right click on specific cell and click format, then go to protection tab and remove check from locked.
after removing check, protect file again.
that specific cell is editable now.
i can hear durga puja dhol ...haha
Can protected sheet be copied?
Sir, how can we protect a dynamic table?
Shape or other data sheet work book ko protact krne ke bad bhi sheet me data ya shape insert or dlt ho rhe h
please give me some graphics design tutorial
I need excel sheet heading gridline display option inactive protection video
Is it possible to protect a file that is shared in g drive
Thnq very much sir
Thank you.
Dear sir
how to set all worksheets single password is possiable sir
Hi Venkat,
I have created a video for the same.
th-cam.com/video/gD9fEM9WNfw/w-d-xo.html
Wow, too many ways to do one thing.
Thanks sir.
Hello sir.
I am going to open any excel sheet. It shows it is opening but get out of the excel in Android phone and while opening the excel for the first time, it shows your organization protects the data.. Kindly guide and help sir for opening the same.
how to protect one sheet among 7 sheets such that no one can even look without the password.
Thank you Sir
Thanks
sir i want to protect just locked cells via vba button
thanks sir
THANKS...
Thank u
👍
Please try deleting a row.
1. right click on the number rows
2. click on delete.
sir , i have a doubt ? how can i contact you ?
is there any email id?
Thank you 😊
Sir how can i unprotect workbook
Video hindi me banao sir please
Once you unprotect and save it, the protection is gone, that shouldn't be
btw ty ia have quiz on school