How to Unprotect Excel without or with Password

"Any way to unprotect Excel without password? I totally forgot about it."


Excel has password protection to prevent editing or opening. In most cases, you just forgot the password if you leave it for a long time. Fortunately, Excel has ways to unlock protected excel effectively.


This post will introduce ways to help you unprotect Excel sheet and workbook without password, and here also mention tips of how to set a password.

Part 1. Unprotect Excel without Knowing Password

Part 2. Unprotect Excel with Known Passwords

Tip 1. Set Password to Protect Excel Workbook

Tip 2. Set an Open Password to Protect Excel

Part 1. Unprotect Excel without Knowing Password

In this part, 4 methods are provided for you to unprotect excel without password.


#1 Unprotect with VBA Code

Unprotecting Excel spreadsheets, firstly, you should try VBA, which is a built-in function in Excel, although you will need to input a large number of codes during the course. Just copy and paste the code.

unprotect excel spreadsheets with vba code


Step 1. Open Excel and navigate to DEVELOPER.


Step 2. Find View Code under this section.

find view code under developer section


Step 3. Then you will enter a coding interface and now double-click on the password-protected sheet from the left column.

double click the password protected sheet


Step 4. Copy and paste the codes below into the right blank prompt.

Sub PasswordBreaker()

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


Step 5. Press F5 key to run the code.

run the vba code to unprotect sheet


Step 6. Then a small prompt will pop up to show you the password, and you can use it to unprotect a sheet in excel.


#2 Copy and Paste the Excel Worksheet

Directly, to get the content without unprotecting Excel workbooks, you can try copying the whole content from the locked Excel and paste it into the new one. If you are allowed to elect locked cells and selected unlocked cells, you can try this method to remove excel password.


Note:

1. External links need to be created to the new workbook manually.

2. The column widths can be copied by choosing Paste Special.


Step 1. Open the locked Excel and click on cell A1.


Step 2. Tap Shift + Ctrl + End to choose all content and then tap Ctrl + C to copy it.


Step 3. Create a new Excel file and click on cell A1.


Step 4. Tap Ctrl + V to paste the copied content.


Step 5. Now you can edit on the new Excel.


By this solution, you don't have to unprotect excel workbook.


#3 Uploading to Google Sheets

Google sheet is another website workbook, which can help you upload local workbook and unprotect Excel sheet for other edition. But this approach requires a Google account. If you do not have one, you need to create an account or try other methods.

unprotect excel sheet with google sheet


Step 1. Enter the website of Google sheet: Drive.Google and sign in your account.


Step 2. Click on "+ New" button on the left and choose "File upload" to upload your protected Excel file.

click + new button and choose file upload


Step 3. Navigate to the target Excel file and click on Open to upload it.

click open to upload the target excel file


Step 4. Click on the Excel file in your Google sheet to preview it.


Step 5. Click on Open with button and choose Google sheet to open the file.

choose google sheet to open the file


Step 6. At this moment, the previous protection on your Excel has been removed.


Step 7. Then click File section and choose Download as any format you desire and save it on your PC.

save the unprotect excel sheet as any format


You've learned how to unprotect an excel sheet without password.


#4 Unlock Protected Excel 2017/2016/2013 – Password Genius

Of course, if you want to recover the lost password to unlock excel file and workbook, it is easy. But this requires the help from pro tool. Here we recommend software called Password Genius, especially responsible for recovering office passwords.


This software provides a fairly convenient and reliable password recovery function for Office applications. Of course, the recovery rate is quite high (almost 99%). In addition to Office programs, the software can also crack password of RAR, ZIP, PDF, and Word files etc.


Before the steps to use Password Genius for Excel password recovery, please download and install in on your PC.


download on Win


Step 1. Launch Password Genius on your PC and choose "Recover Passwords for Files and Archives" mode at the first place.

select recover passwords for files and archives


Step 2. Then choose "Excel Password Recovery" at the second place.

choose a office password recovery mode


Step 3. Click on the folder icon to locate the locked Excel workbook you want to recover.

click open to add a password locked file


Step 4. Then choose the Type of Attack from the list.


Note: There are 4 types provided, the briefing of these 4 modes are set as below:


Brute-force

In this mode, you need to recall the length and range of your password, because such specification helps to reduce the time for recovery.

brute force attack to recover password


Mask

For mask mode, you should either set range and lengthen, or type the known number or character into the mask box, and type "?" for the unknown ones.

mask attack to recover password


Dictionary

Before using this mode, you can use the default dictionary or create a TXT file and type all possible password for the future references. Then click on Select Dictionary to locate the dic file.

dictionary attack to recover password


Smart

This is the most smile mode, which means you don't need to adjust any settings. But the downside is that longer time is consumed under this mode.

smart attack to recover password


Step 5. Then you can click on Start button to start the recovery progress. You can Stop it at any moment.

start recovering password protection from file


Step 6. Once the recovery finishes, you will get the password. Click on Copy and then Open buttons to unprotect an excel workbook.


download on Win


Another professional tool to unprotect excel is PassFab for Excel, which provides three unlock modes to provide the highest possibility for unlocking passwords. Whether it is a workbook or worksheet password, it can quickly recover the password.



Part 2. Unprotect Excel with Known Passwords

On the other hand, if you already know the password, the situation will be easier to handle.


#1 Unlock an Excel Spreadsheet by Entering Password

Step 1. Double click on the locked Excel workbook to open it.


Step 2. Move cursor to the tab of the workbook and right click on it to open the context menu.

(The protection removal cannot be achieved in batch so you have to remove them one by one if there are more than one protected workbook.)


Step 3. Click on Unprotect Sheet on the top.

 click unprotect sheet



Step 4. Then input the password that you already know and click on OK.

unprotect excel sheeet by typing password


#2 Unprotect Excel Workbook by Deleting Password

Generally, we can also track back to the procedures of password settings to unlock excel.


Step 1. Open the locked Excel file and navigate to File section.


Step 2. Click on Save as and find Tool button.


Step 3. In the prompt, click on the triangle of tool menu and choose General options.

choose general options in save as window


Step 4. For removing the password, delete the passwords you previously set in the box(es) and click on OK to save your setting.

unprotect excel workbook by deleting password



Tip 1. Set Password to Protect Excel Workbook

Directly, follow the steps to set a password to protect excel workbook.


Step 1. Open a excel workbook.


Step 2. Find Review section and choose Protect Workbook.


Step 3. Type password to confirm and save the settings.

set password to protect excel workbook


Tip 2. Set an Open Password to Protect Excel

To prevent others from opening your important workbook at the beginning, there is a way to set an open password.


Step 1. Open one workbook that you want to protect and click on File.


Step 2. Choose Info at the first of the left menu and select Protect Workbook.


Step 3. Then choose Encrypt with Password for further encryption.

set open password to protect excel


Step 4. Enter a password and click on OK.

(Remember to notice the caution under the password box.)

type correct password and click ok


Step 5. Enter the password again to confirm, click on OK and save the setting.



The Bottom Line

All right! These are the ways to unprotect Excel. Keep in mind that password is a very important thing. In daily work, keeping password can store your files saver. At the same time, you don't have to worry about ways to retrieve password, because with password genius, it is easy to crack password without file damage or data leakage.


Welcome to share your comment about excel unprotect sheet below.


Last Updated: June 24, 2020

Author: Cori S. Kim  /     

Passionate about Smartphone products, aiming to provide useful methods as well as how-to tips to fix iPhone, iPad, Android related issues.


Related Articles

How to Bypass Windows 10 Login/Admin Password Screen
How to Remove/Crack/Break Password from Excel (Workbook, Spreadsheet)
RAR Password Unlocker: 5 Ways to Unlock RAR/WinRAR Password
How to Crack/Break RAR/WinRAR Password? [Solved!]
How to Unprotect Excel without or with Password
Forgot Excel Password? Excel Password Recovery Tutorial Here!
How to Unlock Word Document with or without Password
Enter the Password to Unlock your iPhone Backup (Solved)
How to Remove Password from Word Document? (Solved!)