You can remove a password from an Excel file in a few minutes using the same program you use to open it

If you set a password to protect an Excel file and now want to remove it, Excel lets you do that directly. The steps depend on whether the password protects opening the file itself, or just prevents editing. Both are straightforward — you open the file with the password, then save it again without one.

The process works the same way in Excel on Windows, Mac, and the web version. You do not need special software or workarounds. If you have forgotten the password, though, there is no built-in recovery method, and you will need a different approach.

Key Takeaways

  • To remove a password, open the file with the password, then use File > Info > Protect Workbook to turn off protection.
  • A password that prevents opening the file is different from one that prevents editing — each removes differently.
  • If you have forgotten the password, Excel has no recovery tool, and you will need to use a third-party program or contact whoever set the password.
  • Removing a password you set yourself takes under five minutes and requires only Excel itself.

Removing a password that prevents editing

If the file opens normally but asks for a password before you can make changes, the password protects the workbook structure, not the file itself. To remove it, open the file in Excel, then go to the File menu and select Info.

In the Info panel on the right side, look for a button or option labeled "Protect Workbook" — the exact wording varies slightly between Excel versions. Click it, then select "Encrypt with Password" or "Protect Current Sheet" depending on what you see. A dialog box will appear with a password field. Leave it blank and click OK. The password is now removed.

Save the file after you do this. The next time you open it, no password prompt will appear.

Removing a password that prevents opening the file

If Excel asks for a password the moment you try to open the file, that password encrypts the entire file. To remove it, you still open the file first — enter the password when prompted — then save it without one.

Once the file is open, go to File > Save As. In the Save As dialog, look for a button labeled "Tools" or a dropdown menu near the bottom of the window. Click it and select "General Options" or "Security Options." A dialog will appear with password fields. Leave both fields blank and click OK, then save the file with the same name or a new one. The password is now gone.

If you are using Excel on the web, the process is slightly different: open the file, go to File > Info, and look for a "Protect Workbook" option. The web version does not support file-level encryption passwords the same way the desktop version does, so this option may not appear if the file was encrypted on a desktop version.

What to do if you have forgotten the password

Excel does not have a built-in password recovery or reset feature. If you set the password yourself and have forgotten it, you have two realistic options: contact whoever has the original password, or use a third-party password recovery tool.

Third-party tools exist that can remove or reset Excel passwords, but they vary widely in reliability and cost. Some work by removing the password entirely; others attempt to guess it. Search for "Excel password recovery" to see what is available, but understand that results are not may provide, and some tools may not work on newer Excel versions or files encrypted with stronger methods.

If the file is important and you cannot recover the password, your best option is to ask the person who set it, or to recreate the file from a backup if you have one.

Why Excel lets you remove passwords you set

Excel passwords are meant to prevent accidental changes or to keep casual users from editing a file — not to provide security against someone with physical access to the computer. If you have the file and can open it, Excel assumes you have the right to modify it, including removing the password.

This is different from passwords that protect sensitive data on a server or in the cloud. Those are enforced by the system that stores the file, not by Excel itself, and you cannot remove them just by opening the file locally.

Protecting a file with a new password after removing the old one

Once you have removed the old password, you can set a new one using the same File > Info > Protect Workbook menu. Choose whether you want to encrypt the entire file (so it asks for a password on opening) or just protect the sheet structure (so it asks for a password before allowing edits).

Type a new password in the dialog box, confirm it, and save the file. Write the password down somewhere safe — if you forget it again, you will be back in the same situation.

Frequently Asked Questions

Can I remove a password if I do not remember it?

Excel has no built-in recovery method. You would need to contact whoever set the password, or try a third-party password recovery tool. Results are not may provide, especially on newer Excel versions.

Is removing a password the same on Mac and Windows?

The steps are nearly identical. On Mac, File > Info > Protect Workbook works the same way. The dialog boxes may look slightly different, but the process is the same.

What if the file is read-only?

A read-only file is different from a password-protected one. Right-click the file in Windows Explorer or Finder, select Properties or Get Info, and uncheck the "Read-only" box. Then you can open and edit it normally.

Does removing a password affect the data in the file?

No. Removing a password only removes the protection — all the data, formulas, and formatting stay exactly as they were.

Can I remove a password from a file someone else sent me?

If you can open the file with the password, you can remove it. But you should check with whoever sent it first — they may have protected it for a reason, and removing the protection without permission could cause problems.