Password protection is the easiest way to keep the contents of any document private and this method is often used in many documents with highly sensitive information. As you can expect, password protection can be a very valuable asset, particularly for businesses that handle or deal with sensitive information, not meant for the public. They serve to keep the information in the document only available to the few ones who need the information.
But on the flipside, a password-protected Excel worksheet can be very problematic to handle especially when you don't know the password or if you somehow lose a complex password and can't remember it. It can be even worse if only sections of the document have been protected, meaning that you can't edit or format any part of the Excel sheet. If you are in a situation where you've lost the password, you don't remember the password or you don't have access to the password but you still need to edit the Excel sheet, this article will come in very handy. That's because we are going to share with you various ways you can to unprotect Excel sheet or Excel workbook, rendering it easily editable.
Let's begin with the easiest.
Part 1. How to Unprotect Excel Sheet with Password
When you know the password, unlocking the protected worksheet can be as simple as the following;
If you are using Excel 2003:
Step 1: From the toolbar, click on "File".
Step 2: Hover to the file you want to unlock and open it.
Step 3: Click on "Tools" and then choose "Protection" from the drop-down menu.
Step 4: After clicking on "Protection", click on "Unprotect Worksheet" from the options. You will get a pop-up box into which you can type in the password that you already know. Then type in the password.
If you are using later versions of Excel, 2010, 2013 and 2016:
Step 1: Open the protected document that you want to unlock. You can do that by clicking on "File > Open" and then browsing for the file you need.
Step 2: Select "Review" on the top ribbon and then click on "Unprotect Sheet".
Step 3: Enter the password and the document will be unlocked.
This method only works if you already know the password on the protected file. Keep reading if you don't know the password.
Part 2. How to Unprotect Excel Worksheet/Workbook Without Password
The following methods will help you unlock the password of your MS Excel Worksheet or Workbook if you don't know the password, choose the best one according to the comparison form below:
|Way 1-Passper for Excel||Way 2-Using ZIP||Way 3-Using VBA Code||Way 4-Online Tool|
|Remove 'Password to Modify'|
|Recover 'Password to Open'|
|Security||100% secure, no data loss||Data loss||Data loss||Not secure, the data is often divulged very easily|
|Complexity||Easy to use||Complex, not easy for beginners||Complex and time-consuming||Easy|
|Unprotect Time||3s, in one click||10 mins||25mins||30s|
Way 1: Unprotect Excel Worksheet/Workbook with Passper for Excel
If you don't have the password used to unprotect the Excel sheet, you may find it highly problematic to do simple things like edit sections of a document. One of the ways to work around this problem is to use Passper for Excel. Passper for Excel is highly effective in password recovery because it has the necessary technology to help you recover the opening password, no matter how strong or complex it is. It can also be highly influential in helping you remove restrictions from an Excel worksheet, rendering it editable. It is not uncommon for document owners to lock some features of the document. They can make it hard for you to edit the sheets or even simply format the content.
The following step by step guide shows you how to use the program to remove restrictions on an Excel sheet;
Step 1Once the program is installed on your computer, launch Passper for Excel and then select "Remove Restrictions" on the main window to begin.
Step 2Now click on "+" to select the Excel worksheet or workbook that you want to unprotect.
Step 3When the document is added, simply click on "Remove" and the program will remove any restrictions placed on the document.
Way 2: How to Unprotect Excel Workbook via ZIP
You can also use ZIP software to easily access a password-protected MS Excel workbook. The following is a simple guide to show you how;
Step 1: Install a ZIP supported compression program like 7-Zip on to your computer.
Step 2: Locate the Excel sheet or workbook you want to unprotect, then right-click on it and select "Open with 7-ZIP". You should see several folder and files.
Step 3: In the "xl" folder, locate the "workbook.xml", right click on it and then select "Edit". This will open the file in Notepad or any other text editor on your computer.
Step 4: Locate and completely delete the following tag in the editor: "<workbookProtection workbookPassword="93AF" lockStructure="1" lockWindows="1"/>".
Step 5: Close the editor and when 7-Zip asks you to replace the existing XML file, click on "Yes" to save the modified document.
Step 6: Now simply open the Excel file and the password will be removed, giving you access to the document.
Note: If you have password protection on the worksheet, go to ‘'xl\worksheets\sheet1.xml" and remove the tag "<sheetProtection … >".
Way 3: Using VBA Code
This method involves executing some VBA codes to unlock your protected Excel file. However, it only works with the old versions of Excel.
Step 1: Open the protected worksheet normally using Microsoft Excel.
Step 2: Press and hold "ALT + F11" to access the Microsoft Visual Basic for Application interface.
Step 3: Click on "Insert > Module" and in the Module Window, paste the code below.
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)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Step 4: After pasting the code, press the "F5" key. This will execute the code, and on the next pop-up prompt, click on "OK". The password in the Excel file will be removed right away.
Way 4: Unprotect Sheet via Online Excel Password Remover
There are also certain options to help you unlock an Excel spreadsheet online. These online tools are very easy to use as the following step by step process shows;
Step 1: Go to http://service.password-find.com to access the tool you'll need to unlock the Excel spreadsheet.
Step 2: Click on "Unprotect Your File" button on the main window.
Step 3: Upload the file you need to unlock and then click "Next" to start the process to unlock the document.
In a few minutes, the online tool will easily unlock the document and you can then download the file and save it to your computer.
Part 3. How to Unprotect an Excel Document to Open the File
If you receive an Excel file that is protected with an opening password, Passper for Excel is also here for you. This program is meant to make it easier for you to open any password-protected MS Excel document when you don't know the password. As such, it can be useful to you if you forgot your password, if you lost your password or if you simply don't know the password.
Passper for Excel comes in four different attack modes to recover opening passwords for Excel files, each uniquely able to unlock any document. These attack modes include the following:
Dictionary attack can be used for various file types. It works by allowing you to try all password combinations although you can also provide one of your own from the settings menu.
Combination Attack identifies the password by combining all the letters, numbers and symbols you provide even if they are sensitive information.
Mask Attack is the attack mode to choose when you have a clue as to the possible password. It works by considering all aspects of a password including the characters, suffixes, prefixes and even the length of the password. You provide Passer for Excel with any information you may have about the password and the program works out what the password could be.
Brute force attack is the best solution if you don't know the password and have no clues as to what it may be. Because there is very little information to recover the password, a Brute force Attack may take longer than the others.
The following is how to open a locked Excel document using Passper for Excel in three simple steps;
Step 1Install Passper for Excel on to your computer and then launch the program. Click on "Recover Passwords" and then click on "+" to browse for the password-protected Excel files you need to unprotect.
Step 2 Next, choose the most appropriate attack mode from the three modes available on the interface.
Step 3Once the preferred mode is selected, the program will immediately begin recovering the password which will be displayed on the screen shortly.
You can then use the password to unlock the file and continue to edit it.
A password can provide the best way to protect a document from prying eyes. But as we have seen throughout the article, the password can also become a problem when you lose it or simply don't remember it. Fortunately for you, we have provided you with numerous ways to help you overcome this hurdle and easily unprotect Excel sheet with or without password.
Yet, Passper for Excel provides the best way to remove a password and unlock the file. The process is easy and you will have a fully-editable document in three simple steps. It even helps you overcome some of the restrictions that can keep you from editing the document.