How to Edit Protected Excel Sheet | Official Unlock Steps

A protected Excel sheet can be edited after the owner uses Review > Unprotect Sheet, or removes file-level restrictions under File > Info > Protect Workbook.

Excel’s protection features serve two different purposes, and which one is blocking your edits changes the fix. If the worksheet itself is protected, a single menu command—Review > Unprotect Sheet—removes the editing restriction when you have the password. If the entire workbook is encrypted or locked at the file level, the route goes through File > Info > Protect Workbook instead. Matching the right method to the right type of protection is the difference between a two-second fix and a frustrating dead end.

What Kind of Protection Is Blocking Your Edits?

Excel has two separate layers of protection, and they work independently. Sheet protection restricts what anyone can do inside a single worksheet—editing specific cells, sorting, deleting rows. Workbook protection controls the file itself: who can open it, modify its structure, or save changes. The same user interface can hold both at once, so checking which one applies is the first step.

Microsoft’s support documents treat these as separate features with separate menu paths. Opening a protected workbook and seeing a password prompt at the file level is a different problem from opening the file and finding cells you cannot type into.

Editing a Protected Excel Sheet: Understanding the Two Lock Types

The table below lays out the most common protection scenarios you will encounter in Excel and the exact route to remove each one. The method that works depends entirely on which layer has been applied.

How to Unprotect a Sheet Using the Password

When you know the password, removing sheet protection takes about ten seconds. Open the workbook, click the protected worksheet tab at the bottom, then head to the ribbon and select Review > Unprotect Sheet. Excel will ask for the password if one was set. Enter it, and the sheet unlocks immediately.

After the sheet is unprotected, you can edit any cell, add or delete rows, and change formatting freely. Microsoft notes that the same Review tab is where sheet protection gets applied in the first place—Review > Protect Sheet lets the owner set a password and choose exactly which actions to allow.

If the password is correct and the command runs without errors, every locked cell becomes editable. Save the workbook afterward to keep the changes.

How to Remove Workbook or File-Level Protection

When the problem is at the file level rather than the worksheet level, the menu path shifts. Go to File > Info > Protect Workbook. From there you can remove encryption passwords, clear restricted access settings, or turn off Mark as Final. Each option requires the original password or permissions that the owner set.

Microsoft’s support guidance for a locked editing scenario also recommends checking whether the file is still open on another device. Close the workbook everywhere it is running, and if the file lives on a shared server or in OneDrive, wait a few seconds for the lock to release. For co-authoring scenarios, Microsoft specifies that the file should be saved in .xlsx, .xlsm, or .xlsb format to avoid compatibility lockups.

What If You Don’t Have the Password?

Excel’s security features are designed to be removed only by someone who knows the password. The official path is to contact the workbook owner or, in a corporate environment, ask IT to recover access through organizational tools. Several unofficial methods circulate online—renaming the file to .zip and editing XML tags, or running VBA scripts to strip protection—but Microsoft does not document or support these approaches, and they risk corrupting the file beyond repair.

If the workbook belongs to you and you simply forgot the password, check whether you saved it in a password manager or have an older unlocked copy. Otherwise, no documented Microsoft procedure exists to recover a lost sheet password without the original credentials.

Troubleshooting the Most Common Lock Scenarios

Microsoft’s locked-file troubleshooting guide covers several situations that look like protection but have different root causes. The table below matches each symptom to the likely fix.

From Locked to Editable: The Action Sequence

When you run into a protected Excel sheet, work through these four checks in order. Start with the simplest possibility and move deeper only if needed.

1. Check if the sheet itself is protected. Right-click the worksheet tab and see whether Unprotect Sheet appears in the menu. If it does, click it and enter the password.
2. Check file-level protection. Go to File > Info > Protect Workbook and look for any active restrictions—encryption, Mark as Final, or Restrict Access. Remove each one with the password.
3. Check whether the file is open elsewhere. Close Excel completely, reopen, and try again. For network files, confirm that no other user has the workbook open.
4. Contact the owner. If none of the menu options work and you do not have the password, the workbook owner is the only person who can remove the protection through normal Excel channels.

That sequence covers every legitimate editing scenario Microsoft supports. Stray outside it—into XML tag editing or VBA bypass scripts—and you risk losing the file entirely. Stick with the official menu paths, and the workbook stays intact.