How to Remove a Password From Excel Files: Complete Guide 2026 October

To remove a password from an Excel file you own, open it, then clear the password where it was set: File > Info > Protect Workbook > Encrypt with Password for the open password, Review > Unprotect Sheet for a sheet password, and Review > Protect Workbook for structure protection. Microsoft cannot retrieve a forgotten password, so this only works when you already know the password.

Why Excel Files Get Password-Protected

Excel offers two main password layers and a few smaller ones. Workbook open passwords prevent anyone from viewing the file without the correct password. Sheet protection passwords prevent editing of specific worksheet ranges without permission. Workbook structure passwords prevent adding, deleting, or rearranging sheets. Each layer serves a different purpose and is removed through different procedures within Excel. Knowing which type of password you face is the first step in figuring out how to remove it. The wrong removal method will fail, sometimes confusingly, when applied to the wrong password layer.

Most professional users encounter password-protected workbooks shared between colleagues, exported from accounting or HR systems, or downloaded from secure portals. Sheet protection appears constantly in financial models where certain ranges hold formulas the workbook author does not want changed. Workbook structure protection shows up in templates designed to be filled out without altering the underlying template structure. Removing a password assumes you have legitimate access to do so, either because you set it yourself or because the owner authorized the change. Removing passwords from files you do not own is generally improper and may violate workplace policies or applicable laws.

Removing a Workbook Open Password

When you have the password and want to remove the open-password requirement entirely, the process is short. Open the workbook by entering the password when prompted. Once the file is open, go to the File menu and select Info. Click Protect Workbook, then choose Encrypt with Password.

A dialog will appear showing the existing password as obscured dots. Delete all the dots in the field and click OK. The dialog closes. Now save the file. The next time anyone opens it, no password will be required. The change persists until someone adds a new password through the same workflow.

In older Excel versions (2010 and earlier), the menu path differs. The Save As dialog includes a Tools dropdown with General Options that lets you set or clear the open password and the modify password. Both fields can be cleared by deleting their contents and saving the file. Modern Excel versions (2013 and later) handle this through the File menu Info workflow described above. If you cannot find the encrypt menu, try the Save As approach as a fallback for any version. excel covers common file operations in detail.

Organization-wide password policies typically govern minimum password length and complexity even for personal Excel file protection. Following these policies ensures your password strength matches the sensitivity of the data the file contains.

File encryption locks the whole file so other users cannot open it, according to Microsoft's protection overview. Microsoft states that if you forget or lose the password it cannot retrieve it for you.

Removing Sheet Protection

Sheet protection is the most common Excel password layer. It prevents users from editing locked cells on a specific worksheet. To remove sheet protection when you know the password, go to the Review tab on the ribbon and click Unprotect Sheet. Enter the password when prompted.

The protection lifts immediately, and you can now edit any cell on that sheet, including formula cells that were previously locked. Save the file to make the change permanent. If you only need to edit a few cells temporarily without permanently removing protection, copy the relevant range to a new workbook, edit, and copy back, rather than disabling the protection structure.

Sheet protection in financial models often hides formula cells from end users while leaving input cells editable. Removing the protection breaks this pattern unless you reprotect with adjusted settings afterward. Before removing sheet protection on a shared file, document the original protected ranges and unlock states so you can restore them after making your edits. Many spreadsheets break when protection is removed and not restored because dependent users start typing into formula cells that should have remained locked, corrupting downstream calculations across the workbook.

Excel sheet protection includes several granular options the protecting author can configure. Allow users to select locked cells, format cells, format columns, format rows, insert columns, delete rows, sort, use AutoFilter, and use PivotTable reports are all separately controllable. When you remove sheet protection and later restore it, restoring the original granular permissions requires knowing which options were originally enabled. Document these settings before removing protection if you intend to restore them after editing the workbook.

Excel Password Types and How to Remove Each

Sources: Microsoft Support articles on protecting a worksheet, protection and security in Excel, and changing or removing workbook passwords.

Removing Workbook Structure Protection

Workbook structure protection prevents adding, deleting, hiding, unhiding, or renaming sheets. It is set through the Review tab using Protect Workbook (note the difference from Protect Sheet — they are separate features). To remove the protection when you know the password, open the Review tab and click Protect Workbook, which acts as the toggle while structure protection is on. Enter the password if prompted. The protection lifts. You can now manage sheets normally. Save to preserve the change. This protection is sometimes confused with the workbook open password but operates entirely differently and is removed through the Review tab rather than the File menu.

Workbook structure protection commonly appears in template files where the author wants users to add data to existing sheets but not rearrange the workbook layout. Templates from accounting firms, HR systems, and financial planning software often use this protection to maintain template integrity. When you remove structure protection legitimately, document the original protected state and plan to restore it afterward unless the template will not be reused. Otherwise the next user receives a template without the protection that the author intended to maintain.

Forgotten Passwords and Recovery Options

Microsoft states plainly that if you forget or lose an Excel password, Microsoft cannot retrieve it for you. That applies to the open password and to sheet and workbook-structure passwords alike, so this guide does not cover ways around a password you do not know.

If you forgot the password to your own file, use official routes. First, check a password manager or any note where you stored it. Second, look for an earlier unprotected copy: OneDrive or SharePoint version history, a backup, or an earlier email attachment. Third, ask the person who created or shared the file to supply the password or an unprotected copy. For a file at work, contact your IT administrator, who may hold approved recovery or backup options.

Microsoft also notes that worksheet-level protection is not intended as a security feature. It only stops users from changing locked cells, which is why it suits preventing accidental edits rather than guarding sensitive data.

Alternative Protection Methods to Consider

Before removing a password entirely, consider whether a different protection method might serve your needs better. Workbook open passwords protect entire files but are an all-or-nothing access mechanism. Sheet protection lets you selectively protect specific ranges while allowing edits elsewhere. Workbook structure protection prevents layout changes without restricting data entry. For files shared across teams, sheet protection often provides the right balance between collaboration and integrity. The right protection model depends on what you are actually trying to prevent and who needs what level of access.

Microsoft has also expanded its Information Rights Management capabilities through Microsoft 365 and Azure Information Protection. These tools provide more granular access control than traditional Excel passwords. Files can be encrypted with policies that restrict what specific users can do (view only, view and edit, full control) and that revoke access based on time, location, or company policy. For organizations with sensitive financial or HR data, IRM is generally a more strong protection model than relying on Excel-native passwords that can be removed by anyone with the password and the right knowledge of the menus.

Excel also supports digital signatures as a verification mechanism separate from password protection. Digital signatures confirm that a file came from a specific author and has not been modified since signing. This is different from preventing access entirely. For shared analytical files where you want to confirm integrity rather than restrict access, digital signatures may be more appropriate than passwords. Microsoft 365 includes built-in digital signature support and integrates with enterprise certificate authorities for organizations needing this verification model.

Common Mistakes During Password Removal

The biggest mistake is removing the wrong type of password. Users sometimes try to remove a workbook open password through the Review tab and get nowhere because the Review tab only handles sheet and structure protection. The opposite also happens — users try to remove sheet protection through the File menu Encrypt with Password workflow, which only handles workbook open passwords. Knowing which menu corresponds to which password type saves significant frustration. The general rule: File menu handles file-level access, Review tab handles content-level protection.

Another common mistake is forgetting to save the file after removing protection. The change persists only after saving. Closing the file without saving discards the password removal and the next person to open the file still encounters the original protection. This catches users frequently when they remove protection, make changes, and then close without saving in a hurry. Save immediately after removing the password to lock in the change before doing anything else with the workbook.

Users also sometimes encounter password prompts for files they did not realize were protected. This often happens when files transition between organizations or when a colleague applies protection without communicating that change. If you suddenly need a password for a file you previously edited freely, check with the original author to verify whether protection was added intentionally or whether the file was corrupted in a way that mimics protection prompts during opening attempts.

Best Practices for Excel Password Management

Document passwords in a secure password manager rather than relying on memory or sticky notes. Tools like 1Password, LastPass, Bitwarden, and KeePass let you store Excel file passwords alongside other credentials with strong encryption. This prevents the all-too-common scenario where you create a strong workbook password, forget it three months later, and lose access to your own work permanently. The password manager approach also works well in organizations where multiple people need access to the same protected files but should not all know the password directly.

For organizations sharing protected Excel files, consider establishing a standard naming convention for protected files (such as adding PROTECTED to filenames) and a process for managing the passwords centrally. IT departments at larger organizations often run dedicated secure file repositories that handle access control more reliably than per-file Excel passwords. Migrating sensitive workbooks to managed SharePoint sites, OneDrive folders, or dedicated document management systems eliminates the need for Excel passwords entirely while improving security through audit trails and revocable access permissions.

Avoid embedding passwords in email or chat communications. Anyone who later accesses the email archive sees the password alongside the file. Instead, share files and passwords through separate channels — file via email attachment, password via Signal message or phone call. This basic separation reduces the risk of casual exposure significantly. For files containing sensitive financial or HR data, this small workflow change improves security without requiring any new tools or technology investments.