How to Protect Excel Sheet with Password | Lock Excel Sheet

In this tutorial, learn how you can password protect a Microsoft Excel workbook.

As full-disclosure, I work at Microsoft as a full-time employee.

[dannishiman]

Thank for the tutorial. You help me with my assignment

[semomothelasagarankele]

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

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

[iriselbers]

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

[RM-hjzo]

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

[elhimxreynoso]

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

[Moeunvanlong]

Thanks sir for your good videos. thanks you so much

[kwamebuanyinaohemeng]

Do we have a similar feature for Power BI?

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

[Theophilus]

Is it possible to put different passwords on each tab?

[ZillianRain-pdjk]

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

[bkvending]

How do you password protect a sheet that within a bigger workbook?

[praseejtr]

How to open protect pdf file with out password

[godwinegeruan]

What if you had multiple sheets in a book and want to protect just a single sheet

[TusharGautam]

Special chat on CAT results and XAT!
(Chat Transcript)

nehal : HI
dipanjanbhowmik : Hello. What�s your query?

niha : HELLO
rajesh : yes please give inquiries

vaishu : CAT: 93.48 PERCENTILE GRAD: 74% ENGG 12TH : 73% 10TH: 93% GENERAL FEMALE SHOULD I TAKE A CHANCE FOR GDPI? AND FOR WHICH CLGS?
vinnayraj : you should apply to the iits once the applications are open and prepare for gdpi..iit m, iit kh, iit k, iit r..

prashant08 : HELLO
rahulpinnamaneni : Hi, what's your query?

m : SIR MY CAT PERCENTILE IS 81.17 10TH IS 64.6 PERCENT 12TH IS 54.4 PERCENT WHICH COLLEGES I CAN APPLY WITH CAT???
rahulpinnamaneni : Around 80-84.9 Percentile: National Institute of Technology Tiruchirappalli (NITT) T.A.Pai Management Institute (TAPMI) Institute of Rural Management (IRMA), Anand Lal Bahadur Shastri Institute of Management (LBSIM), New Delhi Prin. L. N. Welingkar Institute of Management Development & Research (WE School), Mumbai Institute for Financial Management and Research (IFMR), Chennai Loyola Institute of Business Administration (LIBA), Chennai University Business School (UBS), Chandigarh

siddy : HI
rahulpinnamaneni : Hi, what's your query?

jyoti : 92.7 PERCENTILE
dipanjanbhowmik : Congratulations! What�s your query?

dlca : SIR, I GOT 84 PERCENTILE IN CAT, WHICH COLLEGES SHOULD I APPLY FOR?
raghavenderj : LIBA-Chennai, IFMR, NIBM-Pune, NIRMA-Hyd. You may also apply to TAPMI-Manipal

dlca : SIR, I GOT 84 PERCENTILE IN CAT, WHICH COLLEGES SHOULD I APPLY FOR?
vinnayraj : you can consider applying to Tapmi, irma, k j somaiy, liba, ifmr, bim trichy..

student : I AM A COMMERCE STUDENT AND HAVE GOT 99.9%ILE IN CAT. APART FROM ACADEMICS, WHAT ALL TOPICS SHOULD I READ ABOUT?
pradeeppandey : Please go through the GDPI briefcase in the comprehensive manner.

kxca9a119 : WHAT COLLEGES CAN I EXPEXT WITH 79.12 %ILE GENERAL CATEGORY 90%IN 10TH 85% IN 12TH FINAL YR GRADUATION 54% TILL 2ND YR
tarannumraza : IIFM, CUIM, IISWBM, GIM(Goa), XIME(Bangalore), SIESCOMS, Delhi School of Management(DTU)

sakinaka : SIR IN IIM A, DO WE HAVE TO SUBMIT CERTIFICATES OF ALL THE ACHIEVEMENTS WE WRITE ? WHAT TO DO IF WE DONT HAVE CERTIFICATES?
rajesh : cpuld you tell me in what regard

akash : GOT 75%. WHICH COLLEGES NEED TO BE APPLIED CONSIDERING ROI?
rahulpinnamaneni : Around 70-79.9 Percentile: Institute of Management, Nirma University, Ahmedabad Christ University Institute of Management (CUIM), Bengaluru NIBM Pune (73-80) Birla Institute of Management Technology (BIMTECH), Noida Indian Institute of Forest Management (IIFM), Bhopal Prin. L. N. Welingkar Institute of Management Development & Research (WE School), Bengaluru Hyderabad Central University (HCU) Indian Institute of Social Welfare and Business Management (IISWBM), Kolkata XIME Bangalore National Insurance Academy Pune (General 65%ile, SC/ST/DA 55%ile) NIT Calicut

niha : I HAVE GOT 84.77 PERCENTILE IN CAT, COULD YOU PLEASE SUGGEST SOME GOOD COLLEGES
rahulpinnamaneni :​​Around 85-89.9 Percentile: International Management Institute (IMI), New Delhi K. J. Somaiya Institute of Management Studies and Research (SIMSR) Bharathidasan Institute of Management (BIM), School of Excellence of Bharathidasan University, Trichy Goa Institute of Management Goa S.P. Jain Institute of Management & Research (SPJIMR) (Profile-based First Shortlist) FORE School of Management, New Delhi Around 80-84.9 Percentile: National Institute of Technology Tiruchirappalli (NITT) T.A.Pai Management Institute (TAPMI) Institute of Rural Management (IRMA), Anand Lal Bahadur Shastri Institute of Management (LBSIM), New Delhi Prin. L. N. Welingkar Institute of Management Development & Research (WE School), Mumbai Institute for Financial Management and Research (IFMR), Chennai Loyola Institute of Business Administration (LIBA), Chennai University Business School (UBS), Chandigarh

akhil : I AM MALE GENERAL ENGINEER. I HAVE GOT 95.07 IN CAT. X, XII, GRAD - 90, 93, 75 RESP. WHICH COLLEGES SHOULD I LOOK FOR?
amitpoddar : IITs, NITIE, SP JAIN, DFS, DBE, DSE, MDI HR.

amyfarah : CAT PERCENTILE 84.75 WHICH COLLEGES TO APPLY
pradeeppandey : IFMR, KJSom, BIM Trichy, IRMA, TAPMI, GLIM, LIBA etc

jyoti : 92.7 PERCETILE IN CAT, 10TH- 96, 12TH 89, GRADUATION 65, 35 MONTH WORK EXPERIENCE, WHAT ARE THE BSCHOOLS I CAN HOPE TO GET INTO? REALISTICALLY
rahulpinnamaneni : Around 95-98 Percentile: National Institute of Industrial Engineering (NITIE) Department of Management Studies, Indian Institute of Technology Delhi (IITD) Management Development Institute (MDI) - Gurgaon S.P. Jain Institute of Management & Research (SPJIMR) (Second shortlist ) Department of Management Studies (DoMS), Indian Institute of Technology Madras (IITM)

[yrstanisijha]

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

[kimtiu]

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

[thatberkshirecyclist]

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

[emmanuelemokpae]

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

[alejandro]

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