In this Tutorial, I will show you How To Unlock an Excel Sheet Without Password. This will work on all Excel versions (2016, 2013, 2010,...).
In case of a password protected worksheet you are unable to edit the data on it. If you have ever forgotten or you don't know the password to unlock this file, you are just in the right place.
So how do you unprotect an Excel file when you don't have the password? Here is a simple and effective solution:
How To Unprotect an Excel Spreadsheet Without Password.
What you will need:
To unlock an Excel file without password, just follow these steps:
- Make sure the Excel file is closed then change the file name extension from .xlsx to .zip. Then click "Yes".
- Open the .zip file with 7-zip then go to folder xl-> worksheets.
- Open sheet1.xml with Wordpad or NotePad.
- Press Ctrl + F, and search for "sheetprotection".
- Delete the entire element that starts from "<sheetProtection" to "/>".
- Save the modification and close the file. and Click "Ok" when prompted with a warning dialog.
- Change back the .zip to .xlsx.
- Now your Excel file is UNLOCKED, you can open your file and make any modification without any password.