00:00If your Excel file is locked with a password and you've forgotten it, don't worry.
00:05In this video, I'll show you a simple trick to unlock a pretty
00:10protected Excel sheet without needing the password.
00:13In my case, the problem is
00:15only with the first sheet named orders, while the other sheets are not password protected.
00:20So make sure you watch till the end to see exactly how I unlock it.
00:24First, make sure to open it to the end.
00:25Make sure the Excel file is completely closed.
00:28Go ahead and locate the file on your computer.
00:30We're going to change the file extension, so if you don't see .xlsx
00:35at the end of the file name, you'll need to enable file name extensions from the view menu at the top.
00:40If you're not sure how to do that, I've left another video explaining it in the pinned comment.
00:45Once you can see the extension, right-click the file and rename it.
00:50Remove .xlsx and change it to .zip.
00:55Now press enter or click with mouse.
00:58When Windows shows a warning message
01:00just click yes.
01:01This doesn't damage the file, it simply turns the Excel file.
01:05Now open the .zip file into a compressed folder.
01:07Now open the .zip file.
01:09Now open the .zip file.
01:10Inside, go to the Excel folder and then open worksheets.
01:14Here, you'll see .
01:15you'll see several .xml files and each one represents a sheet in your Excel file.
01:20Since my password is on the first sheet, I'll copy that file to my desktop.
01:25Next, right-click the copied file, choose Open With and open it using Notebook.
01:30.zip .zip.
01:31Now go to checking .zip file.
01:32Of.
01:33Zusch spannend save to mute and practice it in thealaidission file
01:35.zip file.
01:36See the link with the nữa, add a clip link and keyboard.
01:38Now the zip file, currently have the first to be churches.
01:39Otherwise, you'll see the metal castle.
01:40Today, our YouTube channel screen, please mute the check-ups that connect to the dashboard.
01:41This is connected in the corner as it is put in the demo and can be turned away.
01:42If you will find, it's a��smart opportunity for an attorney-related home, it will continue to make the
01:56dinner rag't go to sleep to sleep or and the retroatson country and view it.
01:58You'll see it and it will be done later.
01:59Simply delete everything between the angle brackets, the part that starts with this and ends with this.
02:04Click on the button, click on the button, click on the button, and click on the button.
02:30Once that's done, go back to the main folder.
02:35And rename the file again.
02:40Changing .zip back to .xlsx.
02:45Now press enter or click with mouse.
02:50Confirm the warning message by clicking yes.
02:53Now let's open the Excel.
02:55File again.
02:56As you can see, I can type in the cells without any problem.
03:00The sheet protection is completely removed and I can even set a new password.
03:06That's all for this video.
03:09I hope this was helpful.
03:10And thanks for watching.
Comments