How to Protect Excel Sheet with Password | Lock Excel Sheet
Вставка
- Опубліковано 17 вер 2024
- 🔥 Learn Excel in just 2 hours: kevinstratvert...
In this tutorial, learn how you can password protect a Microsoft Excel workbook.
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert...
As full-disclosure, I work at Microsoft as a full-time employee.
![How to Set Password Protection For Excel Workbook [Tutorial]](/img/n.gif)
⚡ Want to try opening the sample sheet from this video? Try with the following link: 1drv.ms/x/s!AmxrofZZlZ-wg_9q9U6UKhIDgC3j8w
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
And The Password is "password"
Simple, clear, helpful - thank you
Simple straight to the point! 👍🏼
Thanks for this!
Hi Kevin, Is there an easy way to password protect separate sheets within a workbook (with different passwords) so people don't see the sheets until they give in their password? (I know there is a hard way).
Jeeze Kevin! Sort out those audio levels! Made me jump out of my skin! in the first couple of seconds! :D
I only have my volume is at 37% and normally I have it at 50 or higher and it was fine. Maybe it's your volume. lol
Loved this, concise and clear. Great job!
Hello Kevin, I like your video on password-protecting the worksheet, but is it possible to password-protect separate sheets in the workbook. say sheet one is accessible to everyone but sheet two is locked
Hi, this is exactly what im looking for now, did you get a reply, or know how to do this? Thanks
Thank for the tutorial. You help me with my assignment
Very Clear & Easy Explanation !
how about if i have multiple excel file to encrypt? Is there an easy way for this rather than putting it manually?
Love your videos, and love your desktop background too. Been to Mont St Michael many times, it kind of reminds me of Diagon Alley in Harry Potter. If youve not been it's a must, just beautiful.
Hi Kevin, how can we protect formulas in a column?
Great tutorial! Couldn't figure it out while in the workbook but now the light bulb went off over my head - thank you!
Thank you! Great video, very helpful! Lachy😀
Love this video. Simple yet clear.
FINALLY SUCH A SIMPLE THING AND IT TOOK ME SO LONG TO FIND THE RIGHT VIDEO
Hey, say an excel file with multiple tab. Can we do this just on a specific one?
Hi Kevin
Rather than using a password to protect an Excel Document, is there a way to user 2 factor authentication during the opening of an Excel Document ?
Thanks for you help
Brian
Thank you for this vd very helpful
Thank you this was very helpful !
Your videos are great
Thank you!
Thanks, Kevin!
You are amazing, your videos are simple and to the point, helpful, my life is sooo easy after watching your tutorial, be it excel, word or making a video. I loooooovvvveeee ittttttt!!!!!!
Do we have a similar feature for Power BI?
How can I remove the password?
Thanks, very useful !
🔒 This is a really useful tutorial, Kevin! Excel sheets often contain sensitive information, so it's crucial to protect them with a strong password. Your step-by-step guidance makes it incredibly easy to lock down our data securely. Thank you for sharing this valuable knowledge! 👍🔐🔐
could you please do a video for what if analysis
Hey thanks a ton, how do you remove the password lock if you need to please?
Useful information thanks for uploading here.
Thank you for this useful video.❤
Kevin, Love your tutorials. Your channel has been returned a couple of times for things I've recently been looking to do. I hope that YT revenue increases! ; )
Could you do a video for how to lock certain cells? I’ve been searching for a while. I’m trying to build a spreadsheet where I’m building a form where I would only like to have 30 cells in select locations based on the layout I have where only those cells are locked. I don’t want to have the whole page locked except for a few cells as shown in this video. Microsoft should add a 2nd option to do this. Maybe push this comment to your buddies at Microsoft Excel. Thanks.
Please let me know if you got to know how to
Right click on each of the sheets and click protect sheet, put password on each
PLEASE TO HAVE THIS IMPORTANT INFOR, Please can you help with the creating home pages in excel so information can typed in homepage and will automatically appear in tables in the other works sheets. thankyou.
Thank you very much for the video!!!
Best & Quick video!
Thank you very much!
Thank you so much!! Subscribed 🙂
Thank you so much for this info bro. its really helpful for me
Can you do this for an iPad
Thanks sir for your good videos. thanks you so much
Does this work for excel online? Or do you have to open in desktop version each time?
Excellent
Thanks Kevin.
Hi, do you have a video on how to put password in Google drive ? Thanks
Might make a note that if you later decide you don't want a password after all, just go back and delete the password you had put in, in the same block and save.
how to protect one of the TABS if you have several in one document
Is it possible to put different passwords on each tab?
Thanks a lot. This helped
Great video
Hi
How can i set only one sheet in a workbook to be vew protected from an encrypted password.
I have a excel sheet that has multiple sheets that i only want other people to see their specified sheets and not others.
Thank you 😘
thanks a lot for the help brother
ohh thats great fabulous work
Will the sheet ask for password when we open it on a browser and not on excel app?
very helpful, man. thx
Thank you so much for this video x
Omgeee thank youuu!!! Very staight forward!
Next:Show me how to recover password protected excel file because I forgot the password of an excel file
Thanks Kevin
I also don't want people to access my sheet
I'm an expert at Excel. Have a good day!
thank you sir
Can I put unique password to each sheets I have in my excel file? Example, in my excel file, I have 5 sheets open that contains sensitive data. So I want to put different password for each sheets. Can I do that? Thanks
Thanks for this video and for the level of simplicity in your explanation
Good one
Thank you very much, SIR
LOVE Mont St Michel!
Love this video 💯
Thank you
Thanks dear,,, I got it..
Am very appreciative sir
When i have a lot of sheets, in the same document but i want to make a passcode just for one of theme
Thanks bro
Can you show me how to protect my document from it being copied and pasted elsewhere but also edit one column only can you help?
Kelvin, please your sound was very bad in this video relative to your other educative usual videos
How to prevent users from editing (lock) Excel when opened through in-App. From SharePoint... without using a password. Just a simple LOCK until I have closed the excel sheet
Does this function exist?
This function is possible with IBM box. I don't know about SharePoint
thanks
Is there any way to do it in a single sheet instead of doing it to the whole workbook?
How do you password protect a sheet that within a bigger workbook?
Thanks
How do I update my password once I already have one
i have a excel workbook as sales , it has a 10 sheets for 10 sales person , i shared the workbook in drive , i want to lock each sheet in workbook using deferent password and one person cant open other person sheet , how to lock or hide work sheet please help me
what they protect for??
Thank you so much..!!
Thanks a lot ❤️❤️❤️
ThankYou! 🤝
Very useful, but lot of talk before and after. Should be a 30 second video .
How to lock google gmail excel spreadsheet file?
How to change password in excell sheet
so , after user login with password, the sheet is unprotected permanently and the next users/other user can open without password?
Great!
I don’t get the options to encrypt with password as you state in 1:58
super job!
Hi
Sorry you have to say how we can unlock
Microsoft employee who doesn't know the difference between "book" and "sheet"
Don’t be a dick
Why are you so mean and bitter. You watched this video bcos u need help, right?
Why not take the help and apply it where it needs to be applied.
Are you about mistake mr/Mrs perfect?
@@somtochukwuasom given this was a year ago! I can't remember. However I imagine I was looking for the alternate version of what was promised in the title.
Hello Kevin, I have problem, Why i cannot save my excel sheet, it says file is "READ ONLY" though on properties read only is already uncheck. i tried to uninstall and install different office from 2016 to 2019 to 2021,, but still i cannot save my work on excel. when i SAVE AS and open again the file and save it again.. it says the same thing. " need to save file from different location which is it sucks!😒
Why excel doesn't let me use a password on other language? Is there a way to do it?
How to change password?
Thanks Dude