Unlock Password Protected Excel File/Workbook/Sheet without Password

Tip 1: Unlock Password Protected Excel XLS File without Password – Remove Excel Password.

When you forgot Excel password, the fastest way to unlock the protected Excel file is directly remove the password with Excel Password Eraser and then you can open your password protected Excel file without password. This is currently the fastest Excel password remover which can help clear Excel password in seconds, but it only works for Excel xls file. Let’s go through the steps to quickly unlock password protected Excel xls file and then open the encrypted file without password.

1. Download Excel Password Eraser and then install it on your computer. It is a small program but works fast.

2. Once you finish installation, launch the software. Click “Open” button.

3. Select your password protected Excel file and then click "Open"..

4. Click “Remove Password” button, the program will clear the file’s password and decrypt the Excel workbook in seconds.

5. When the program prompts you that the file is decrypted successfully, click “Open” to open your Excel file without password.

Tip 2: Unlock Password Protected Excel xls/xlsx file with Excel Password Recovery – Recover the Original Password

If you want to unlock Excel 2016, 2013, 2010, 2007 file which is protected with unknown password or you forgot the password, you can use Excel Password Recovery to recover the original password in a fast way. This is one of the best Excel password recovery tools which can help unlock protected Excel xls and xlsx file easily via four powerful attack methods. Here I will show you how to use the software to unlock a password protected Excel 2016 file with normal attack type. More powerful attack methods you can try yourself.

1. Free download Excel Password Rescuer and then install it on your computer.

2. Run the software and add a protected Excel file you would like to unlock.

1) Click "Open" button (or select the "File - Open File" menu item).

2) Browse and navigate to your target file and then click “Open”.

3. Choose an attack type from pull-down list. There are four attack types available in the program to help you recover a long password in least time: Brute-force Attack, Mask Attack, Dictionary Attack and Smart Attack. Here I just to choose normal type.

4. Now click “Start” to quickly recover the Excel 2016 file’s password.

5. For a moment, the program will find out the original password for you. Once a dialog pops up, copy the password and then close the software.

6. Now you can open your password protected Excel file with the recovered password! Double click your Excel file, when it requires you to enter a password, paste your password in the box and click OK to open the Excel workbook.

Tip 3: Unlock Protected Excel Sheet and Locked Cells without Password.

In MS Office Excel 2007, 2010, 2013, 2016 and 2019, users are able to add a password to prevent unwanted changes from others by limiting their ability to edit. For example, you can prevent people from editing locked cells or making formatting changes. But how to unlock Excel sheets and cells if you forgot the password?

Case 1: Unlock Excel sheet and cells with password.

If you have the password, just to unlock the sheets and cells easily.

1. Open your Excel workbook whose sheet and cells are protected with a password, click “Review” from menu bar and select “Unprotect Sheet”.

2. When it requires you to provide a password, enter your password and click OK. If you don’t need to lock the sheet and cells, save your changes.

Case 2: Unlock Excel sheet and cells without password.

If you want to unlock protected Excel sheets and cells when you forgot the password, you can copy the content from the sheets and paste it to a new workbook. So you can edit all sheets and cells without password.

1. Open your Excel workbook whose sheet and cells are locked. Click on the top left corner to select all cells from sheet, right-click and select “Copy”.

2. Create a new blank Excel file, open it and paste the copied content on the new sheet. Save your new workbook. Now you can make changes to the sheet and cells in new Excel workbook without any password but not your old file.

Tip 4: Unlock Password Protected Excel Workbook without Password

In Office Excel 2007, 2010, 2013, 2016 and 2019, you can add a password to keep others from making structural changes to your workbook, such as moving, deleting or adding sheets. However, how to unlock the password protected Excel workbook when you lost the password? There are about two cases.

Case 1: Unlock Password Protected Excel Workbook with Password.

If you have password for the protected workbook or sheet, removing protection is a matter of seconds and then you can add, delete and move any workbook.

1. Open your Excel file whose workbook was protected with password, click "Review" menu and select "Protect Workbook".

2. When a password dialog appears, type in your password and click OK. All workbooks in the Excel file will be unprotected.

Case 2: Unlock Password Protected Excel Workbook without Password.

If you forgot the password to protected workbook, learn how to unlock all workbooks without password. It is easy.

1. Open your Excel workbook which you would like to unlock. Click on the top left corner to select all cells, right-click on the cells and select “Copy”.

2. Create a new blank Excel file, open it and paste the copied content on the new sheet. Save your new workbook. If the original Excel file contains more than one sheet, you will need to add more sheets in your new Excel workbook and then paste the copied contents to the new sheets as well.

Conclusion: If you can open a password protected Excel file, you will be able to unlock workbook, sheets and cells without password via copy the contents. If you forgot opening password to your Excel xls/xlsx file, you will need to use Excel Password Rescuer to recover the password firstly and then you can unlock the Excel file with recovered password. Or you can use Excel Password Eraser to clear Excel xls password in seconds and then you can open and edit your workbook.