You can remove an Excel password in three ways, depending on how the file was protected

Excel lets you password-protect a file in two different ways, and the method you use to remove the password depends on which one was applied. The most common protection is file-level encryption, which locks the entire spreadsheet until someone enters the correct password. The second is sheet protection, which allows the file to open but prevents editing of specific sheets or cells. Removing file-level encryption requires you to know the password. Removing sheet protection is usually simpler, even if you do not remember the password.

Before you start, make sure you have permission to remove the password. If someone else protected the file and did not give you the password, removing it without their consent may violate your workplace policy or local law.

Key Takeaways

  • File-level encryption requires you to know the original password; there is no way around this if you have forgotten it.
  • Sheet protection can often be removed without the password by saving the file as a different format, then converting it back.
  • The Save As dialog in Excel shows you which type of protection is active on your file.
  • If you remove file-level encryption, save the file when ready with a new name to avoid overwriting the original.

Removing file-level encryption when you know the password

If the entire file is password-protected and you know the password, removing it takes one minute. Open the file normally — Excel will ask you for the password in a dialog box. Enter it and click OK.

Once the file is open, go to File > Info > Protect Workbook > Encrypt with Password. A dialog box titled "Encrypt Document" will appear with a password field. Delete the password text completely, leaving the field blank, then click OK. Save the file. The encryption is now removed, and anyone can open the file without entering a password.

Removing sheet protection without the password

Sheet protection is weaker than file-level encryption. It prevents users from editing cells, inserting rows, or changing formulas on a specific sheet, but the file itself opens normally. If you do not know the sheet password, you can remove the protection by converting the file format.

Open the protected file in Excel. Go to File > Save As. In the dialog box, change the file format from "Excel Workbook (.xlsx)" to "Excel 97-2003 Workbook (.xls)". Choose a location and click Save. Close the file, then reopen the .xls version. Go to Tools > Protect Sheet (or Review > Unprotect Sheet, depending on your Excel version). If the sheet was protected, this option will now be available without requiring a password. Click it to remove the protection.

After you remove the protection, save the file again. You can keep it as .xls or convert it back to .xlsx by using Save As and selecting the newer format. Converting formats can occasionally change formatting or remove newer Excel features, so check the file carefully after conversion.

Removing file-level encryption when you do not know the password

If the entire file is encrypted and you do not know the password, there is no built-in way to remove it. Excel's encryption uses industry-standard algorithms that Microsoft itself cannot bypass. You cannot open the file without the correct password, and no legitimate tool can recover it.

If you created the file and forgot the password, your only option is to contact whoever has the original unencrypted version. If the file came from someone else, ask them for the password or for an unprotected copy. If neither is possible, the file cannot be opened or edited.

Telling the difference between file encryption and sheet protection

The easiest way to tell which type of protection is active is to try opening the file. If a password dialog appears before the file opens, the entire file is encrypted with file-level protection. If the file opens normally but you cannot edit certain cells or sheets, sheet protection is active.

You can also check by going to File > Info. If the file is encrypted, you will see "Encrypt with Password" listed under Protect Workbook. If only sheets are protected, you will see "Protect Sheet" or "Unprotect Sheet" under the same menu, and the option will be available without requiring a password first.

What happens after you remove the password

Once you remove file-level encryption, the file is no longer protected. Anyone with access to the file can open it, view it, and edit it. If you removed sheet protection, users can now edit cells that were previously locked.

Save the file when ready after removing the password, using a new filename if you want to keep a backup of the protected version. If you save over the original file without a new name, the old encrypted version is replaced and cannot be recovered. Consider keeping the original protected file in a separate location until you are certain the unprotected version is correct.

Why files get password-protected in the first place

File-level encryption is used when you want to keep the entire spreadsheet confidential — for example, a financial report or a list of employee salaries. Sheet protection is used when you want people to see certain data but not change it, such as locking formulas in place while allowing users to enter numbers in specific cells.

If you are removing protection from a file you created, make sure you understand why it was protected before you remove the password. If it was encrypted to keep sensitive information private, removing the encryption means that information is now visible to anyone with the file.

Frequently Asked Questions

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

No. Excel requires the exact password to decrypt a file. Partial passwords do not work. If you remember part of it, you might try variations, but there is no tool that can crack or bypass file-level encryption.

Does removing sheet protection delete any data?

No. Removing sheet protection only unlocks the cells; it does not change or delete any content. The data in the spreadsheet remains exactly as it was.

Will converting from .xlsx to .xls remove all types of protection?

Converting formats removes sheet protection but not file-level encryption. If the entire file is encrypted, you cannot open it to convert it in the first place. The format conversion method only works for sheet-level protection.

What if I remove the password and then change my mind?

If you saved over the original file, the encrypted version is gone. If you kept a backup of the protected file, you can use that instead. Always save the unprotected version with a different filename until you are sure you no longer need the password protection.

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

Excel for mobile devices does not have the same password removal options as the desktop version. You will need to use Excel on a computer to remove file-level encryption or sheet protection.