You can remove an Excel password in three ways, depending on what kind of password it is

Excel lets you password-protect a file in two different ways, and how you remove the password depends on which one you used. A file password stops anyone from opening the document at all — they see a prompt the moment they try to open it. A sheet password locks the cells or structure of a specific sheet, but the file itself opens normally. A third option, workbook structure protection, prevents someone from adding, deleting, or rearranging sheets.

If you set the password yourself and remember it, removing it takes less than a minute. If you forgot the password or inherited a protected file from someone else, your options narrow significantly — there is no built-in "forgot password" recovery in Excel, and the only reliable path involves either recreating the work or using third-party tools that may or may not work depending on the Excel version and protection method used.

Key Takeaways

  • File passwords (which prevent opening the document) can be removed by opening the file, going to File > Info > Protect Workbook, and selecting "Encrypt with Password" to clear the field.
  • Sheet passwords (which lock cells within a sheet) are removed through the Review tab by clicking "Unprotect Sheet" and entering the password if prompted.
  • If you forgot the password, Excel has no built-in recovery — you will need to either contact the person who set it or use a third-party tool, which may not work on newer Excel versions.
  • Workbook structure protection (which prevents adding or deleting sheets) is removed the same way as sheet protection, through the Review tab.

How to remove a file password you remember

A file password is the one that appears when you first try to open the document. To remove it, you need to open the file with the password, then strip it out from the settings.

Open Excel and go to File > Open. Select your protected file and click Open. When prompted, enter the password. Once the file is open, go to File > Info. On the right side, look for a button labeled "Protect Workbook" — it may say "Encrypt with Password" depending on your Excel version. Click it. A dialog box will appear with a password field. Leave the field blank and click OK. The password is now removed. Save the file.

How to remove a sheet password you remember

A sheet password locks individual cells or prevents editing within a specific sheet, but does not prevent the file from opening. You remove it through the Review tab at the top of the ribbon.

Open the protected file. Click on the sheet tab at the bottom if you have multiple sheets and need to unprotect a specific one. Go to the Review tab. Look for "Unprotect Sheet" (the button name changes depending on whether the sheet is currently protected). Click it. If a password was set, a dialog box will ask you to enter it. Type the password and click OK. The sheet is now unprotected and cells can be edited freely. Repeat for any other protected sheets.

How to remove workbook structure protection

Workbook structure protection prevents you from adding new sheets, deleting sheets, or rearranging them — but it does not lock the content of the sheets themselves. The removal process is nearly identical to sheet protection.

Go to the Review tab. Look for "Unprotect Workbook" (or a similar button indicating the workbook structure is protected). Click it. If a password was set, enter it when prompted. Click OK. You can now add, delete, and rearrange sheets freely.

What to do if you forgot the password

Excel does not have a built-in password recovery feature. If you set a password and genuinely cannot remember it, your options are limited. The most reliable path is to contact whoever has the original unprotected version of the file and ask them to send it to you or remove the protection themselves.

If that is not possible, third-party password recovery tools exist, but their success depends heavily on the Excel version, the protection method used, and how strong the password is. Some tools work only on older Excel files (.xls format) and fail on newer ones (.xlsx). Others claim to "crack" passwords but may only work on sheet protection, not file passwords. Before downloading any tool, research whether it supports your specific Excel version and protection type. Be cautious of tools that ask for payment upfront or require you to upload your file to an external server.

The difference between file passwords and sheet passwords in practice

Understanding which type of protection you are dealing with matters because the removal process and the security level are different. A file password is stronger — it stops anyone from even seeing the contents. A sheet password is weaker and mainly prevents accidental changes or casual editing. If someone has the file and knows it is password-protected, they can see that fact when ready. If someone has a sheet-protected file, they may not realize the protection exists until they try to edit a cell.

From a security standpoint, file passwords offer more privacy because the file itself is encrypted. Sheet passwords are more about preventing mistakes than preventing determined access. If you are protecting sensitive information, a file password is the better choice. If you are protecting a shared spreadsheet from accidental edits, sheet protection is usually enough.

Why you might want to remove a password

Common reasons to remove a password include: you no longer need the protection and want easier access, you are sharing the file with someone who does not need the password barrier, or you are consolidating files and want consistent protection across all of them. Sometimes a password was set by someone else and is no longer needed, or the person who set it is no longer available to provide it.

Before removing a password, consider whether the protection was there for a reason. If the file contains sensitive data or is part of a controlled workflow, removing the password might create security or compliance problems. If you are unsure, check with whoever originally set the protection or with your organization's IT or data governance team.

Frequently Asked Questions

Can I remove a password without knowing what it is?

Not reliably through Excel itself. Third-party tools claim to recover or bypass passwords, but they work inconsistently depending on your Excel version and the type of protection used. The most dependable option is to contact the person who set the password or find an unprotected copy of the file.

If I remove the password, does that affect the file's data or formatting?

No. Removing a password only removes the protection mechanism — all data, formulas, formatting, and content remain exactly as they were. The file itself is unchanged except for the removal of the password lock.

Can I remove a file password if I only have read-only access?

No. To remove any password, you must be able to open and edit the file. If you have only read-only access, you cannot modify the protection settings. You will need to contact the file owner or someone with edit permissions.

What is the difference between a password and a PIN in Excel?

Excel uses the term "password" for all protection methods — there is no separate PIN feature. Both file and sheet protection use passwords, not PINs. The removal process is the same regardless of what you call it.

If I remove a password, can I add a different one later?

Yes. You can remove a password and add a new one at any time using the same File > Info > Protect Workbook menu (for file passwords) or Review > Protect Sheet menu (for sheet passwords). You do not need to do anything special between removing one password and setting another.