You can remove an Excel password in minutes using the file's own password removal feature

If you have set a password on an Excel file and now want to remove it, you do not need special software or a workaround. Excel has a built-in way to strip the password protection from your file. The method depends on which version of Excel you use — the steps for Excel on Windows differ slightly from Excel on Mac, and older versions work differently than newer ones.

The process takes about five minutes and requires only the password itself. If you have forgotten the password, removal becomes much harder, and you will need to explore other options.

Key Takeaways

  • Excel files can be password-protected in two ways: to prevent opening the file, or to prevent editing the file, and each requires a different removal method.
  • To remove a password that prevents opening the file, you must know the password and re-save the file without it in the Save As dialog.
  • To remove a password that prevents editing, you open the file, go to Tools or Review menu, and turn off sheet protection or workbook protection.
  • If you have forgotten the password entirely, you cannot remove it yourself through Excel — you would need to contact the file creator or explore password recovery services.
  • The exact menu location and wording changes between Excel versions and between Windows and Mac, so check your specific version if the steps do not match exactly.

Removing a password that prevents opening the file (Windows)

If your Excel file requires a password before you can even open it, follow these steps in Excel on Windows. You will need to know the password.

Open the file normally and enter the password when prompted. Once the file is open, click File in the top left corner, then click Save As. In the Save As dialog, choose where you want to save the file and give it a name. Before you click Save, look for a button labeled Tools near the bottom right of the dialog — it may appear as a small dropdown arrow next to the Save button. Click Tools, then select General Options. In the General Options dialog, you will see two password fields: one labeled Password to open and one labeled Password to modify. Delete any text in the Password to open field. Leave the Password to modify field as is unless you also want to remove that protection. Click OK, then click Save. Excel will ask if you want to replace the existing file — click Yes. Your file is now saved without the opening password.

Removing a password that prevents opening the file (Mac)

On Excel for Mac, the process is similar but the menu location is different. Open the file and enter the password. Click File at the top, then Save As. In the Save As window, enter a filename and choose a location. Look for a button labeled Options near the bottom of the dialog. Click it.

In the Options dialog, find the field labeled Password and delete any text in it. Click OK, then click Save. When Excel asks if you want to replace the file, click Replace. The file will now open without requiring a password.

Removing sheet protection or workbook protection

Sometimes an Excel file is not locked at the opening stage, but the sheets themselves are protected so you cannot edit them. You may see a message like "This sheet is protected" when you try to make changes. Removing this type of protection is faster than removing an opening password.

Open the file. On Windows, click the Review tab at the top of the ribbon. Look for a button labeled Unprotect Sheet or Unprotect Workbook depending on what is locked. Click it. If the sheet is password-protected, Excel will ask you to enter the password. Type it and click OK. The protection is now removed and you can edit the file freely. On Mac, the Review tab is in the same location, and the button names are identical. If you see Protect Sheet or Protect Workbook instead of "Unprotect", the file is not currently protected, and you can edit it normally.

What to do if you do not know the password

If you have forgotten the password to your own file, you cannot remove it through Excel itself. Excel passwords are encrypted, and there is no built-in recovery or reset function. You have three realistic options.

First, check whether you wrote the password down somewhere — a notebook, password manager, or email. Many people store passwords in these places without remembering they did. Second, if someone else created the file or set the password, contact them and ask them to remove it. Third, you can search for third-party password recovery services online, though these vary widely in reliability and cost, and some may not work on newer Excel versions. Before using any third-party tool, research its reviews carefully and understand that it may not succeed.

Why files get password-protected in the first place

Excel passwords serve two main purposes: keeping sensitive information private and preventing accidental or intentional changes to important data. A password to open the file keeps anyone without the password from seeing the contents at all. A password to modify the file lets people view the data but prevents them from editing formulas, deleting rows, or changing values.

In a workplace, a manager might protect a budget spreadsheet so employees can see the numbers but cannot alter them. In personal use, you might password-protect a file containing financial information or medical data. Understanding which type of protection is on your file helps you know which removal method to use.

Common mistakes to avoid

The most common mistake is trying to remove an opening password without using Save As. Simply opening the file and saving it normally will not remove the password — you must use Save As and access the General Options or Options dialog to clear the password field. If you skip this step, the file will still be password-protected when you close and reopen it.

Another mistake is confusing sheet protection with file-level passwords. If you can open the file but cannot edit it, the problem is sheet protection, not an opening password. Looking for a password field in Save As will not help. Instead, go directly to the Review tab and click Unprotect Sheet. A third mistake is entering the wrong password when prompted. Excel will reject it and ask you to try again, but if you enter it incorrectly three times in a row, some versions may lock you out temporarily.

Frequently Asked Questions

Can I remove a password if I only remember part of it?

No. Excel requires the exact password to remove file-level protection. If you remember part of it, you could try variations, but Excel will reject any password that does not match exactly. For sheet protection, the same rule applies — the password must be entered correctly or the protection stays in place.

What is the difference between a password to open and a password to modify?

A password to open prevents anyone from viewing the file at all without entering it. A password to modify lets people open and read the file, but they cannot change any data or formulas without the password. You can have one, both, or neither on the same file.

If I remove the password, will the file still work the same way?

Yes. Removing a password does not change any formulas, data, or formatting in the file. It only removes the lock that was preventing access or editing. The file will function identically once the password is gone.

Does removing a password leave any trace that it was protected?

No. Once you save the file without the password, there is no indication in the file itself that it was ever protected. The file looks and behaves like any unprotected Excel file.

Can I remove a password from an Excel file on my phone or tablet?

Excel on mobile devices (iPhone, iPad, Android) does not have the same password removal features as the desktop version. You would need to use Excel on a computer to remove the password, then transfer the unprotected file to your phone.