Removing a password from an Excel file depends on which version you use and whether you set the password yourself

If you forgot the password to your own Excel file, you can remove the protection in Excel 2016 and later by saving the file in an older format, opening it in that format, and saving it back. If you remember the password, you can unprotect the sheet or workbook directly through the Tools menu. The exact steps differ between Windows and Mac, and between Excel versions.

If someone else protected the file and you do not have the password, there is no built-in way to remove it. Third-party tools exist that claim to crack Excel passwords, but they work only on older files (Excel 97–2003) and are unreliable on newer ones. For files you own but cannot access, your best option is to contact the person who set the password or check whether you saved it elsewhere.

Key Takeaways

  • If you know the password, you can unprotect a sheet or workbook in seconds through the Tools menu without losing any data.
  • If you forgot the password to your own file, saving it as an Excel 97–2003 file (.xls) and reopening it sometimes removes the protection, though this does not work on all newer files.
  • Password-protected Excel files created in 2007 or later use encryption that is difficult to break without the original password.
  • Third-party password-recovery tools exist but work reliably only on very old Excel files and may not work at all on files created in the last ten years.

Unprotecting a sheet when you know the password

If you remember the password, removing sheet protection takes less than a minute. Open the file in Excel, go to the Tools menu (on Mac) or the Review tab (on Windows), and look for Unprotect Sheet or Protect Sheet. Click it, enter the password when prompted, and click OK. The sheet is now unprotected and you can edit any cell.

If the entire workbook is protected rather than just one sheet, the process is the same: go to Tools or Review, find Protect Workbook, enter the password, and click OK. You will know the workbook is protected if you cannot add, delete, or rename sheets. After you unprotect it, you can do all of those things again.

Unprotecting a workbook when you know the password

Workbook protection is different from sheet protection. A protected workbook prevents you from adding new sheets, deleting sheets, or hiding sheets, but you can still edit the cells in the sheets that exist. To remove workbook protection, go to Tools (Mac) or Review (Windows), find Protect Workbook, enter the password, and click OK.

After you unprotect the workbook, you can manage sheets freely. If you want to protect it again later with a different password, you can do that through the same menu.

Removing protection when you forgot the password

If you set the password yourself but cannot remember it, one workaround is to save the file in an older Excel format. Open the file, go to File and then Save As, and choose Excel 97–2003 Workbook (.xls) from the format dropdown. Save it with a new name. Then close the file and open the .xls version you just created.

Sometimes this removes the protection because older Excel versions used weaker encryption. Open the file and try to edit a cell. If the protection is gone, you can now save it back to the current Excel format (.xlsx) if you want. This method does not work on all files — it depends on when the file was created and how the password was set — but it is worth trying before you assume the file is permanently locked.

Why password-cracking tools are unreliable

Third-party software that claims to remove Excel passwords exists, but it works only on files created before 2007. Excel 2007 introduced much stronger encryption, and files created since then are extremely difficult to crack without the original password. Even tools that advertise password recovery often fail on modern files or take weeks to run.

If you search for "Excel password remover" online, you will find many options, but most are either scams, contain malware, or straightforward do not work on files newer than 15 years old. If you own the file and truly cannot access it, contacting the person who set the password is faster and safer than downloading unknown software.

What to do if you cannot remember the password and cannot contact the person who set it

If the file is important and you have no other way to recover the password, you have a few options. First, check whether you saved the password anywhere — in a password manager, a notebook, an email, or a shared document. Many people write passwords down or store them in a place they later forget about.

Second, if the file was created by your employer or school, contact your IT department. They may have a record of the password or be able to remove the protection on your behalf. Third, if the file is not critical, you may be able to recreate the data by copying it from a backup or from the original source. If none of these options work, the file is effectively locked and you will need to start over with a new file.

Protecting your Excel files so you do not lose access

If you set a password on an Excel file, write it down in a password manager like Bitwarden, 1Password, or the one built into your browser. Do not rely on memory. If you use a password manager, you can always look it up later without needing to guess or reset it.

If you protect a file for someone else, make sure they know the password and have a way to store it securely. If you are protecting a file at work, check whether your company has a policy about password-protected files — some organizations require that passwords be stored in a central location so that other people can access critical files if you leave or become unavailable.

Frequently Asked Questions

Can I unprotect an Excel file without the password?

Not reliably. If the file was created in 2007 or later, there is no practical way to remove the password without knowing it. Older files (Excel 97–2003) sometimes lose protection when saved in a newer format, but this does not work on most modern files. If you own the file, contact whoever set the password.

Does unprotecting a file delete any data?

No. Removing password protection does not change the contents of the file at all. All your data stays exactly as it was. You are only removing the restriction that prevents you from editing cells.

What is the difference between sheet protection and workbook protection?

Sheet protection locks individual cells so you cannot edit them, but you can still add new sheets or delete existing ones. Workbook protection prevents you from adding, deleting, or renaming sheets, but does not lock the cells themselves. A file can have both types of protection at the same time.

If I save an Excel file as a PDF, does the password protection carry over?

No. When you save an Excel file as a PDF, the password protection is removed because PDFs use a different protection system. The data itself is in the PDF, but the Excel-level password protection does not explore.

Can I unprotect an Excel file on my phone or tablet?

Excel on mobile devices (iPhone, iPad, Android) does not have the same protection and unprotection tools as the desktop version. If you need to unprotect a file, do it on a computer using the desktop version of Excel or a compatible program like LibreOffice Calc.