How to Unprotect an Excel Sheet

In desktop Excel, select the sheet, choose Review > Unprotect Sheet, and enter its password if asked. This removes worksheet edit restrictions so authorized users can change locked cells or protection settings. It does not decrypt the file, remove workbook-structure protection, or erase the cells’ Locked and Hidden settings.

Dated source: Microsoft Learn’s Worksheet.Protect method reference, last updated July 12, 2022, documents 16 optional arguments: one password argument and 15 controls for protected-sheet behavior. Microsoft separately warns that worksheet protection is not intended as a security feature.

This guide is for workbooks you own or are authorized to maintain. It explains normal Excel controls; it does not cover password cracking or protection bypasses.

The ribbon and VBA steps below are for the Excel desktop apps on Windows and Mac. In Excel for the web, select Review > Manage Protection, then turn Protect sheet off in the pane; enter the password if required. The web app cannot create, run, or edit VBA. For the batch macro, select Open in Desktop App. Microsoft documents both the web protection pane and the VBA limitation.

Quick Answer

In desktop Excel on Windows or Mac, open the authorized sheet and select Review > Unprotect Sheet. In Excel for the web, use Review > Manage Protection and turn off Protect sheet. Enter the case-sensitive password if prompted, then test one previously locked cell before making the real change.

The ribbon button is also a useful status check. When worksheet protection is active, it reads Unprotect Sheet. After protection is removed, it changes to Protect Sheet.

Both paths use supported controls without changing the stored cell-locking configuration.

If the command is available but your edit still fails, do not assume the password was wrong. Workbook structure, read-only access, coauthoring permissions, or file encryption can create separate restrictions. The troubleshooting section below helps identify the active layer.

What Unprotect Sheet Changes

Unprotect Sheet turns off worksheet-level edit enforcement for one tab. It allows authorized changes to cells and actions that the protection settings had blocked, but it does not clear the cells’ Locked or Hidden flags. Those two Format Cells settings remain in place and apply again if you reprotect the worksheet later.

Here is what changes:

That last row matters. Unprotecting is reversible because the underlying cell configuration remains. If an input cell should stay editable after you restore protection, select it, open Format Cells > Protection, and clear Locked before protecting the sheet again.

Worksheet protection is an editing guard, not a confidentiality boundary. Microsoft’s worksheet guidance explicitly says it is not intended as a security feature. Do not rely on it to conceal payroll, identity, payment, health, or other sensitive data from someone who can obtain the workbook.

How to Unprotect a Sheet Without a Password

If the owner applied worksheet protection without a password, you can unprotect worksheet controls in four short steps: select the correct tab, open Review, click Unprotect Sheet, and verify an edit. Excel removes the restrictions immediately because there is no credential to validate, while retaining each cell’s Locked and Hidden configuration for later use.

1. Select the protected worksheet

Open the workbook and click the relevant sheet tab. On the Review tab, confirm that the command says Unprotect Sheet rather than Protect Sheet.

2. Choose Review > Unprotect Sheet

Click Unprotect Sheet. If no password was assigned, Excel removes the protection without displaying a credential prompt. The command then changes to Protect Sheet.

3. Test a previously locked cell

Edit a cell that was intentionally locked. Save a copy first if the workbook is business-critical, and undo the test after confirming that the edit works.

4. Make the authorized change

Complete the update, review formulas and formatting, and then decide whether the sheet should be protected again. Avoid leaving a shared template unprotected merely because your immediate edit is complete.

How to Unprotect a Sheet With a Password

For a password-protected worksheet, use Excel’s built-in Unprotect Sheet dialog and supply the authorized password exactly as recorded. Passwords are case-sensitive. A successful entry releases that sheet’s edit controls; a rejected entry changes nothing. Excel does not offer a legitimate built-in route around an unknown password, and Microsoft cannot retrieve it.

1. Select the sheet and choose Review > Unprotect Sheet.
2. Enter the password in Excel’s password field. Check Caps Lock and the keyboard layout if a known password is rejected.
3. Click OK. The ribbon command should change to Protect Sheet.
4. Test one formerly locked cell, then reverse the test if it changed real data.

Use the workbook’s approved password manager or internal documentation rather than copying a password into a macro, chat, ticket, email, or unencrypted note. If several sheets use different passwords, handle each through its own Excel prompt so you can confirm which credential applies.

This workflow removes worksheet protection only. If the file requires a password before it opens, that is file-level encryption. If sheet tabs cannot be added, deleted, moved, hidden, or renamed, workbook-structure protection is also active.

What to Do If the Password Is Missing

If you do not have the worksheet password, stop and confirm ownership rather than trying to unlock excel sheet controls through a bypass. Ask the workbook owner or administrator, search an organization-approved password vault, inspect authorized documentation, or restore a known-good backup. Microsoft provides no password retrieval service, and unknown recovery utilities add disclosure and integrity risks.

Use this recovery order:

1. Confirm the correct file and sheet. A copied template or older version may have a different password.
2. Contact the owner or administrator. They may unprotect the sheet, provide an editable copy, or make the requested change for you.
3. Check approved records. Search the team’s password manager, handover notes, or controlled document-management system.
4. Restore an authorized backup. Version history in SharePoint, OneDrive, or your backup platform may contain a usable version. Preserve the current file until you verify the restored copy.
5. Escalate through IT or governance. For regulated or confidential data, follow the organization’s access and incident procedures.

Do not upload a sensitive workbook to an unknown website or install an unvetted recovery executable. Even when a service claims to remove password protection, the workbook may expose customer data, formulas, credentials, hidden sheets, macros, or business logic. Owner authorization does not eliminate the need for vendor review and secure data handling.

How to Unprotect Multiple Sheets Safely

Desktop Excel has no ribbon command to unprotect every sheet. The VBA below attempts each tab and writes an explicit result—unprotected, already unprotected, or failed—to a visible audit workbook. It never stores credentials; password-protected sheets stay protected. Excel for the web cannot run it, so use Open in Desktop App.

Save a backup before running any macro. Use this only in a trusted workbook whose code you have reviewed:

Option Explicit

Private Const NON_CREDENTIAL As String = "__NO_PASSWORD_CHECK_7F4E9C2A__"

Sub UnprotectSheetsWithoutPasswords()
    Dim sourceBook As Workbook
    Dim auditBook As Workbook
    Dim auditSheet As Worksheet
    Dim ws As Worksheet
    Dim detail As String
    Dim initialState As String
    Dim result As String
    Dim rowNumber As Long

    Set sourceBook = ThisWorkbook
    Set auditBook = Workbooks.Add(xlWBATWorksheet)
    Set auditSheet = auditBook.Worksheets(1)

    On Error Resume Next
    auditSheet.Name = "Unprotect Audit"
    On Error GoTo 0

    auditSheet.Range("A1:D1").Value = Array( _
        "Worksheet", "Initial state", "Result", "Detail")
    rowNumber = 2

    For Each ws In sourceBook.Worksheets
        detail = ""

        If Not IsSheetProtected(ws) Then
            initialState = "Unprotected"
            result = "Already unprotected"
            detail = "No change needed"
        ElseIf TryUnprotectWithoutPassword(ws, detail) Then
            initialState = "Protected"
            result = "Unprotected"
            detail = "No password was set"
        Else
            initialState = "Protected"
            result = "Failed"
        End If

        auditSheet.Cells(rowNumber, 1).Value = ws.Name
        auditSheet.Cells(rowNumber, 2).Value = initialState
        auditSheet.Cells(rowNumber, 3).Value = result
        auditSheet.Cells(rowNumber, 4).Value = detail
        rowNumber = rowNumber + 1
    Next ws

    With auditSheet
        .Rows(1).Font.Bold = True
        .Range("A1:D" & rowNumber - 1).AutoFilter
        .Columns("A:D").EntireColumn.AutoFit
        .Activate
    End With

    MsgBox rowNumber - 2 & " worksheet results are in the " & _
        auditSheet.Name & " workbook. Save that workbook if you need the audit.", _
        vbInformation, "Worksheet unprotect audit complete"
End Sub

Private Function IsSheetProtected(ByVal ws As Worksheet) As Boolean
    IsSheetProtected = ws.ProtectContents _
        Or ws.ProtectDrawingObjects _
        Or ws.ProtectScenarios
End Function

Private Function TryUnprotectWithoutPassword( _
    ByVal ws As Worksheet, _
    ByRef detail As String) As Boolean

    On Error GoTo UnprotectFailed
    ' Deliberately pass a non-credential so Excel never prompts in this batch.
    ' Do not replace this value with a real password stored in VBA.
    ws.Unprotect Password:=NON_CREDENTIAL

    If IsSheetProtected(ws) Then
        detail = "still protected; use Excel's password prompt"
        TryUnprotectWithoutPassword = False
    Else
        TryUnprotectWithoutPassword = True
    End If
    Exit Function

UnprotectFailed:
    detail = "Excel error " & Err.Number & ": " & Err.Description
    TryUnprotectWithoutPassword = False
End Function

The helper passes a non-credential: Excel ignores it on unpassworded sheets but rejects it on password-protected sheets without asking the macro for a secret. The post-command check prevents false success. The new audit workbook records every source sheet, initial state, result, and detail in its own row; save that workbook if you need the record. For failed password-protected tabs, return to the source workbook and use Review > Unprotect Sheet with Excel’s masked prompt.

Worksheet, Workbook, and File Protection

Excel has three relevant protection layers: worksheet protection limits edits within one sheet; workbook protection limits structural changes across sheet tabs; file encryption requires a password to open the workbook. The first two are workflow controls, not substitutes for access control. Choose the layer that matches the action you need to permit or prevent.

Microsoft’s workbook-protection guidance confirms that workbook structure protection is different from protecting a file or worksheet. A model can use both worksheet and workbook controls, so releasing one layer may not release the other.

For confidential workbooks, use file encryption and your organization’s approved storage, sharing, identity, and data-loss-prevention controls. Even encryption does not make careless distribution safe; limit access to people who need the data and use the organization’s supported collaboration platform.

For a broader explanation of the layers and their intended uses, read Excel Workbook Protection. To configure editable inputs before protecting a sheet, see How to Lock Cells in Excel.

Troubleshooting Unprotect Sheet

When Unprotect Sheet does not produce the expected result, identify the active layer before changing anything else. A grey command can mean the sheet is already open to edits; a rejected password can indicate case or layout differences; disabled sheet-tab actions point to workbook structure; and an opening prompt indicates file encryption rather than worksheet protection.

The command is greyed out

Try editing a normal cell and check whether the Review tab says Protect Sheet. If so, worksheet protection is already off. Read-only mode, Protected View, restricted permissions, or a coauthoring state may still prevent edits.

A known password is rejected

Verify Caps Lock, keyboard language, leading or trailing spaces in your records, and whether you selected the correct sheet. Do not repeatedly paste credentials into logs or automation while diagnosing the issue.

Cells still seem locked

If the sheet is unprotected, the Locked checkbox can remain selected without being enforced. Another restriction—read-only access, file permissions, workbook policy, or an add-in—may be blocking the edit. Confirm the ribbon state and test in an authorized local copy.

Sheet-tab commands remain unavailable

Choose Review > Protect Workbook. If Excel requests a password, workbook structure is protected separately. Enter the authorized workbook password; the sheet password may not be the same.

How to Reapply Protection

After making authorized changes, review the Locked and Hidden cell flags, protect the worksheet again, select only the actions users need, and test both a locked formula and an editable input. Reapplying protection restores an edit guard against accidental changes; it does not turn the worksheet into encrypted storage or secure confidential data from workbook recipients.

1. Save and review the completed changes.
2. Select input cells that should remain editable, open Format Cells > Protection, and clear Locked.
3. Select Review > Protect Sheet.
4. Choose permitted actions and, if required, enter a password from an approved secure record.
5. Confirm the password, save the workbook, and test one locked cell plus one unlocked input.

Use Allow Users to Edit Ranges when people need recurring access to specific inputs. This can reduce repeated unprotect-and-reprotect cycles while preserving the worksheet’s guardrails. Keep a backup and document the permitted ranges so future owners understand the design.

FAQ

These FAQs explain what to do when a worksheet password is missing, how to audit multiple sheets, how sheet protection differs from workbook protection, and what happens to Locked and Hidden cell settings. Use Excel’s supported controls, preserve credentials outside VBA, and treat worksheet protection as an editing guard rather than encryption.

How do I unprotect an Excel sheet if I don’t have the password?

Microsoft provides zero password-recovery options for a protected worksheet. If the password was set, ask the owner or administrator, check an approved password vault, or restore an authorized backup. Do not upload a confidential workbook to an unknown recovery service. Microsoft says it cannot retrieve a forgotten password.

Can I unprotect multiple Excel sheets at once?

In desktop Excel, the macro in this guide attempts every worksheet and writes one visible row per worksheet to a new audit workbook: unprotected, already unprotected, or failed with detail. It never stores a password; save the audit workbook if you need the record. Excel for the web cannot create, run, or edit VBA, so use Open in Desktop App. See Microsoft’s VBA web guidance.

What is the difference between Unprotect Sheet and Unprotect Workbook?

They control two different editing layers. Unprotect Sheet releases locked-cell and worksheet-action restrictions on one sheet. Unprotect Workbook releases structural restrictions such as adding, deleting, moving, hiding, or renaming sheets. Neither is file-level encryption. Microsoft documents the layers separately.

Does unprotecting a sheet remove locked cell formatting?

No. Two cell flags—Locked and Hidden—remain set after worksheet protection is removed. Excel simply stops enforcing them. If you protect the sheet again, those same flags take effect unless you change them under Format Cells > Protection. Microsoft explains worksheet locking.