How to Unlock an Excel Sheet or Workbook

How-to basics · Updated November 20, 2026

To unlock a protected Excel sheet in Microsoft 365 for Windows, open it and select Review > Unprotect Sheet, then enter the password if Excel asks. A workbook with protected structure or a password required to open it uses a different control, so first identify what is locked. You need the password or permission from the person who set the protection; Excel does not provide a supported way to retrieve a forgotten protection password.

What You’ll Need

  • The workbook in Excel, preferably a saved copy if you plan to change protection or cell settings.
  • The password, if the sheet, workbook structure, or file was protected with one. If you do not have it, contact the workbook owner or your organization’s administrator.
  • Permission to edit the file. A read-only file, a shared-workbook restriction, or a file-opening password can prevent changes even when the sheet itself is unprotected.

Step-by-Step

  1. Work out which kind of lock you have. Open the workbook and try to select or edit a cell. If you can view the sheet but cannot change particular cells, the worksheet may be protected. A protected worksheet can still allow selecting cells, filtering, or other permitted actions, so the exact restrictions depend on how its owner set it up. If you cannot add, delete, move, hide, or rename worksheet tabs, the workbook structure may be protected. If Excel requests a password before showing the workbook at all, that is a file-opening password, not sheet protection. A read-only banner or a message about permissions points to a separate file-access issue.
  2. Save a working copy when appropriate. If you can open the file and have permission to edit it, use File > Save As to create a copy before making changes. This gives you a way back if you remove protection and later discover that a formula, input area, or layout should have stayed restricted. Do not make a copy to get around an owner’s access rules; ask the owner for permission if you are unsure whether changes are allowed.
  3. Remove worksheet protection when you know the password. Select the worksheet tab that is locked. On the Windows ribbon, open Review and choose Unprotect Sheet. If Excel displays a password box, enter the sheet password and select OK. If the sheet was protected without a password, it should become editable immediately. Check a cell that was previously restricted to confirm that protection has actually been removed. Repeat this on each protected worksheet; unprotecting one tab does not automatically unlock the others.
  4. Unlock workbook structure if sheet tabs are restricted. If you cannot rename, move, add, delete, hide, or unhide sheets, select Review > Protect Workbook. When structure protection is active, Excel asks for its password to turn it off. Enter the password and confirm. This is separate from unprotecting an individual sheet: a workbook can have protected structure while its cells are editable, or protected sheets while its tab structure is not locked. If you do not see the expected control or it is unavailable, check that the workbook is open in the desktop app and that you have editing permission.
  5. Change only the cells that should be editable, if that is your goal. If you want to keep most of a sheet protected, do not remove protection permanently. First unprotect the sheet using its password. Select the cells intended for data entry, press Ctrl+1 to open Format Cells, choose the Protection tab, clear the Locked checkbox, and select OK. Then go to Review > Protect Sheet and choose the actions users should be allowed to perform. Add a password if needed, record it somewhere secure, and confirm it when prompted. The Locked setting only takes effect while sheet protection is on. On Mac, use Command+1 for Format Cells and look for the Protection tab; ribbon labels can vary slightly by Excel release.
  6. Handle a password required to open the file separately. If Excel asks for a password before opening the workbook, enter the correct password to access it. To remove a known opening password after opening, go to File > Info > Protect Workbook > Encrypt with Password, clear the password field, select OK, and save the workbook. The menu label or location can differ in some Excel releases. Do not confuse this with Review > Unprotect Sheet: the sheet command cannot remove file encryption. Keep a secure copy before changing file security, and make sure removing the password is permitted.
  7. Use the desktop app when Excel for the web lacks the needed control. In Excel for the web, open the Review tab and check Manage Protection for the selected sheet. If the workbook allows you to manage protection, turn it off there and provide the password if requested. Options for workbook structure and file encryption may not be available in the web app. Choose Open in Desktop App and use the Windows steps above, or the equivalent Review controls in Excel for Mac. The password is still required; switching apps does not recover it.

Once you have finished, test the specific action that was blocked, such as editing an input cell or renaming a tab. If you changed protection settings, save the workbook and reopen it to make sure the intended access rules remain in place.

Common Mistakes

  • Choosing the wrong protection command. Unprotect Sheet applies to the active worksheet. It will not remove workbook-structure protection or a password needed to open the file. Match the command to what Excel is preventing you from doing.
  • Assuming every cell is locked because the sheet is protected. A protected sheet can still contain unlocked input cells. Protection settings may also allow some actions, such as sorting or using filters, while preventing others. Check the specific cell or action rather than judging by the sheet’s overall appearance.
  • Expecting Excel to reveal a forgotten password. Microsoft does not offer a supported password-recovery feature for protected sheets or password-encrypted workbooks. Avoid tools or instructions that claim to bypass protection; they can put private data at risk and may violate the file owner’s rules.
  • Saving over the only copy. Changing cell locks or removing protection can expose formulas or alter a carefully designed template. Keep an authorized backup before changing settings, especially in a workbook used by other people.
  • Thinking a sheet password encrypts the whole file. Worksheet protection is intended to control changes to a sheet; it is not the same as encrypting a file that requires a password to open. Do not rely on sheet protection to keep confidential information private.

Tips

  • Ask the file owner which protection is intended to be removed and whether there are specific cells you should leave locked. That can prevent accidental changes to formulas, headings, or reporting layouts.
  • If you manage the workbook, store protection passwords in an approved password manager or other secure location. Keep a record of which password applies to which sheet or file, without putting passwords in visible worksheet cells.
  • For a reusable form, unlock only the entry cells before protecting the sheet again. Consider testing the sheet with a sample user task so the allowed actions support the way people actually need to work.
  • If the ribbon is simplified or the window is narrow, expand the Review tab or use the Excel desktop app. A hidden or collapsed ribbon control does not mean the workbook is unlocked.
  • When collaborating, check whether the workbook is stored in OneDrive or SharePoint and whether your account has edit access. The file owner or site administrator can change sharing permissions; sheet protection and cloud permissions are separate controls.

Troubleshooting

Excel says the password is incorrect. Check capitalization, keyboard layout, and whether Caps Lock or Num Lock changes what you type. Passwords can be case-sensitive. If you are unsure which password applies, ask the person who protected the sheet or created the file. Do not keep guessing if the workbook is important; make a copy of the original file and seek help from its owner.

Unprotect Sheet is missing or does not appear to work. Confirm that the intended worksheet tab is active and look on the Review tab. In some ribbon layouts, commands may be collapsed into a menu. If the tab remains protected after entering a password, check whether you are viewing a different worksheet, whether the workbook is read-only, or whether an organization’s permissions restrict editing. Close and reopen the saved file if the interface appears out of date.

You can edit cells but cannot change sheet tabs. That usually indicates workbook-structure protection rather than worksheet protection. Use Review > Protect Workbook and provide the structure password. If the command is unavailable in Excel for the web, open the workbook in the desktop application. If the structure password is unknown, contact the owner.

You cannot edit even after removing sheet protection. Look for a read-only banner, a Protected View notification, or an access message from OneDrive or SharePoint. A file may also have been opened from an email attachment or an untrusted location. Only enable editing if you trust the source and have permission. If the file is marked read-only, use Save As to make an editable copy only when your organization’s rules and the owner allow it.

The file still asks for a password before it opens. That prompt is for opening-password encryption. The Review tab cannot remove it because Excel has not yet opened the workbook contents. Ask the owner for the opening password. If you have it, open the file first and then use the file-encryption settings described above to change or remove it, if authorized.

Frequently Asked Questions

Is an Excel page the same thing as a worksheet?
People often use page to mean a worksheet or sheet tab. A printed page is different: print settings control how a sheet is divided for printing, while Review > Unprotect Sheet controls worksheet protection.

Can I unlock an Excel sheet without its password?
There is no supported Excel method to recover or bypass a forgotten sheet-protection password. Ask the workbook owner or administrator for the password or an authorized editable copy.

Does unprotecting one sheet unlock the entire workbook?
No. Each worksheet can have its own protection setting, and workbook structure has a separate setting. Remove each protection individually using the appropriate password and command.

Will unlocking a sheet delete its formulas?
Normally, removing sheet protection changes whether cells can be edited; it does not itself delete formulas or values. However, once unlocked, a formula can be overwritten by an edit, so save a backup and avoid changing cells you do not intend to change.

Can I unlock a sheet in Excel for Mac?
Yes. Select the worksheet and use Review > Unprotect Sheet, then enter the password if prompted. Ribbon layout and keyboard shortcuts can differ from Windows, but the password requirement is the same.

Does sheet protection secure confidential data?
No. Sheet protection is mainly for limiting edits, not for encrypting sensitive contents. Use appropriate file encryption and access permissions for confidential workbooks, and follow your organization’s security requirements.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.