I forgot my Excel worksheet password, here's a trick to crack it easily

PHPz
Release: 2024-07-17 07:34:12
Original
550 people have browsed it

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!

Excel 工作表密码忘了,教你一招,轻松破解

Clear worksheet password

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).

Excel 工作表密码忘了,教你一招,轻松破解

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".

Excel 工作表密码忘了,教你一招,轻松破解

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.

Excel 工作表密码忘了,教你一招,轻松破解

Delete the following paragraph.

Excel 工作表密码忘了,教你一招,轻松破解

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

Excel 工作表密码忘了,教你一招,轻松破解

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.

Excel 工作表密码忘了,教你一招,轻松破解

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!

Related labels:
source:ithome.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template