How To Unlock Excel Sheet

Getting locked out of an Excel sheet can bring your work to a halt. This guide provides clear, step-by-step instructions for unlocking protected Excel worksheets and workbooks. We'll cover what to do if you have the password, and what your options are if you've forgotten it. Whether you need to make a quick edit or recover a crucial file, these methods will help you regain control of your spreadsheet safely and effectively.

Fast Answer

With Password: Go to the Review tab and click Unprotect Sheet or Unprotect Workbook.
Without Password: Requires advanced methods like using a VBA script or editing the sheet's XML code.

2-20 Minutes Time needed

Easy to Advanced Difficulty

Accidental data loss Watch out for

Before You Start

Before attempting to unlock any Excel file, it's crucial to prepare properly. This ensures you don't accidentally lose important data or make the problem worse. Taking a moment to get organised now will save you a lot of trouble later.

A Copy of Your Excel File: This is the most important requirement. Never work on your original file when trying advanced recovery methods.
Microsoft Excel: You will need a desktop version of Excel (2010 or newer is best). Some methods may not work with online or mobile versions.
A Text Editor (for advanced methods): A basic text editor like Notepad (Windows) or TextEdit (Mac) is needed for the XML method.
Administrator Privileges: Some steps, like changing file permissions, may require you to be an administrator on your computer.

Check first: Always, always, create a backup copy of your Excel file before trying any method, especially those for when you've forgotten a password. If something goes wrong, you'll still have your original file untouched.

Step-by-Step Instructions

There are several types of "locks" in Excel. Start with the first step that matches your situation. If you know the password, the process is very straightforward. If not, we'll move on to more technical solutions.

Unprotect a Worksheet If You Know the Password

This is the most common scenario. A worksheet is protected to prevent accidental changes to formulas or data. If you have the password, unlocking it takes just a few clicks.

Open your Excel file and go to the worksheet that is locked.
Click on the Review tab in the top ribbon menu.
Look for the Unprotect Sheet button in the "Protect" group. If the sheet is protected, this button will be available.
Click Unprotect Sheet. A small window will pop up asking for the password.
Carefully type the password into the box and click OK. The password box is case-sensitive, so make sure you type it exactly right.

The sheet is now unlocked, and you can edit any of the cells freely.

Tip: If you see a "Protect Sheet" button instead of "Unprotect Sheet", it means the current worksheet is not protected. The issue might be with workbook protection or file permissions.

Unprotect a Workbook If You Know the Password

Sometimes the whole workbook structure is locked. This prevents you from adding, deleting, renaming, or moving worksheets. The process is very similar to unprotecting a single sheet.

With your Excel file open, click on the Review tab in the ribbon.
Look for the Protect Workbook button. It will appear highlighted or pressed in if the workbook structure is locked.
Click the Protect Workbook button. A dialogue box will appear asking for the password.
Enter the correct password and click OK.

You can now add new sheets, delete old ones, and reorganise your workbook as needed.

Remove 'Read-Only' Status from a File

If Excel opens your file with a "Read-Only" message at the top, the lock might not be a password at all. It could be a file attribute set in your operating system. This is easy to fix outside of Excel.

For Windows users:

Close the file in Excel.
Find the file in Windows File Explorer.
Right-click on the file icon and select Properties from the menu.
In the "General" tab at the bottom, look for the "Attributes" section.
If the Read-only box is ticked, untick it.
Click Apply, then OK.

For Mac users:

Close the file in Excel.
Find the file in Finder.
Right-click (or Ctrl-click) the file and select Get Info.
Expand the Sharing & Permissions section at the bottom.
Change your user account's privilege from "Read only" to Read & Write. You may need to click the lock icon and enter your Mac's password to make this change.

Now, when you re-open the file in Excel, you should be able to save your changes.

Unlock a Worksheet Without a Password (VBA Script Method)

If you've forgotten the password for a protected worksheet, don't worry. This method uses a small piece of code (a VBA script) to test thousands of possible passwords very quickly, eventually finding one that works. It is safe, but you must follow the steps exactly. Remember to work on a copy of your file.

Open your backup copy of the locked Excel file.
Press Alt + F11 on your keyboard to open the Visual Basic for Applications (VBA) editor. (On some laptops or Macs, you may need to press Fn + Alt + F11).
In the VBA editor, go to the top menu and click Insert > Module. A new blank white window will appear.
Copy and paste the following code exactly as it is into the blank module window:

Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Now, press the F5 key to run the code. You can also click Run > Run Sub/UserForm from the top menu.
The script will run for a few seconds or up to a minute. When it's finished, a message box will appear with a working password. Click OK.
Close the VBA editor by pressing Alt + Q or clicking the 'X'. Your sheet is now unprotected.

You can now edit the sheet. Remember to save the file. Excel may ask you to save it as a "Macro-Enabled Workbook" (.xlsm). You can do this, or save it as a regular .xlsx file after the protection is removed.

Important: If you get an error or nothing happens, your security settings might be blocking macros. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and ensure "Disable all macros with notification" is selected. Then re-open the file and click "Enable Content" when prompted.

Unlock a Worksheet Without a Password (XML Method)

This method is more technical but highly effective for modern Excel files (.xlsx format). It involves changing the file into a zip folder to manually remove the protection tag from the worksheet's code. It sounds complicated, but if you follow carefully, it's very reliable. This will not work on older .xls files.

Start with your backup copy. Let's say your file is named `Report_Backup.xlsx`.
Rename the file and change its extension from `.xlsx` to `.zip`. So, `Report_Backup.xlsx` becomes `Report_Backup.zip`. Windows will warn you that the file might become unusable; click Yes to proceed.
Now, double-click the `Report_Backup.zip` file. It will open like a normal folder.
Navigate inside the folder structure to: xl > worksheets.
Inside this folder, you will see files like `sheet1.xml`, `sheet2.xml`, etc. You need to find the file that corresponds to your locked sheet. If it's the first sheet, it's likely `sheet1.xml`.
Drag the correct XML file (e.g., `sheet1.xml`) out of the zip folder and onto your desktop.
Right-click the XML file on your desktop and choose Open with > Notepad (or another text editor).
The file will open as a large block of code. Don't be intimidated. Press Ctrl + F to open the find tool and search for the word `protection`.
You will find a tag that looks something like this: ``.
Carefully delete this entire tag. It starts with ``. Make sure you delete the whole thing and nothing else.
Save the XML file and close the text editor.
Drag the edited XML file from your desktop back into the `worksheets` folder inside the zip archive. It will ask if you want to replace the existing file. Choose Yes.
Close the zip archive.
Finally, rename the file back, changing the extension from `.zip` to `.xlsx`. So `Report_Backup.zip` becomes `Report_Backup.xlsx` again.

Now, open the Excel file. The worksheet should be completely unlocked, with no password required.

Tip: If you can't see file extensions like `.xlsx` in Windows, open File Explorer, click the "View" tab, and tick the box for "File name extensions".

Quick Reference

Situation	Use this Method	Why
Worksheet is locked, and I know the password.	Review Tab > Unprotect Sheet	The standard, built-in way to unlock a sheet. Quick and easy.
Workbook is locked, and I know the password.	Review Tab > Protect Workbook	The standard method for unlocking the workbook structure.
File opens as "Read-Only".	File Properties (Right-click)	The lock is a file system setting, not an Excel password.
Worksheet is locked, and I ve forgotten the password.	VBA Script or XML Method	These advanced methods bypass the need for a password. XML is often faster if you're comfortable with the steps.
The whole file asks for a password just to open it.	None of these methods	This is file encryption, which is much stronger. This guide does not cover breaking file encryption.

Common Problems When You Unlock Excel Sheet

Even with the best instructions, you can run into trouble. Here are some common issues and how to solve them.

The "Unprotect Sheet" Button is Greyed Out

This usually means one of two things. First, the active worksheet you're looking at isn't actually protected. Click on another sheet tab at the bottom to see if the button becomes active. Second, the workbook might be a "Shared Workbook," an older feature that limited editing. Go to the Review tab and see if you can click a button that says Unshare Workbook.

The VBA Script Doesn't Work or Gives an Error

The most common cause is that macros are disabled in your Excel's security settings. Follow the tip in the VBA step above to enable them. Another reason could be that the protection on your sheet is unusually complex. The script works for most standard passwords but may fail on very old or uniquely protected files.

I Can't See File Extensions (.xlsx) to Rename the File

By default, Windows hides file extensions. To show them, open File Explorer, click the View tab at the top, and in the "Show/hide" section, make sure the box next to File name extensions is ticked. Now you should be able to see and change `.xlsx` to `.zip`.

My File is Corrupted After Using the XML Method

This almost always happens because of a small mistake editing the XML file. You might have deleted an extra character, like a closing bracket (`>`), or not deleted the entire `` tag. This is exactly why working on a backup is so important. Delete the broken file, make a fresh copy of your original, and try the XML steps again, paying very close attention to deleting only the correct tag.

Advanced Tips for how to unlock excel sheet

Once you've mastered the basics, these tips can help you manage sheet protection more effectively.

Understand the Difference: It's key to know what you're dealing with. Worksheet Protection stops you from editing cells. Workbook Protection stops you from changing the structure (adding/deleting sheets). File Encryption (Password to Open) locks the entire file from being viewed. Knowing which one is active tells you which solution to use.
Managing Passwords in a Team: If you work with shared files, avoid this problem in the future. Use a password manager to store sheet and workbook passwords securely. Agree on a standard, simple password for low-security sheets (like `review`) that is easy for the team to remember.
Partial Protection: You don't have to lock an entire sheet. You can lock specific cells while leaving others open for editing. To do this, first unlock all cells (Ctrl+A to select all, then Right-click > Format Cells > Protection tab, and untick "Locked"). Then, select only the cells you want to protect, go back to the same menu, and tick "Locked". Finally, protect the sheet with a password. This is great for forms and templates.
Third-Party Tools: There are specialised software tools designed to remove Excel passwords. While some can be effective, they often cost money and carry a risk of being bundled with malware. The free methods in this guide (VBA and XML) are generally safer and just as effective for worksheet protection.

How To Unlock Excel Sheet FAQ

What's the difference between worksheet and workbook protection?

Worksheet protection applies to a single sheet (tab) in your file. It prevents users from changing the contents of cells. Workbook protection applies to the entire file's structure. It prevents users from adding, deleting, hiding, or renaming the worksheets.

Is it legal to unlock an Excel sheet without the password?

Yes, as long as you are the rightful owner of the file or have permission to access and edit it. These methods are for recovering your own work or files you are authorised to use. Using them to access confidential information you don't have rights to could have legal consequences.

Will these methods work on Excel for Mac?

Yes, most of them will. Unprotecting with a password works identically. The VBA script method also works on Mac, though opening the VBA editor might require a different keyboard shortcut (often Fn + Option + F11). The XML method is also possible on Mac, as you can rename files and edit XML content just like on Windows.

Can I unlock a file that asks for a password to open?

No. The methods in this guide are for worksheet and workbook protection only. A password required to open the file means it is encrypted. Breaking file encryption is a much more complex process and is not covered here. There is no simple trick to bypass this level of security.

Why would someone protect an Excel sheet?

Protection is usually not about secrecy, but about preventing accidents. In complex spreadsheets with many formulas, it's easy to accidentally type over a critical calculation. Protecting the sheet ensures that only input cells can be changed, preserving the integrity of the formulas and the structure of the sheet.

Final Checklist for how to unlock excel sheet

Before you finish, run through this quick checklist to make sure you've covered all the bases and your file is ready to use.

Create a Backup: Did you make a copy of your file before you started? If not, do it now before making any more changes.
Identify the Lock Type: Is it the worksheet, the workbook, or a read-only file attribute? Using the right method for the right lock is key.
Try the Password First: If there's any chance you know the password, try it. Check for common passwords you use or ask the person who sent you the file.
Execute Advanced Methods Carefully: If using the VBA or XML method, follow each step precisely. Small errors are the main reason these methods fail.
Save Your Unlocked File: Once the sheet is unlocked, save the file. You can save it over your copy or use "Save As" to give it a new name.
Consider Future Protection: If you need to re-protect the sheet, consider using the "partial protection" tip to only lock the essential cells, making it easier for others to use the file.