This article was co-authored by How.com.vn staff writer, Rain Kengly. Rain Kengly is a How.com.vn Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 266,595 times.
Learn more...
Do you have an important Excel file you want to protect? You can easily lock your Excel workbook with a password. For even more safety, you can set the spreadsheet as "Read Only". This prevents accidental editing from any viewers. Be sure to use a password you can remember, as you won't be able to reset it. This How.com.vn will show you how to password-protect a file in Microsoft Excel using your Windows or Mac computer.
Things You Should Know
- Click "File" → "Info" → "Protect Workbook" → "Encrypt with Password". Enter a password twice and click "OK".
- To set as Read-Only, click "File" → "Info" → "Protect Workbook" → "Always Open Read-Only".
- Be sure to use a password you can remember; you won't be able to reset it if you forget.
Steps
- Open a project in Microsoft Excel. If needed, you can create a new spreadsheet.[1]
- Microsoft Excel is available to download on Windows and Mac. You can also use the online web version at https://www.office.com/.
- Click File. This will be at the top-left corner of the window, next to Home.
- A new page will open.
Advertisement - Click Info. You can find this in the left panel.
- Click Protect Workbook. This is the first tile of the Info tab.
- A drop-down menu will open.
- Set as Read-Only (optional). If you want to prevent accidental changes from others when you share your workbook, you can set the workbook as "Read-Only". Keep in mind that others will be able to change this mode if they choose.
- Click Always Open Read-Only in the drop-down menu.
- You'll see an icon of a pencil and cancel symbol underneath Protect Workbook.
- Click Encrypt with Password. This will be below Always Open Read-Only.
- A pop-up box will open.
- Enter a password and click OK. Keep in mind you won't be able to reset or recover the password if you forget it. Be sure to use a password you can remember.
- Re-enter the password and click OK. Input the same password as the previous step.
- You should now see a lock and key icon underneath Protect Workbook.
- Close the workbook. If you're prompted to save, be sure to save. When you open the workbook again, you'll be asked to enter in your password.
- Open a project in Microsoft Excel. If needed, you can create a new one.
- Click Review. This is the tab at the top, next to Data.
- Click Protect Workbook. This is in the "Changes" section.
- Check the "Structure" box. If you have also set up specific windows within the file, check the pertinent box as well.
- Type in your password. Be sure to use a password you can remember, as you won't be able to reset it. You may need to do this twice.
- Click OK. Your Excel file is now password-protected. When you open it, you'll be asked to input your password.
Community Q&A
- QuestionI have made a sheet in Excel which contains 2000 names and addresses, so now I want to make this sequenced. First a, then after that b, c, etc. How do I do this?Sylvia SaltaformajoCommunity AnswerRight-click on the column you want to sort your sheet by. A menu will open. Hover over the "Sort" option in it. You will see another menu, click "Sort A to Z" in it.
- QuestionWhat do I do if I forgot the password?Sylvia SaltaformajoCommunity AnswerUnfortunately you can't recover forgotten passwords for MS Excel spreadsheets. You'll have to recreate a document or recover password using special software. You can find it online, there are many options: Password-Find, Password Lastic, Rixler password recovery, etc.
Video
Tips
Warnings
- Password protecting your Excel sheet will keep the average user from messing around in your files, but a determined user can purchase password-cracking software to view your sheets.Thanks
References
About This Article
1.Open the file.
2.Click File.
3.Click Protect Workbook.
4.Click Encrypt with Password.
5.Enter a password.
6.Click OK.
7.Close the document.
8.Reopen and enter the password.
Reader Success Stories
- "How to protect a workbook or worksheet."
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.