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!!
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.
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. ua-cam.com/video/gD9fEM9WNfw/v-deo.html
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
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
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.
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.
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 ?
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. ua-cam.com/video/gD9fEM9WNfw/v-deo.html
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.
if you want lock cell you should do that 1. select on cell who you want to lock 2. click on the home tab 3. click on the format 4. click on lock cell --------------------- 5. click on the review 6. click on protect sheet 7. insert your password 8. ok ---------------------- Result - The cell you lock you can write text or number but another cell that not lock you can't write.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-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 UA-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!!
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
simply made simple to understand.Thank you sir
your teaching skill is too good
Nice way to present, very informative and easy to understand
Thank for such an important information sir
A big hands of you
Simplicity of teaching method makes you unique
To the point - what i needed
Best way of teaching I ever scene
MASHALLAH you are too good and confident :)
Good information
I think it was special for me
I was need it
I salute you
Can I protect sheet with edit rights to multiple person for particular areas of a worksheet?
Thank you for this very simple video to understand excel in better way..
good presentation it is helpful thank u
Short video but sweet, easy to remember.
Very good video ❤️❤️❤️❤️❤️❤️❤️
Thank you😊😊😊😊😊😊😊
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
Keep it up
Thank you so much bro for sharing this information.
Excellent
Thank u its useful
Cool.. Thank u so much...
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.
ua-cam.com/video/gD9fEM9WNfw/v-deo.html
Excellent Dear my friend
Hi Sir. How to protect a full row if i select "completed" from drop down list.
How can we protect all the worksheets in single method in whole workbook?
Thanks for good information
Awesome sir 😎
But how can I protect *particular cells* ?
I mean selected cells not the whole sheet.
ua-cam.com/video/K23LzCiUcNo/v-deo.html
Hope, this helps.
YOUR LESSON WAS HELPFULL!!
DEAR SIR I LIKE YOUR VIDEO AND VERY VERY THANKS
It will work in Google sheet also?
Thank you sir...
Sir is there is any way to protect the sheet to share with defined personal only
Good....
Thank you very much
I have used marcros for multi selection dropdown..
After i protect the sheet..
Multiple select drop down option not working.
Thank you for this information
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
What an amazing tutorial !!!
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
Nice....Teaching...
Thank you.
Thnq very much sir
Excellent Boss
Thanks sir.
Thanks 🎉🎉
How to enable search in Protected Worksheet.
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)
Is this touch screen computer how are u using the touch features???😃
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.
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.
Thank you
Can we copy the Data from protected Excel sheet ??
Nice
Thank you so much sir👏👏👍🤘
quick and easy !
Is it possible to protect a file that is shared in g drive
Sir 2007 doesn’t have option for info?
very useful 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 ?
thanks sir
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.
ua-cam.com/video/gD9fEM9WNfw/v-deo.html
I WANT TO PROTECT DATA . BEFORE OPEN THE WORKBOOK PASSWARD ENABLE . hOW I DO THIS
Thanks
Good guideance sir ji 👍
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 can I copy and paste if some of cell is protected
great
Thank u
Sir kindly plz explain how to lock cell
if you want lock cell you should do that
1. select on cell who you want to lock
2. click on the home tab
3. click on the format
4. click on lock cell
---------------------
5. click on the review
6. click on protect sheet
7. insert your password
8. ok
----------------------
Result
- The cell you lock you can write text or number but another cell that not lock you can't write.
nice presentation
Sonu nigam 😁
Can protected sheet be copied?
Sir, how can we protect a dynamic table?
can we insert password for each sheet like as we are protecting workbook ?
so no one can enter any sheet without writing pass?
Shape or other data sheet work book ko protact krne ke bad bhi sheet me data ya shape insert or dlt ho rhe h
Dear sir
how to set all worksheets single password is possiable sir
Hi Venkat,
I have created a video for the same.
ua-cam.com/video/gD9fEM9WNfw/v-deo.html
Sir how can i unprotect workbook
How to lock Excel work book before opening it. like in our mobile phone password enter
I need excel sheet heading gridline display option inactive protection video
sir i want to protect just locked cells via vba button
i can hear durga puja dhol ...haha
sir , i have a doubt ? how can i contact you ?
is there any email id?
THANKS...
www thanks brother
Thank you Sir
I cant protect the sheet
Video hindi me banao sir please
Thank you 😊
btw ty ia have quiz on school
How to unlock it
Thanks sir...