The Excel worksheet is protected by a password, but over time the password is forgotten. If you don’t remember the worksheet password, you cannot perform operations such as editing and copying. Is there any way to crack it? Of course there is. Today, Teacher Xiao Wang is here to share a trick with everyone, let’s take a look!
1. We first select the table, then "right-click" - "Rename" and change the ".xlsx" table file suffix to ".zip" or ".rar" "Compressed package suffix. (This method applies to .xlsx suffix files).
2. Double-click to open the compressed package file, enter "worksheets" under "xl", find the worksheet you need to clear the password here, double-click to open, and set "Open with" to "Notepad".
3. Use the shortcut key "Ctrl + F" to open the search function, enter "protect" to search, delete the brackets where protect is located and all the content in the brackets, then save and confirm.
Delete the following paragraph.
4. Rename the compressed package and change the suffix back.
5. Finally, we open the form and take a look. Now the worksheet password has been cleared by us. We can change it at will and there will be no pop-up prompts.
This article comes from WeChat public account: Word Technology Alliance (ID: Wordlm123), author: Wang Wangqi
The above is the detailed content of I forgot my Excel worksheet password, here's a trick to crack it easily. For more information, please follow other related articles on the PHP Chinese website!