处理敏感数据时,您可能会遇到受保护的 Excel 工作表(protected Excel sheets)。您可能还希望让其他人访问该信息,而不与他们共享您(或其他人)的密码。在这种情况下,您可以从受保护的Excel 工作(Excel)表或文件中删除密码,然后安全地与同事共享文档。
您可以使用以下几种不同的方法和工具从受保护的Excel 工作(Excel)表中删除密码。
如何检查 Excel 文件是否加密(How to Check if the Excel File Is Encrypted)
在尝试破解受密码保护的Excel文档之前,您需要确定整个文件是否已加密,或者它是否只是受保护的工作簿(a sheet within the workbook)中的一个工作表。
为此,请尝试打开您的Excel文件。如果您可以打开并查看该文件,但无法对其进行编辑,则意味着Excel工作簿中只有一个工作表受密码保护。如果您打开文件并收到要求您输入密码的弹出警告,则您的整个Excel文件已加密,您将无法轻松打开它。
如果您知道密码,如何解除对 Excel 工作表的保护(How to Unprotect an Excel Sheet if You Know the Password)
如果您记得Excel工作表或工作簿密码,只需将其删除即可取消对文档的保护。当您想与同事( share the file with a colleague)或朋友共享文件并需要他们进行编辑 时,这会派上用场。
在这种情况下,您无需破解密码或使用任何第三方工具来解除对文档的保护。您可以在Microsoft Excel(Microsoft Excel)中安全地删除它。要取消保护Excel 工作(Excel)表,请按照以下步骤操作。
- 打开受密码保护的Excel文档。如果您的Excel文件未加密,则无需输入密码即可打开和查看它。
- 在Excel 工作簿(Excel Workbook)底部找到需要取消保护的工作表。受密码保护的工作表旁边将有一个挂锁图标。
- 右键单击工作表并选择取消保护工作表(Unprotect Sheet)。
- 在弹出窗口中输入密码,然后选择Ok。
如果您看到工作表名称旁边的挂锁图标消失,那么您的工作表现在不受保护。如果工作簿中有许多受密码保护的工作表,则必须取消对每个工作表的保护。
使用第三方应用程序从 Excel 中删除密码(Remove Password from Excel Using a Third-Party App)
如果您忘记了密码并需要破解加密的Excel文件,则需要使用Microsoft Excel以外的工具。所有这些工具都需要您购买许可版本,因此从文件中删除密码将花费您。
现代版本的Excel使用高级加密方法,这使得您自己从文档中删除忘记的密码非常困难,而且通常不可能。因此,除非您的Excel文档在 2013 年之前被加密,否则您将不得不使用第三方应用程序来破解它。
密码 Excel 密钥(Passware Excel Key)
可以做到这一点的软件的一个很好的例子是Passware Excel Key。这是一个简单的Excel密码删除工具,支持所有版本的Excel。这意味着您可以使用它来破解任何Excel文件,即使您不知道它何时被加密。在购买许可证之前,您还可以下载演示版并进行测试。然而,演示版只能恢复您密码的前 3 个字符。
要使用Passware Excel Key(Passware Excel Key)破解受密码保护的Excel文件,您只需在计算机上安装Passware Excel Key应用程序,然后使用它打开您的Excel文件。根据密码的复杂程度,恢复过程可能会在几分钟内完成。
根据密码“password”测试该工具时,恢复时间不到 15 分钟。但是,请记住,如果您使用包含字母、数字和符号的密码,恢复过程可能需要数小时。
Passware Excel Key的一项有用功能是该软件还支持多语言密码。基本套件许可证起价为 49 美元,并提供 30 天退款保证。您也可以先下载一个演示版,看看该工具是如何工作的。
iSeePassword Excel 密码恢复(iSeePassword Excel Password Recovery)
我们要推荐的另一个工具是iSeePassword Excel 密码恢复(iSeePassword Excel Password Recovery)工具,也称为Dr Excel。下面介绍如何使用Dr Excel从(Dr Excel)Excel文件中删除密码。
- 在您的计算机上下载并安装Dr Excel 。
- 打开 Dr Excel 并选择Recover Open Password from Excel或Remove Workbook, Worksheet Password。
- 在Step 1下,选择Add File并选择您的 Excel 文件。
- 在Step 2下,选择您想用来破解密码的攻击类型:Dictionary Attack (如果您记得您使用过简单的纯字母密码),Brute-Force with Mask Attack(如果您想更快地删除密码),或者蛮力,(Brute-Force)如果你记得这是一个困难的密码。
- 选择开始(Start)。
如果您使用的是少于 6 个字符的简单密码,您应该能够在一小时内破解它。但是,如果您使用了包含字母、数字和符号的更复杂的密码,则删除它需要几个小时。
Excel 博士(Dr Excel)许可证终身使用的费用为 29.95 美元。您也可以在购买前使用试用版来测试软件。
如何从 Excel Online 中删除密码 (How to Remove Password from Excel Online )
如果您不想安装新软件或没有时间,您可以使用在线提供的密码删除工具之一,例如Password-Find。要使用Password-Find从(Password-Find)Excel文件中删除密码,请按照以下步骤操作。
- 打开密码查找网站。
- 选择取消保护您的文件(Unprotect Your File)。
- 选择浏览(Browse)以上传您的Excel文档。然后向下滚动并选择Next Step。
- 选择删除密码(Remove password)或查找密码(Find password),然后选择下一步(Next Step)进行确认。
Password-Find的一大优势是它能够以多快的速度破解Excel文件的密码。当使用简单的密码“password”对其进行测试时,它会在几秒钟内被删除,甚至不是您可以从类似工具中获得的几分钟或几小时。包含字母、数字和符号的更难的密码仍然只需要不到 2 分钟的时间就可以删除。
删除密码后,您可以查看未受保护的Excel文件的演示版本。要完全访问您的文件并下载它以供将来使用,您必须购买价格为 13 美元的密码查找产品许可证。
您可以使用的其他方法(Other Methods You Can Use)
如果您不想花钱破解您的Excel文档,或者您使用的方法失败了,您可以尝试其他技术从 Excel 中删除密码(remove a password from Excel)。请记住(Bear),与使用密码删除工具相比,它们更耗时且对初学者不太友好。
您是否曾经不得不从Excel文件中删除密码?你是用什么(Which)方法来做的?在下面的评论部分 分享您破解Excel文档的经验。(Excel)
How to Remove Password From Excel Protected Sheets
When you work with sensitive data, you might run across protected Excel sheets. You might also want to give other people access to that information, without sharing your (or someone else’s) passcodes with them. In that case, you can remove a password from a protected Excel sheet or file and then safely share the document with your colleagues.
Here are a few different methods and tools that you can use to remove a password from a protected Excel sheet.
How to Check if the Excel File Is Encrypted
Before you try to crack a password-protected Excel document, you need to find out whether the entire file is encrypted, or if it’s only a sheet within the workbook that’s protected.
To do that, try to open your Excel file. If you can open and view the file, but can’t edit it, that means that only one worksheet in the Excel workbook is password-protected. If you open the file and get a pop-up warning asking you to enter a password, then your entire Excel file is encrypted and you won’t be able to open it as easily.
How to Unprotect an Excel Sheet if You Know the Password
If you remember your Excel sheet or workbook password, you simply need to remove it to unprotect your document. That can come in handy when you want to share the file with a colleague or a friend and need them to make edits as well.
In that case, you don’t need to break your password or use any third-party tools to unprotect your document. You can safely remove it within Microsoft Excel. To unprotect an Excel sheet, follow the steps below.
- Open the password-protected Excel document. If your Excel file isn’t encrypted, you’ll be able to open and view it without having to enter the password.
- Find the sheet that you need to unprotect at the bottom of your Excel Workbook. The password-protected sheet will have a padlock icon next to it.
- Right-click the sheet and select Unprotect Sheet.
- Type the password into the pop-up window and select Ok.
If you see the padlock icon next to the sheet’s name disappear, then your sheet is now unprotected. If you have many password-protected sheets within the workbook, you’ll have to unprotect each of them.
Remove Password from Excel Using a Third-Party App
If you misplaced your password and need to crack an encrypted Excel file, you’ll need to use tools other than Microsoft Excel. All those tools need you to buy a licensed version, so removing a password from your file will cost you.
Modern versions of Excel use advanced encryption methods which make it extremely difficult and often impossible to remove a forgotten password from your document by yourself. So unless your Excel document was encrypted prior to 2013, you’ll have to use a third-party app to crack it.
Passware Excel Key
A good example of software that can do this is Passware Excel Key. It’s a simple Excel password remover tool that supports all versions of Excel. Meaning you can use it to crack any Excel file, even if you don’t know when it was encrypted. Before buying the license, you can also download a demo version and test it. The demo version however will only recover the first 3 characters of your password.
To crack a password-protected Excel file using Passware Excel Key, all you have to do is install the Passware Excel Key app on your computer, and then use it to open your Excel file. Depending on the complexity of the password, the recovery process might be finished within a few minutes.
When testing the tool against the passcode “password”, the recovery took just under 15 minutes. However, keep in mind that if you use a harder password that contains both letters, numbers, and symbols, the recovery process could take hours.
One useful feature of Passware Excel Key is that the software supports multilingual passwords as well. The basic kit license starts at $49 and comes with a 30-day money back guarantee. You can also download a demo version to see how the tool works first.
iSeePassword Excel Password Recovery
One more tool we’re going to recommend is the iSeePassword Excel Password Recovery tool that’s also called Dr Excel. Here’s how to remove a password from an Excel file using Dr Excel.
- Download and install Dr Excel on your computer.
- Open Dr Excel and select to either Recover Open Password from Excel or Remove Workbook, Worksheet Password.
- Under Step 1, select Add File and choose your Excel file.
- Under Step 2, select the type of attack that you want to use to crack the password: Dictionary Attack if you remember that you used an easy letter-only password, Brute-Force with Mask Attack if you want to remove the password quicker, or Brute-Force if you remember that it’s a difficult password.
- Select Start.
If you’ve used an easy password that’s under 6 characters, you should be able to crack it within an hour. However, if you’ve used a more complex passcode that contains letters, numbers, and symbols, removing it will take several hours.
Dr Excel license costs $29.95 for lifetime use. You can also use the trial version to test the software before buying it.
How to Remove Password from Excel Online
If you don’t want to install new software or don’t have time for it, you can use one of the password removal tools available online, like Password-Find. To remove a password from your Excel file using Password-Find, follow the steps below.
- Open the Password-Find website.
- Select Unprotect Your File.
- Select Browse to upload your Excel document. Then scroll down and select Next Step.
- Select to either Remove password or Find password, then select Next Step to confirm.
One advantage of Password-Find is how quickly it’ll crack your Excel file’s password. When testing it with the easy passcode “password”, it was removed within seconds, not even minutes or hours that you can expect from similar tools. The harder passcode that contains letters, numbers, and symbols still only took under 2 minutes to remove.
After your password is removed, you can check the demo version of your unprotected Excel file. To access your file fully and to download it for future use you’ll have to buy a Password-Find product license that costs $13.
Other Methods You Can Use
If you don’t want to spend money on cracking your Excel document, or if the methods you used failed, you can try other techniques to remove a password from Excel. Bear in mind that they are much more time consuming and less beginner-friendly than using a password removal tool.
Have you ever had to remove a password from an Excel file? Which method did you use to do it? Share your experience with cracking Excel documents in the comments section below.