What unprotecting an Excel file means

Unprotecting an XLS file means removing the password that prevents someone from editing, copying, or viewing the spreadsheet's contents. Excel lets you lock a file so that only someone with the correct password can make changes — this is useful when you share a template or financial model and want to prevent accidental edits. Unprotecting removes that lock.

The process depends on what is actually protected. Excel distinguishes between three different types of locks: a password on the file itself (so you cannot open it without the password), protection on individual sheets (so you cannot edit cells or change formulas), and protection on the entire workbook structure (so you cannot add or delete sheets). Each one removes differently, and the steps vary slightly between Excel versions.

If you created the file and remember the password, unprotecting takes less than a minute. If you do not remember the password, the process is longer and may not work at all — Excel's protection is designed to be difficult to bypass without the original password.

Key Takeaways

  • Sheet protection (the most common type) removes through the Review tab in Excel by clicking Unprotect Sheet and entering the password if one exists.
  • File-level passwords that prevent opening the document cannot be removed without the original password — there is no workaround built into Excel.
  • The exact steps differ between Excel on Windows, Excel on Mac, and Excel Online, so check which version you are using first.
  • If you have the file but not the password, third-party tools exist but may not work on newer Excel files encrypted with strong security.

Removing sheet protection in Excel on Windows

Sheet protection is the most common lock you will encounter. It prevents editing of cells, inserting rows, or changing formulas, but you can still open and view the file. To remove it, open the file in Excel and look at the top menu bar for the Review tab. Click it.

In the Review tab, you will see a button labeled Unprotect Sheet (it may say "Protect Sheet" if the sheet is not currently protected). Click Unprotect Sheet. If the sheet was protected with a password, a dialog box will appear asking you to enter it. Type the password and click OK. If there was no password, the sheet unprotects when ready and you can now edit all cells.

Once unprotected, you can edit, delete, insert, or format anything in the sheet. The file itself remains saved — you are just removing the restriction layer. If you want to re-protect the sheet later, you can return to Review and click Protect Sheet to set a new password or leave it blank.

Removing sheet protection in Excel on Mac

The process on Mac is nearly identical but the menu location is slightly different. Open the file and click the Review tab in the ribbon at the top. You will see Unprotect Sheet in the Protect group on the left side of the ribbon.

Click Unprotect Sheet. If a password was set, enter it in the dialog that appears. If no password was set, the sheet unprotects without prompting. After unprotecting, all cells become editable and you can make any changes you need.

Removing protection from Excel Online

Excel Online (the browser version you access through OneDrive or SharePoint) has limited protection features compared to the desktop version. If a sheet is protected in Excel Online, you will see a message saying the sheet is protected when you try to edit a cell.

To unprotect, click the Review tab and select Unprotect Sheet. If the sheet has a password, you will be prompted to enter it. Excel Online does not support all the protection options that desktop Excel does, so some files protected on desktop may not show as protected when opened online.

Handling file-level passwords you cannot remember

If the entire file is password-protected (meaning you cannot open it without entering a password first), and you do not remember the password, Excel has no built-in recovery method. Microsoft does not store passwords and cannot retrieve them for you.

Third-party password recovery tools exist, but they work by trying many password combinations — a process called brute force. These tools are slow and may not work on files created in Excel 2007 or later, which use stronger encryption. If you have access to the person who created the file, asking them for the password is faster and more reliable than using recovery software.

If the file is very old (created before 2007) and you have a recovery tool, it may work, but there is no may provide. For newer files, recovery is unlikely to succeed.

Unprotecting workbook structure protection

Workbook protection is different from sheet protection. It prevents you from adding, deleting, renaming, or moving sheets within the workbook. You can still edit the cells inside each sheet. To remove workbook protection, go to the Review tab and look for Protect Workbook (the button name changes depending on whether it is currently protected).

Click Protect Workbook. If a password was set, enter it. If no password was set, the workbook unprotects when ready. After unprotecting, you can add new sheets, delete existing ones, or reorganize them as needed.

When you should not unprotect a file

If someone else created the file and protected it, unprotecting it without permission may violate their intent. Protection is often used to prevent accidental changes to important formulas or to keep a template structure intact. Before unprotecting a shared file, consider whether the protection exists for a reason and whether you should contact the file owner instead.

If you are working with a file that belongs to your organization, check with your manager or IT department before removing protection. Some files are protected as part of compliance or security policy, and removing that protection could create problems.

Frequently Asked Questions

Can I unprotect an Excel file without the password?

For sheet protection, sometimes yes — if no password was set, the Unprotect Sheet button works when ready. For file-level passwords that prevent opening the document, no — there is no way to open the file without the correct password. Third-party tools may work on very old files but are unreliable on modern Excel files.

What is the difference between sheet protection and workbook protection?

Sheet protection locks individual cells so you cannot edit them, insert rows, or change formulas. Workbook protection locks the structure so you cannot add, delete, or rename sheets. You can have one, both, or neither. Both remove through the Review tab but in different places.

If I unprotect a file, does it change the original file?

Unprotecting removes the lock but does not change the data inside. The file remains the same — you are just removing the restriction. If you want to save it unprotected, you must save the file after unprotecting. If you close without saving, the protection returns the next time you open it.

Why would someone protect an Excel file?

Protection is used to prevent accidental changes to important formulas, to keep a template structure consistent, or to restrict editing to certain cells while allowing others to be changed. It is a safety feature, not a security feature — it stops mistakes, not determined attackers.

Does Excel protection work the same way in Google Sheets?

No. Google Sheets uses a different protection system. To unprotect a sheet in Google Sheets, click the sheet tab, select Data, then Protect Sheets and Ranges, and remove the protection from there. The process and options are different from Excel.