Create a new Excel Worksheet
Input some data on worksheet cells
Now, Password Protect the Sheet...
Enter your desired password to "Lock" the Excel worksheet
Re-enter the same password
The excel sheet shown is now fully "password protected"
Close the sheer and go back to the Excel file
Right-Click on the excel file...
...Rename its Extension from ".xlsx" to ".zip"
open the zip file and locate sheet as shown...
Extract this ".xml" file from the zip folder
Now open this xml file with WordPad
here is some code, don't be afraid of this
press Ctrl+f and find keyword "Protection"
Select this protection code in-between "<.../>" as shown in video
Remove this selected code from the file
...Save and close...
Now replace this "edited" xml file with the original one in "zip" folder
Rename back "Farhan.zip" to "Farhan.xlsx"
now the excel worksheet is fully unlocked for editing
Don't forget to say "awesome" in comments :)
Thanks for watching
Feel free to ask any question in comments :)