The fastest way depends on whether you set the password yourself

If you know the password, Excel will let you remove it in seconds through the file's protection settings. Go to the Review tab, click Unprotect Sheet or Unprotect Workbook, enter the password, and you're done. If you don't know the password, you have a few options: use a password recovery tool, convert the file to a different format that strips protection, or ask whoever protected it to remove the password for you.

The method that works depends on what kind of protection is on the file — whether it's the whole workbook locked, just certain sheets, or only specific cells. Sheet protection locks editing on individual sheets but lets you view the file. Workbook protection locks the structure of the entire file so you can't add, delete, or rename sheets.

Key Takeaways

  • If you know the password, open the file, go to the Review tab, and click Unprotect Sheet or Unprotect Workbook to remove protection in seconds.
  • Sheet protection locks editing on individual sheets but lets you view the file; workbook protection locks the structure of the entire file.
  • If you don't know the password, third-party tools like PassFab for Excel or online converters can remove protection, though results vary by Excel version.
  • Converting an Excel file to CSV or Google Sheets format removes most protection but loses formatting and formulas.
  • If the file belongs to your organization, contact your IT department or the file owner before using removal tools.

Removing protection when you know the password

Open the Excel file and enter the password when prompted. Once the file is open, look for the Review tab in the ribbon at the top of the screen. In the Review tab, you'll see either Unprotect Sheet or Unprotect Workbook depending on what's locked. Click the button that matches what's protected.

Excel will ask you to enter the password again. Type it in and click OK. The protection is now removed. You can verify this by checking the Review tab again — the button should now say Protect Sheet or Protect Workbook instead of Unprotect, which means the file is no longer locked. This works the same way in Excel for Windows, Excel for Mac, and Excel Online.

The difference between sheet protection and workbook protection

Sheet protection locks individual sheets so you can't edit cells, insert rows, or delete columns on that sheet. You can still open the file and see all the data. Most files you encounter with protection have sheet-level locks. When you unprotect a sheet, that one sheet becomes editable, but other sheets in the same file may still be protected.

Workbook protection locks the structure of the entire file — you can't add new sheets, delete sheets, rename sheets, or move sheets around. The cells themselves are usually still editable. Workbook protection is less common and is typically used when someone wants to prevent accidental changes to the file's layout. If a file has both sheet protection and workbook protection, you'll need to unprotect both. Remove sheet protection first, then go back to the Review tab and unprotect the workbook. You may need to enter different passwords for each if they were set separately.

Removing protection without knowing the password

If you don't have the password, third-party tools can remove Excel protection. Programs like PassFab for Excel, Stellar Repair for Excel, and Excel Password Remover are designed for this purpose. These tools work by either recovering the original password or removing the protection code from the file. Success rates vary depending on the Excel version and how strong the password is.

Most of these tools cost between $20 and $50 for a one-time purchase. Some offer free trials that let you see if they can remove the protection before you pay. Download the tool, open it, select your Excel file, and follow the on-screen instructions. The tool will either display the password or create an unprotected copy of your file. Be aware that these tools work best on older Excel files (2003 and earlier versions). Newer versions of Excel use stronger encryption, and some tools may not work on files created in Excel 2010 or later. Check the tool's system requirements before buying.

Converting the file to remove protection

You can strip protection by converting the Excel file to a different format. Save the file as a CSV (comma-separated values) file, and most protection will be removed. Open Excel, go to File > Save As, choose CSV as the file format, and save it with a new name. Then open the CSV file and save it back as an Excel file (.xlsx).

This method works because CSV is a plain-text format that doesn't support Excel's protection features. However, you'll lose formatting, formulas, and any charts or images in the file. If the file is mostly data in a table, this is usually fine. If it has complex formulas or multiple sheets, you'll lose a lot of information. Another option is to upload the file to Google Sheets, which often strips Excel protection when you import the file. Open Google Drive, click New > File upload, select your Excel file, then right-click it and choose Open with > Google Sheets. Once it's open in Google Sheets, download it back as an Excel file. This preserves more formatting than the CSV method but may still lose some features.

What to do if the file belongs to your organization

If the Excel file is from your workplace or school, contact your IT department or the person who created the file before using password removal tools. They may have protected the file for security or compliance reasons, and removing the protection without permission could violate your organization's policies.

Your IT department can often remove the protection for you directly or provide you with the password. This is the safest approach and takes only a few minutes. If you're locked out of a file you created yourself but forgot the password, your IT department may still be able to help by checking their backup systems or using administrative tools.

Protecting your Excel files so you don't forget the password

If you're setting up protection on your own files, write the password down and store it somewhere secure — a password manager like Bitwarden, 1Password, or LastPass is ideal. Don't rely on memory, especially if you only protect files occasionally. A forgotten password is much harder to recover than a lost one.

Use a password that's at least 8 characters long and includes numbers and symbols. Excel's protection is not military-grade encryption — it's designed to prevent accidental changes, not to stop a determined attacker. A strong password is still worth using, but understand that it's a deterrent rather than an absolute barrier.

Frequently Asked Questions

Can I remove protection from an Excel file without the password?

Yes, using third-party password removal tools or by converting the file to CSV or Google Sheets format. Third-party tools work best on older Excel files; newer versions use stronger encryption. Converting to CSV removes protection but loses formatting and formulas.

What's the difference between protecting a sheet and protecting a workbook?

Sheet protection locks individual sheets so you can't edit cells or insert rows, but you can still view the data. Workbook protection locks the file's structure so you can't add, delete, or rename sheets. A file can have both types of protection at once.

Will removing protection delete my data?

No. Removing protection only unlocks the file so you can edit it. Your data stays intact. The only exception is if you convert to CSV format, which strips formatting and formulas but keeps the raw data.

Is it legal to remove protection from an Excel file I don't own?

That depends on why the file is protected and who owns it. If it's your own file or you have permission from the owner, it's fine. If it's a work file, check with your IT department first. Removing protection from files you don't have rights to could violate your organization's policies or laws like the Computer Fraud and Abuse Act.

Why would someone protect an Excel file?

Protection prevents accidental changes to formulas, prevents deletion of important rows or columns, and controls which cells people can edit. In shared files, it keeps one person from accidentally breaking something another person built. It's not meant to be a security measure — it's a safeguard against mistakes.