Articles Office 2 Ways to Unprotect Excel Sheet 2016/2019 without Password

2 Ways to Unprotect Excel Sheet 2016/2019 without Password

Updated: By Yvonne Keller

To protect the data on your Excel sheet 2016/2019 from editing by other users, you can protect it by this way:

Open the Excel file and the sheet you want to protect, click on Review and then click on Protect Sheet. Type in password and check the box to allow all users of this worksheet to do, and then click on OK.

protect sheet

You can unprotect it by this way if you still remember the protected password:

Open the Excel file and the sheet you want to unprotect, click on Review, and then click on Unprotect Sheet. Type in the protection password, and then click on OK.

However, if you forgot Excel spreadsheet 2016/2019 protection password, how to unprotect Excel sheet 2016/2019 without password? Following this article will show you 2 ways.

2 ways to unprotect Excel sheet 2016/2019 without password:
Way 1: Unprotect Excel spreadsheet from Zip file
Way 2: Unprotect Excel sheet by removing password

Unprotect Excel spreadsheet from Zip file

Video guide to unprotect Excel spreadsheet from zip file without password:

1. Change Excel file name extension. Right-click on the Excel file, select "Rename".

rename file

2. Change Excel file name extension from (*.xlsx) to (*.zip).

change file name extension

3. Right-click on the zip file, point to 7-zip, click on "Open archive".

open archive

4. Click on the file named xl, and then click on the file named worksheets.

click on xl file

5. Right-click on the sheet that you want to unprotect, and then select "Edit".

select edit

6. Find the line of codes as picture below, and remove them.

remove codes

7. Click on "File", and click on "Save" to save it, and then exit this file.

save file

8. Right-click on the zip file, click on "Rename". And then change the file name extension from (*.zip) to (*.xlsx).

9. Open the Excel file, you will find the protected sheet is editable.

Unprotect Excel sheet by removing password

1. Download software and install it on your PC device.

Cocosenor Workbook Unprotect Tuner can help to remove Excel workbook and spreadsheet password instantly just with one click. You can get the free trial version to install on your computer and have a try.

free trial

2. Once you have installed the Workbook Unprotect Tuner program on your PC, launch it, click on "Open" button, and then find the Excel file to add it into program.

import excel file

3. Click on "Remove Password" button.

remove password

4. In a few seconds, a message box will pop up. If it was saying: "Sheet protection password: removed", that meets the protected sheet is unprotected. Go to the location of this Excel file, you will find another Excel file with the same name and marked as unprotected.

sheet protection password removed

Tips: Workbook Unprotect Tuner free trial version only tests password from your Excel sheet, won't remove password from the sheet. Just get the full version to help you unprotect your Excel sheet instantly.

Related Articles