确保文件安全是一个不错的步骤,但如果您忘记密码,您将丢失数据。我们都熟悉 excel 文件用于存储重要数据的频率。大多数人希望通过加密整个工作簿或 Excel 文件的特定工作表来保护他们的机密数据。不幸的是,如果您忘记了密码,您不必惊慌。您可以恢复您的文件。如果要从excel文件中删除密码怎么办?你能做到吗?是的,有一些方法可以让您轻松删除密码。您将无法恢复密码,但可以删除密码。
如何从Excel 文件中删除(Excel File)密码(Password)
方法一:删除 Excel 工作表密码(Remove Excel Worksheet Password)
在我们开始该过程之前,备份您的电子表格是安全的。然而,数据与过程无关,但仍采取预防措施是一个更好的主意。
首先将文件的扩展名(renaming the extension)从“.xlsx 重命名为 zip”
更改扩展名时,请确保您已打开查看部分下的文件扩展名选项,以防您看不到文件的文件扩展名。
步骤1:右键单击(Right-click)文件并选择重命名(rename)选项。出现提示时单击是。( yes)
第 2 步:现在您需要使用任何文件压缩器软件( file compressor software)提取 zip(extract the zip)文件数据。互联网上有各种软件,如 7 zip、WinRAR等。(WinRAR)
第三步:解压文件后,您需要找到(locate)“ xl ”文件夹。
第4步:现在找到“ Worksheets ”文件夹并单击它打开。
第 5 步:在Worksheet 文件夹(Worksheet folder)下,您将找到您的电子表格( spreadsheet)。用记事本 (Notepad. )打开电子表格。
第 6 步:如果您的电子表格下有一个工作表,您将更容易继续。但是,如果您保存了多个文件,则需要在记事本(Notepad)中打开每个文件并检查:
<sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>
注意:(Note:) “HashValue”和“salt value”在您的文件中会有所不同。
第 7 步:现在您需要删除从 < sheetprotection….to =1/ >开始的整行。( delete the entire line)
第 8 步:最后保存您的 .xml 文件。您需要对每个 .xml 文件执行第 4 步并保存所有文件。将这些文件添加回您的 zip 文件夹。为了重新添加修改后的 .xml 文件,您需要确保系统上打开了文件压缩软件程序。(file compression software program )现在您需要浏览您保存修改文件的位置,并使用文件压缩软件将其保存在 zip 文件夹中。
第 9 步:将文件扩展名从 zip(back to .xlsx from zip)重命名(Rename)为 .xlsx 。最后,您的所有文件都不受保护,您可以轻松打开它们。
另请阅读:(Also Read:) 什么是 XLSX 文件以及如何打开 XLSX 文件?(What is an XLSX file & How to open XLSX File?)
方法 2:手动删除 Excel 密码保护(Remove Excel Password Protection Manually)
如果您想手动删除 excel 密码保护,下面提到的这些步骤将对您有所帮助。
第 1 步:从所有(All)程序菜单中打开excel或在搜索框中键入Excel 。
第 2 步:单击文件(File)并导航到打开(Open)部分。点击密码保护excel文件(password protecting excel file)。
第三步:输入密码(password)并打开(open)文件。
第 4 步:单击“文件(File)”,然后单击“信息(Info)”,然后单击使用密码加密。(Encrypt with password.)
第 5 步:从框中删除密码并将框留空(Remove the password from the box and leave the box empty)。最后,点击保存。(save.)
方法 3:使用Excel Password Remover删除密码(Password)
网上也有一些 excel 密码删除程序。如果您想绕过上述取消保护您的excel文件的方法,您可以选择使用excel密码删除器删除密码的方法
https://www.straxx.com/
该网站为您提供了一个专业版和免费版的 excel 密码删除器选项。您将在本网站上获得有关其运作方式的完整信息。这是一个简单且用户友好的网站,可帮助您删除忘记的 Excel 文件密码。
方法 4:在保存Excel文件时删除密码(Password)
在此方法中,您将了解如何在使用“另存为”功能保存 Excel 文件时删除 Excel 密码。此方法仅在您已经知道 Excel 文件的密码并希望将其删除以供进一步使用时才有效。要删除,请按照以下步骤操作:
第 1 步:打开受密码保护的 Excel 文件(Open password-protected Excel file),并在提示时输入密码(Enter the password)。
第2步:单击左上角窗格中的“文件”选项卡,然后单击列表中的( “File”)“另存为”( “Save As” )选项。
第 3 步:将打开“另存为”(“Save As”)窗口。单击“工具”(“Tools”)下拉菜单,然后从列表中选择“常规选项” 。(“General options”)
第4步:在常规选项中,将“打开密码”和“修改密码”(leave the “password to open” and “password to modify”)字段留空(empty),然后单击“确定(OK )” ,您的密码将被删除。
现在您无需输入密码即可打开 excel 文件。
希望上述方法将帮助您从 Excel 文件和工作表中删除密码保护(remove password protection from your Excel file)。但是,请记住需要保护重要数据,因此请保护您的 Excel 文件密码。
How to Remove Password from Excel File
Keеping yоur files secure is a nice step but in case you forget the password, you will lose your data. We all are familiar with how frequеntly excel files are used to store important data. Most of the people wish to secure their confidentіal datа by encrypting either the entire workbook or a pаrticular sheet of the excеl file. Unfortunately, if you forget the password, you need not panic. You can recover your file. What if you want to remove the password from the excel file? Can you dо it? Yes, there are some methods through which you can easily remove the password. You would nоt be able to recover the password but can remove the password.
How to Remove Password from Excel File
Method 1: Remove Excel Worksheet Password
Before we start with the process, it would be safe to take a backup of your spreadsheet. However, data has nothing to do with the process but still taking a precautionary step would be a better idea.
Start with renaming the extension of your file from “.xlsx to zip”
While changing the extension make sure that you have turned on the file extension option under view section in case you are not able to see file extension of your files.
Step 1: Right-click on the file and select the rename option. Click on yes when prompted.
Step 2: Now you need to extract the zip files data by using any file compressor software. There are various software such as 7 zip, WinRAR, etc available on the internet.
Step 3: After the extraction of the files, you need to locate the “xl” folder.
Step 4: Now find out the “Worksheets” folder and click on it to open.
Step 5: Under the Worksheet folder, you will find out your spreadsheet. Open the spreadsheet with Notepad.
Step 6: If you have a single worksheet under your spreadsheet, it will be easier for you to go ahead. However, in case you have multiple files saved, you need to open every single file in Notepad and check for:
<sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>
Note: “HashValue” and “salt value” will be different on your file.
Step 7: Now you need to delete the entire line starting from <sheetprotection….to =1/>.
Step 8: Finally save your .xml file. You need to follow step 4 for every .xml file and save all of them. Add these files back to your zip folder. In order to add modified .xml files back, you need to ensure that you have a file compression software program open on the system. Now you need to browse back where you have saved your modified files and save it on the zip folder using the file compression software.
Step 9: Rename your file extension back to .xlsx from zip. Finally, all your files are unprotected and you can easily open them.
Also Read: What is an XLSX file & How to open XLSX File?
Method 2: Remove Excel Password Protection Manually
If you want to remove excel password protection manually, these below mentioned steps will help you.
Step 1: Open excel from All programs menu or type Excel in the search box.
Step 2: Click File and navigate to the Open section. Click on the password protecting excel file.
Step 3: Type the password and open the file.
Step 4: Click on the “File” then “Info” then Click on Encrypt with password.
Step 5: Remove the password from the box and leave the box empty. Finally, click on the save.
Method 3: Remove Password with Excel Password Remover
There are some excel password remove programs also available online. If you want to bypass the above-mentioned method of unprotecting your excel file, you can opt for the method to remove password with excel password remover
https://www.straxx.com/
This website gives you a pro and free version of the excel password remover option. You will get complete information about how it works on this website. It is a simple and user-friendly website that helps you to remove forgotten passwords of your excel file.
Method 4: Remove the Password while saving the Excel file
In this method, you will get to know how to remove excel password while saving your excel file with “save as” feature. This method will only work if you already know the password of your excel file and want to remove it for further use. To remove, follow the steps below:
Step 1: Open password-protected Excel file and Enter the password when prompt.
Step 2: Click the “File” tab in the top-left pane then click on the “Save As” option from the list.
Step 3: A “Save As” window will open. Click on the “Tools” drop-down then choose “General options” from the list.
Step 4: In the General Options, leave the “password to open” and “password to modify” field empty then click on OK and your password will be removed.
Now you will be able to open the excel file without entering the password.
Hopefully, the above-mentioned methods will help you to remove password protection from your Excel file as well as a worksheet. However, remember that important data needs to be secured, so keep your excel files password protected.