How to Password Protect an Excel File
Learn how to password protect an Excel file, choose file encryption or sheet protection, avoid lockout mistakes, troubleshoot, and read FAQs.
Quick Answer
To password protect an Excel file, open File > Info > Protect Workbook > Encrypt with Password, enter a strong password, save the workbook, close it, and reopen it to test the password.
What You Need
- Excel workbook
- Microsoft Excel
- Strong password
- Secure place to store password
- Backup copy
Safety Precautions
- Keep a backup before encrypting.
- Store the password securely because forgotten passwords may not be recoverable.
- Do not email the file and password together.
- Know the difference between workbook encryption and sheet protection.
- Use secure sharing for highly sensitive files.
Step-by-Step Instructions
- Step 1
Save a backup
Create a safe copy before changing protection.
- Step 2
Open File info
Choose File > Info in Excel.
- Step 3
Protect workbook
Select Protect Workbook.
- Step 4
Encrypt with password
Enter a strong password carefully.
- Step 5
Save workbook
Save the encrypted file.
- Step 6
Close and test
Reopen it and confirm the password prompt appears.
- Step 7
Share securely
Send the password through a separate trusted channel.
Practical Example
Example: You encrypt a budget workbook, save it, reopen it to test, then share the password by phone instead of email.
Common Mistakes
- Forgetting the password
- Confusing sheet protection with file encryption
- Sending password with the file
- Skipping backup
- Using weak passwords
- Not testing the file
Troubleshooting
Password was forgotten
Use your backup; Excel encryption is designed to be hard to bypass.
People can still edit cells
Use sheet protection in addition to file encryption if needed.
Recipient cannot open file
Confirm password, Excel version, and file type.
Need to remove password
Open the file, return to Encrypt with Password, clear the password, and save.
Helpful Internal Links
FAQs
Is sheet protection the same as password encryption?
No, encryption protects opening the file; sheet protection controls editing.
Can Excel recover forgotten passwords?
Not reliably for encrypted files, so store passwords safely.
Should I use a strong password?
Yes, use a unique strong password.
Can I password protect only one sheet?
Yes, use sheet protection for editing controls.
Related Guides
How to Remove Duplicates in Excel
Learn how to remove duplicates in Excel, choose columns, protect original data, use conditional formatting, troubleshoot mistakes, and read FAQs.
How to Password Protect a PDF
Learn how to password protect a PDF safely, choose a strong password, understand limits, avoid mistakes, troubleshoot access, and read FAQs.
How to Apply Conditional Formatting in Excel
Highlight values, duplicates, dates or formula-based conditions in Excel and manage rule order and cell references.
Help us improve this guide
Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.