How to Password Protect an Excel File — Step-by-Step Guide

Whether you're protecting sensitive financial data, employee records, or personal budgets — Excel makes it easy to password-protect your files. This guide covers all three protection levels and how to remove them.

3 Levels of Excel Protection

1. File-level password: Nobody can open the file without the password
2. Workbook protection: Can open and view, but can't add/delete/rename sheets
3. Sheet protection: Can view the sheet, but can't edit specific cells

Method 1: Password Protect the Entire File

1. Open your Excel file
2. Click File → Info
3. Click Protect Workbook
4. Select Encrypt with Password
5. Type your password (must type it twice)
6. Click OK → then Save (Ctrl + S)

Now, anyone who opens this file will be prompted for the password before seeing any content.

Method 2: Protect Specific Sheets

Share the file but prevent editing specific sheets:

1. Right-click the sheet tab at the bottom
2. Select Protect Sheet
3. Enter an optional password
4. Check what actions users can still perform
5. Click OK

Method 3: Protect Workbook Structure

1. Review tab → Protect Workbook
2. Enter a password
3. Click OK

Users can now view and edit cell contents, but cannot add, delete, move, or rename sheets.

How to Remove Password Protection

1. Open the file (enter the password when prompted)
2. File → Info → Protect Workbook → Encrypt with Password
3. Delete the password from the field (leave it empty)
4. Click OK → Save

Password Security Best Practices

• Use at least 12 characters with uppercase, lowercase, numbers, and symbols
• Save passwords in a password manager like Bitwarden (free) or 1Password
• Test the password immediately after setting it — close and reopen the file
• Don't email passwords in the same message as the protected file
• Keep a backup without the password if you might need emergency access

What Encryption Does Excel Use?

Excel 2013 and newer uses AES-256 encryption — the same standard used by governments, banks, and military organizations. With a strong password, brute-force attacks are computationally infeasible.

Older .xls files (Excel 2003 and earlier) use weaker encryption. Always save as .xlsx for proper security.

What To Do If You Forget the Password

There's no built-in recovery. Microsoft cannot help. Third-party tools exist for password recovery but take hours to days for complex passwords and aren't guaranteed. Prevention is the only real solution.