Shulou(Shulou.com)11/24 Report--

The Excel worksheet sets the protection password, which is forgotten over time. Do not remember the worksheet password can not be edited and copied and other operations, is there any way to crack it? Of course there is. Today, Mr. Wang is here to share a trick with everyone. Let's have a look.

Clear worksheet password 1, we first select the table, and then "right"-"rename", change the ".xlsx" table file suffix to ".zip" or ".rar" package suffix. This method is suitable for .xlsx suffix files.

2, double-click to open the zip file, enter the "xl" under the "worksheets", where you need to clear the password to find the worksheet, double-click to open, "open" set to "notepad".

3, use the shortcut key "Ctrl + F", open the search function, enter "protect" to find, delete protect in parentheses and all the contents in parentheses, and then save, OK.

Delete the following paragraph.

4. Rename the compressed package and change the suffix back.

Finally, we open the table to have a look, now the worksheet password has been cleared, we can change at will, there will be no pop-up window prompt.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.