You can password protect an Excel file in under two minutes on Windows or Mac: open the workbook, go to File > Info > Protect Workbook > Encrypt with Password, type the password twice, and save. From that point, anyone opening the file must enter the password before a single cell appears. The boundary matters: this protects the file from being opened, not from being edited by someone who already has it open, and Excel's encryption is only as strong as the password you choose.
That distinction between "open" protection and "modify" protection trips up most people, so this guide separates them cleanly. It also covers what happens when you forget the password—no, Microsoft cannot recover it—how the same job looks in Excel for the web and on mobile, and the encryption standard behind the dialog box.
What "Password Protect" Actually Means in Excel
Excel offers four different protections, and they are not interchangeable. "Encrypt with Password" applies AES encryption to the entire file, so the content is unreadable without the password. "Protect Workbook" locks the structure—preventing sheets from being added, deleted, hidden, or renamed. "Protect Sheet" restricts editing inside a worksheet. "Mark as Final" only sets a read-only recommendation, and anyone can click past it in two clicks.
The encryption route is the one that matters when the file leaves your control—email attachments, USB drives, cloud links. Excel's Encrypt with Password uses AES-256 by default in Microsoft 365 and Excel 2016 and later; older .xls files use weaker legacy encryption (RC4 or 40-bit), which is one reason to save as .xlsx before you protect anything. Microsoft documents the cipher choice in its support pages on file protection.
One practical consequence: a password-protected .xlsx is converted to an encrypted OLE compound file internally. That means third-party preview tools—Gmail's attachment preview, some SharePoint search indexers, antivirus scanners with limited file-type support—may fail to open or scan it. If your workflow depends on automated processing, test the protected file against those systems before you distribute it.
The feature is not a substitute for document rights management. Anyone who knows or guesses the password has full access, and anyone who can copy the file can attempt offline attacks against it. Encryption raises the cost of unauthorized access; it doesn't eliminate it.
Step-by-Step: Encrypt With a Password on Windows or Mac
This is the real order of operations on Excel for Microsoft 365 desktop (Windows and Mac behave nearly identically), and it's the method to use for any file that will travel outside your organization.
1: Open the workbook and save it as .xlsx (File > Save As, choose Excel Workbook). Skip this only if it already is one. 2: Go to File > Info. 3: Click Protect Workbook, then choose Encrypt with Password. 4: Type the password in the Password box. Excel shows dots; there is no strength meter, so decide on length before you type. 5: Click OK, retype the same password in Reenter password, and click OK again. 6: Save the file (Ctrl+S or Cmd+S). The protection only takes effect once saved. 7: Close and reopen the file to confirm Excel prompts for the password.
Failure handling: if you mistype at step 5 and Excel says the passwords don't match, nothing is applied—start again at step 3. If you save and then realize you wanted a different password, repeat steps 2–6; Excel replaces the old password without asking for it, because you already have the file open. To remove protection entirely, follow the same path, delete the dots in the Password box, click OK, and save.
On Mac, the menus are the same but File > Info may appear as File > Protect Workbook depending on version; in Excel for Mac 16.x the Encrypt option sits under the Review tab in some builds. If you can't find it, use Review > Protect Workbook as the alternate path—the dialog is identical.
Sheet and Workbook Protection Are a Different Lock
Sheet protection stops edits inside a worksheet; it does not encrypt the file, and it does not stop anyone from opening it. Use it when you're sharing a working file and want to guard formulas, headers, or structure while still letting people read the data. The path: Review > Protect Sheet, set an optional password, and pick which actions remain allowed (selecting cells, formatting, sorting).
By default, Protect Sheet allows selecting locked and unlocked cells only, and every cell is locked once protection is on unless you pre-unlocked it via Format Cells > Protection. That default confuses people who protect a sheet and then find they can't type anywhere—unlock the input cells before protecting, or tick the relevant allowances in the Protect Sheet dialog.
Workbook protection (Review > Protect Workbook) guards structure: sheet tabs can't be deleted, moved, hidden, or renamed, and new sheets can't be inserted. It's useful for templates and dashboards. The critical weakness: sheet and workbook protection passwords are trivially bypassed by anyone with basic scripting knowledge—they're deterrents, not security. Treat them as speed bumps for honest colleagues.
Combine the two when it fits. Encrypt with Password for the "can't open it" layer, Protect Sheet for the "can't break my formulas" layer, and Protect Workbook for the "can't rearrange my tabs" layer. Each solves a different problem.
Excel for the Web and Mobile: What You Can and Can't Do
Excel for the web (the browser version at Microsoft 365) cannot set an open password. The Encrypt with Password option is absent from the browser interface entirely; files that are already encrypted will prompt for the password to open, but you can't add or change protection there. Microsoft's own support documentation points users to the desktop app for this task, and that's the accurate answer—don't hunt for a hidden menu.
The mobile apps behave differently again. On Excel for iOS and Android, you can open password-protected workbooks by entering the password, but setting a new open password is not supported in the mobile UI as of the versions current in late 2026. Sheet protection can be toggled in some mobile builds under the Review-adjacent menus, but it's inconsistent across platforms.
| Platform | Encrypt with Password (open) | Protect Sheet | Protect Workbook |
|---|---|---|---|
| Excel for Microsoft 365, Windows | Yes | Yes | Yes |
| Excel for Microsoft 365, Mac | Yes | Yes | Yes |
| Excel for the web | No | Yes (limited) | No |
| Excel for iOS | No | Limited | No |
| Excel for Android | No | Limited | No |
The workaround for web and mobile users is straightforward: set the password once on a desktop machine, save to OneDrive or SharePoint, and everyone else simply enters it. If you only have a browser, the honest answer is that you need the desktop app—Excel for the web is deliberately not the tool for this job.
Choosing a Password Excel Can't Be Brute-Forced Out Of
Excel's AES-256 encryption is strong; the password is the weak link. A short or dictionary-based password falls to offline guessing tools, and there's no lockout, no rate limit, and no server logging failed attempts—an attacker with the file can try passwords as fast as their hardware allows. Modern GPU-based cracking rigs test billions of guesses per second against weak hashes; against AES-256 with a strong passphrase, the same rig makes no practical progress.
Length beats complexity. A 16-character passphrase of four random words ("harbor-oxide-tunnel-mango") is both easier to remember and vastly harder to crack than "P@ssw0rd!23". Microsoft's own guidance in its security documentation recommends 12 characters minimum and favors length over forced symbol substitution, which matches what password-cracking research has shown for years.
Practical rules for this specific job: 16 characters or more, randomly generated if you'll store it in a manager. Don't reuse a password from any other account—the file may outlive the account. Store it in a password manager, not in the file's own metadata, not in a sticky note on the monitor, and not in the same email thread as the attachment. If you're distributing to a team, send the password through a different channel than the file (file by email, password by chat or phone).
The cost of getting this wrong is asymmetric. A crackable password gives an attacker the entire workbook and no record of the attempt; a strong one makes the file genuinely resistant to anyone without the passphrase.
When You Forget the Password (and Why Microsoft Won't Help)
Microsoft cannot recover or reset a forgotten Excel password. This isn't a policy stance—it's the design. The encryption key is derived from the password, and Microsoft never stores the key or the password. The company's support pages state this plainly, and there is no "account recovery" path for file-level encryption the way there is for a Microsoft account sign-in.
Legitimate recovery options, in order of practicality:
1: Search your password manager and browser autofill history before anything else. Most "lost" passwords were saved somewhere. 2: Check older saved copies of the file, or the previous version in OneDrive/SharePoint version history, if you protected it after an edit—version history holds up to 500 versions for Microsoft 365 in OneDrive depending on plan settings. 3: Ask whoever set the password, if that isn't you. Obvious, and it resolves most workplace cases. 4: Restore from backup if an unprotected copy exists anywhere.
Third-party "Excel password recovery" tools exist, and their honest categorization matters. They can sometimes remove sheet or workbook protection quickly, because those protections are weak. For open-password (AES) encryption, they work only by guessing—dictionary attacks, brute force, or purchased rainbow tables—and their success depends entirely on password strength. They are not magic, and paying for one to crack a strong passphrase is money wasted.
The lesson is to protect the password, not just the file. Store it in a manager, tell a trusted colleague if the file is business-critical, and keep one unencrypted backup of irreplaceable work in a secured location—accepting the small risk that backup carries in exchange for avoiding permanent lockout.
Where the Password Goes Wrong: Edge Cases Worth Knowing
Encryption breaks some workflows quietly. SharePoint and OneDrive search can't index the contents of an encrypted workbook, so full-text search across your library will skip it—users searching for a phrase inside the file will find nothing. Copilot and other AI features in Microsoft 365 also can't read encrypted files until they're opened and decrypted. If discoverability matters, that's a real trade-off.
Macro-enabled workbooks (.xlsm) can be encrypted the same way, and the macros stay intact—but security software often refuses to scan encrypted Office files, so an organization with strict malware scanning may quarantine the attachment. Test before distributing .xlsm files with passwords.
Shared workbooks (the old multi-user editing feature) and encrypted files don't cooperate well. Co-authoring in Microsoft 365 requires the file to be unencrypted; the moment you add a password, real-time co-authoring stops working and collaborators must check out and back in. This catches teams by surprise mid-project.
Compression doesn't weaken encryption, but it does cause confusion: a password-protected .xlsx inside a zip file is still protected, and people sometimes think zipping it adds security. It adds nothing. The one-file, one-password rule is cleaner.
How Excel's Protection Compares to PDF and Zip Passwords
People often ask whether Excel's password is "as good as" a PDF password, and the comparison is uneven. A PDF with AES-256 user-password encryption (set in Acrobat, not in Word's free export) is comparable in strength to Excel's—same cipher, same key-derivation caveats. A zip file's password, by contrast, is only strong if you specifically create an AES-encrypted archive; the default legacy ZipCrypto is weak and crackable in hours with free tools.
| Format | Default encryption | Cracking resistance | Notes |
|---|---|---|---|
| .xlsx (Office 2016+) | AES-256 | High, if password strong | Microsoft 365 default |
| .xls (legacy) | RC4 / 40-bit | Low | Don't use for sensitive data |
| PDF (Acrobat AES-256) | AES-256 | High | Set in Acrobat, not free exporters |
| Zip (AES-256 option) | AES-256 if selected | High | Default ZipCrypto is weak |
| Zip (default) | ZipCrypto | Very low | Avoid for anything confidential |
The honest verdict: Excel's modern encryption is fine for business confidentiality—payroll, client lists, contract drafts—provided the password is long and randomly generated. What none of these formats solve is a recipient who deliberately forwards the file. Passwords travel with files unless you send them separately, and anyone with both has full access. If the requirement is "this person can read but never redistribute," file passwords can't deliver that; you need a rights-management service with revocation, and that's a different purchase.
Frequently Asked Questions
Can I password protect an Excel file in the free web version?
No—Excel for the web has no option to add an open password, and Microsoft's support pages direct users to the desktop app. You can open and enter a password on an already-encrypted file in the browser, but you can't set, change, or remove one there. Google Sheets offers no equivalent either, so the desktop application remains the tool for this task.
Does protecting a sheet count as password protecting the file?
It doesn't. Sheet protection locks edits inside a worksheet but leaves the file openable by anyone, and those protection passwords are easily removed by anyone with scripting knowledge. Only File > Info > Encrypt with Password produces real encryption that gates opening the file. Many people conflate the two and are surprised how little a sheet password stops.
Can I recover an Excel file if I forget the password?
Not through Microsoft—the company doesn't store your password or the key, and support has no reset path. Recovery means remembering the password, finding a backup or older version, or guessing with third-party tools, which only succeed against weak passwords. The practical defense is a password manager and one secured backup of irreplaceable work.
What happens to a password-protected file in SharePoint or OneDrive?
It opens only after the password is entered, and its contents aren't indexed for search or readable by Copilot until decrypted. Co-authoring stops working because real-time collaboration requires an unencrypted file. Those are real workflow costs, so encrypt files that leave the organization and leave working documents inside a permissioned SharePoint library instead.
Is Excel's password encryption actually secure in 2026?
The AES-256 encryption in .xlsx files is secure; the password is the variable. Long passphrases resist offline cracking for practical purposes, while short or common passwords fall quickly to GPU-based guessing. Legacy .xls files use weak RC4 encryption and should be resaved as .xlsx before protection. Verify your current build's behavior on Microsoft's support site.
How do I remove a password from an Excel file I know?
Open the file, enter the password, then go to File > Info > Protect Workbook > Encrypt with Password, clear the password field, click OK, and save. The file is now unprotected and should be stored only in a controlled location. If you're removing protection to enable co-authoring, tell collaborators why the file is now open.
Can someone crack an Excel password I set with 8 characters?
Often, yes—eight characters of mixed case and symbols is at the edge of what modern cracking hardware can handle, and eight lowercase letters falls fast. Going to 16 characters, especially a random four-word passphrase, moves the file from "crackable by a determined attacker" to "not practical to attack." Length is the single biggest lever you have.