How to Protect Excel Sheet with Password | Lock Excel Sheet

🔥 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.

[@KevinStratvert]

⚡ 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@Excel10tutorial]

And The Password is "password"

[@sweetlikethat4895]

Simple straight to the point! 👍🏼

[@paulholroyd8515]

Simple, clear, helpful - thank you

[@vru111]

FINALLY SUCH A SIMPLE THING AND IT TOOK ME SO LONG TO FIND THE RIGHT VIDEO

[@thechi-estbeauty]

Thanks for this!

[@iriselbers4705]

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).

[@dannishiman7250]

Thank for the tutorial. You help me with my assignment

[@lisagregory8303]

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.

[@noumaniqbal5653]

Loved this, concise and clear. Great job!

[@semomothelasagarankele2619]

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!!!!!!

[@russianhostplan-brand]

🔒 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! 👍🔐🔐

[@ahmadkay8280]

Very Clear & Easy Explanation !

[@kimtiu1668]

how about if i have multiple excel file to encrypt? Is there an easy way for this rather than putting it manually?

[@ClarisseRockinThatBow]

Great tutorial! Couldn't figure it out while in the workbook but now the light bulb went off over my head - thank you!

[@patiencechuene7303]

Thank you for this vd very helpful

[@cathleenjdickson2127]

Love this video. Simple yet clear.

[@soulrosebeauty5729]

Thank you!

[@DouroDayTrading]

Thank you! Great video, very helpful! Lachy😀

[@thatberkshirecyclist]

Jeeze Kevin! Sort out those audio levels! Made me jump out of my skin! in the first couple of seconds! :D

[@RandomFamiliaMexCan]

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

[@Indpendnt27]

Thanks, Kevin!

[@srivarshank9882]

Thank you so much for this info bro. its really helpful for me

[@balramgupta6023]

Best & Quick video!

[@rahanaashraf9348]

Thank you for this useful video.❤

[@scottring2743]

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! ; )

[@c.t.sutton8172]

Your videos are great

[@abduljaleel-se3ps]

Useful information thanks for uploading here.

[@rosemarycece8650]

Thank you 😘

[@jrnsereko3601]

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

[@jomarkham1060]

Hi, this is exactly what im looking for now, did you get a reply, or know how to do this? Thanks

[@fredatang4058]

Thanks, very useful !

[@LT-od7dg]

Thank you very much for the video!!!

[@palaniarumugam1533]

Thanks Kevin I also don't want people to access my sheet I'm an expert at Excel. Have a good day!

[@bordersurvivaltexas4332]

Thank you this was very helpful !

[@ca0987]

Omgeee thank youuu!!! Very staight forward!

[@Armstrong_N14]

Hey, say an excel file with multiple tab. Can we do this just on a specific one?

[@psychelein88]

Thank you very much!

[@user-yv7tr2ps7k]

thank you sir

[@defi_delo]

Thanks Kevin.

[@murtazabutt5646]

Excellent

[@marksummers463]

LOVE Mont St Michel!

[@shahzadrana739]

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.

[@fyrozshaik2162]

Thanks bro

[@chuckmichaels8520]

Thank you

[@maleekaa1]

Thank you very much, SIR

[@brendamartinezgomez2297]

Love this video 💯

[@milleniumtechnique4216]

thanks

[@3yrstanisijha599]

Next:Show me how to recover password protected excel file because I forgot the password of an excel file

[@nsican2485]

Thanks a lot. This helped

[@Anmol-vn5yl]

Thank you so much for this video x

[@azurehues976]

How can I remove the password?

[@rbb341]

Thanks

[@Sandy-sb3km]

Thank you so much!! Subscribed 🙂

[@ajithbuddhika1]

Thanks dear,,, I got it..

[@hmroque4382]

Hi Kevin, how can we protect formulas in a column?

[@rosemarylafferty6341]

Great!

[@thakurdas4704]

Good one

[@anshsinghal7249]

thanks a lot for the help brother

[@abdirahmanagane2903]

Am very appreciative sir

[@sasham1448]

Great video

[@shishirkumarthakur9669]

Will the sheet ask for password when we open it on a browser and not on excel app?

[@r.casagrande8689]

very helpful, man. thx

[@mohammedmohsin1162]

ohh thats great fabulous work

[@user-go7hz7fm3c]

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

[@elhimxreynoso9655]

Thanks for this video and for the level of simplicity in your explanation

[@Boogiehill]

THANKKKKKKKK YOUUUUUUU!!!!!

[@Moeunvanlong]

Thanks sir for your good videos. thanks you so much

[@fawmyum2213]

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

[@brendanthomas592]

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.

[@FatmaHabshi.]

Thanks a lot ❤️❤️❤️

[@dddoda]

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.

[@roshanghadigaonkar8267]

Thank you so much..!!

[@sheyreal_17]

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

[@kwamebuanyinaohemeng919]

Do we have a similar feature for Power BI?

[@sujaysuj5799]

ThankYou! 🤝

[@alejandro12613]

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!😒

[@philippamorton1277]

Does this work for excel online? Or do you have to open in desktop version each time?

[@ZillianRain-pd7jk]

so , after user login with password, the sheet is unprotected permanently and the next users/other user can open without password?

[@abc123abc97]

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?

[@emmanuelemokpae9464]

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

[@sueslessor9365]

how to protect one of the TABS if you have several in one document

[@JotaPTrindade]

Is there any way to do it in a single sheet instead of doing it to the whole workbook?

[@charalamposkounes5071]

Why excel doesn't let me use a password on other language? Is there a way to do it?

[@gurnanis]

Hey thanks a ton, how do you remove the password lock if you need to please?

[@Theophilus2712]

Is it possible to put different passwords on each tab?

[@naureens3650]

I don’t get the options to encrypt with password as you state in 1:58

[@2023Red]

super job!

[@isaacosei3607]

Kelvin, please your sound was very bad in this video relative to your other educative usual videos

[@dom12011]

Can you do this for an iPad

[@halilousamir1244]

When i have a lot of sheets, in the same document but i want to make a passcode just for one of theme

[@syedmehaboobjbasha4007]

I learn this technique

[@cretnotonic]

What if only 1 tab is password protected? I tried Right Clicking on the tab and clicked on "Unprotect Sheet" a password box popped up. I entered the password and it didn't work.

[@xozeintk8093]

Thanks Dude

[@aryanpandey3847]

Thnx

[@kanakvashisht3855]

could you please do a video for what if analysis

[@ismaildhulub9155]

Thanks alot

[@justinsmith949]

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.

[@hm1056]

Please let me know if you got to know how to

[@obafemiemilola4975]

Right click on each of the sheets and click protect sheet, put password on each

[@SK-my9ts]

Very useful, but lot of talk before and after. Should be a 30 second video .

[@caroltanting3226]

Hi, do you have a video on how to put password in Google drive ? Thanks

[@micwell2247]

How do I unlock it ? I didn't lock nor did I use a password. It's locked some how and I do not know how to unlock it...I'm using the free side of the app.

[@RM-hj7zo]

Microsoft employee who doesn't know the difference between "book" and "sheet"

[@seanhogan7552]

Don’t be a dick

[@somtochukwuasom]

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?

[@RM-hj7zo]

@@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.

[@dianedelabano1119]

How do I update my password once I already have one