Sometimes it can become necessary to protect Excel worksheets especially when you need to share them with someone outside your organization. The best way to do this is to use Excel's own password protection feature. This feature makes it easy for you to add a password to any document to make some of the content in the document or the whole document inaccessible. It is very easy to password protect a worksheet and just as easy to forget Excel sheet password.
Maybe you chose a password that was extremely difficult to remember and you lost any record of it. This can mean that you are completely unable to access any section of the document and that you are even unable to edit or read it. If this is the situation you find yourself in, this tutorial will be extremely helpful to you. In it, we will share with you various ways you can use to recover the forgotten excel worksheet password and gain back access to the document.
1. About Excel Sheets
Before we get to the various ways you can use to recover the forgotten password, we thought we'd share with you some of the most important aspects of this password protection feature and how it works.
To begin with, the worksheet protection feature found in Excel is not a security feature. It is merely intended to make it harder for other people (people without the password) from accessing the data on the document. This is because the feature uses a very simple encryption algorithm to protect the document which means any password you use to protect an Excel worksheet will be easy to break.
This is especially true in older versions of Excel (older than Excel 2010). No matter how long or how complex the password is in these older versions, anyone with VBA knowledge can easily crack it. Recent versions of Excel like Excel 2016 and Excel 2019 use more sophisticated methods but can still be unlocked without the password.
But this doesn't mean that any protections you apply to your Excel document are worthless. They can be very helpful to lock Excel worksheets to prevent accidental edits. For example, you can lock formula cells to prevent accidental modification of any of the data on the sheet.
That said if you've set a password on your worksheet, the following methods can help you unlock it whether you have the password or not.
2. Unlock Excel Sheet with Password
If you know what the password is, the following simple steps will help you use it to unlock the document;
Step 1: Open the document you want to unlock in Excel.
Step 2: Now either right-click on the sheet tab and then choose "Unprotect Sheet" from the options presented.
Or, click on the "Review" tab and click "Unprotect Sheet" in the "Changes" section.
You can also click on the "Home Tab > Cells Group > Format" and then choose "Unprotect Sheet" from the options presented.
Step 3: Enter the password associated with the document and the click "OK".
3. Unlock Excel Sheet without Password
If you don't know the password or you forgot Excel sheet password, try one of the following solutions to unlock the Excel sheet.
3.1 Via Google Sheets
If you have a Google Drive account, there is a little-known but very simple way to unlock the document using Google Sheets. Follow these simple steps to do it;
Step 1: Open your Google Drive Account and sign in if you haven't already.
Step 2: Now, click on "New" and choose "Google Sheet" to open a new sheet.
Step 3: Click on "File" and choose "Import" and click on "Upload" in the dialogue box that appears.
Step 4: Click on "Select a File from your Device" to browse for the protected spreadsheet you want to unlock. Locate it, click on it and then choose "Open".
Step 5: Now in the window of importing file, click on "Replace Spreadsheet" and then choose "Import Data".
This imports the Excel worksheet into Google Sheets without the protection and you'll find it easy to edit.
3.2 Via VBA Code
Like we mentioned before, if you know your way around a VBA code, you can easily unlock an Excel document even without the password protection. Here's how VBA codes can help you unprotect an Excel document.
Step 1: Open the Excel and then press ALT + F11 on your keyboard at the same time. This will allow you to edit Visual Basic Code. You can also access it by clicking on "Developer > View Code".
Step 2: Now double-click on the protected worksheet and then copy and paste the following code into the window. Make sure that you copy the entire code without changing anything;
Step 3: Click on "Run" or press F5 on your keyboard and that's it. Your Excel worksheet will be easily unlocked.
3.3 By Copying the Sheet Content
Another very simple way to unlock protected Excel sheet and make it editable again is to simply copy its content on to another worksheet. The following is the most efficient way to do it;
Step 1: Open the protected worksheet and place your cursor in the "A1" cell. Press "Shift + Ctrl + End" on your keyboard to select all the cells in the sheet.
Step 2: Now either create a new worksheet in the same workbook or open a new workbook.
Step 3: Place the cursor in the "A1"cell of the new worksheet and hit "Ctrl + V" on your keyboard to paste the contents of the protected sheet into the new sheet.
Note: You can only use this method if the "Select Locked Cells" and "Select Unlocked Cells" features are enabled on the protected worksheet.
3.4 Unlock Excel Sheet in One Click with Passper for Excel
All the methods above can be very helpful when you have a protected Excel worksheet without a password, but perhaps the most effective way to unlock an Excel worksheet is to use Passper for Excel. This program allows you to unlock any document regardless of how long or how complicated the password is. Some of the features that make Passper the ideal solution include the following;
It can help you gain access to an Excel Worksheet if you've forgotten the password, can't copy the worksheet or when you can't edit or print the workbook.
It is very easy to use, allowing you to unlock the document in just three simple steps.
It uses four different attack modes. Each is modified to suit a certain type of password.
It can also remove worksheet restrictions in a single-click.
Follow these simple steps to remove restrictions on any worksheet using Passper for Excel if you forgot Excel sheet password;
Step 1: Install the program on your computer and then launch it. In the main window, click on "Remove Restrictions" tab.
Step 2: Click "Add" to import the protected Excel document into Passper for Excel.
Step 3: Now simply click on "Remove" to eliminate any restrictions on the document.
3.5 How to Recover Opening Excel Document without Password
Passper for Excel can also help you recover the opening password for any Excel document. Here's how;
Step 1: Open Passper for Excel on your computer and select "Recover Passwords" in the main window.
Step 2: Click on "Add" to import the protected file into the program. Once the file is open, select the most appropriate attack mode to help you find the password.
Step 3: Passper will begin recovering the password. When the process is complete, the password will be displayed on the screen. You can use it to unlock the document.
Tip: How to Lock Specific Cells in a Protected Excel Sheet
Ordinarily, protecting a worksheet will lock all cells. But you can very easily lock only specific cells before protecting the worksheet so that only these cells will be locked. Here's how to do that;
Step 1: If the sheet is protected, begin by unprotecting it using one of the processes we've outlined above.
Step 2: Now click on the "Select All" button to highlight the entire sheet.
Step 3: Hit "Ctrl + Shift +F" on your keyboard to open the "Format Cells" popup.
Step 4: In the "Protection" tab, uncheck the "locked" box and click "OK".
Step 5: Now select the cells you want to lock on the worksheet and open the "Format Cells" popup again.
Step 6: Now under "Protection" section, check the "Locked" option and then click on "OK".
You can then protect the whole worksheet again and only the selected cells will be locked.