您是否想要对Excel(Excel)工作簿或工作表进行更改，但发现它们已被锁定或受保护？如果是这样，您可能需要先取消对它们的保护。这将允许您编辑电子表格的内容、结构和格式。
但是如何取消对Excel工作表或工作簿的保护呢？如果您不知道密码会怎样？如果您不确定如何继续解锁受保护Excel文件中的数据，请按照以下步骤操作。
在Excel中取消工作簿(Workbook)保护与取消工作表保护(Worksheet)
在开始之前，我们先澄清一下取消保护工作簿和取消保护工作表之间的区别。工作簿用于描述整个Excel文件。然而，工作表用于描述Excel电子表格中的各个工作表，即您将在窗口底部看到的数据选项卡。
取消保护工作簿意味着您可以对整个工作簿进行结构更改，例如添加、删除、隐藏或重命名工作表。您还可以通过取消保护来
更改Excel电子表格中的工作簿属性和设置。
相反，取消保护工作表意味着您可以修改工作表的数据和格式，例如更改单元格的内容、插入或删除行和列、应用或删除筛选器等。其他工作表可能仍然受到保护。
可用的保护类型存在差异。对Excel(Excel)文件进行加密可防止任何人在不知道密码的情况下查看该文件。如果您只是保护工作簿或工作表，您仍然可以读取数据并打开文件，但您可能需要其他密码才能进行更改或删除该保护。
如何删除Excel 文件加密(Excel File Encryption)
取消对Excel(Excel)工作表或工作簿的保护的第一个障碍是删除文件的加密。加密可防止您在不知道加密密码的情况下
打开现代Excel文件。(Excel)
为此，您需要拥有用于加密文件的工作簿的密码。如果没有，您需要尝试使用第三方 Excel 密码删除工具(try a third-party Excel password removal tool)来解锁您的文件。在尝试此操作之前，请(Make)务必备份您的文件。
要删除Excel文件加密，请按照下列步骤操作。
- 打开加密的Excel工作簿。出现提示时，输入正确的密码。
- 接下来，按“文件”>“信息”。
- 选择“保护工作簿”图标。
- 从下拉菜单中，选择使用密码加密(Encrypt)选项。
- 在“加密文档”(Encrypt Document)弹出框中，删除现有密码，然后按“确定”。
- 如果密码被接受，请按“保存”(Save)以保存不带密码的文件。
删除文件加密后，您应该能够从“数据”(Data)菜单解锁工作簿或单个工作表。
如何取消对 Excel 工作簿的保护
Excel工作簿可以使用或不使用密码保护进行保护。如果要取消对Excel工作簿的保护，请按照以下步骤操作。
- 使用Microsoft Excel(Microsoft Excel)打开要取消保护的工作簿。
- 在“审阅”(Review)选项卡中，按“保护”(Protect)部分中的“保护工作簿”(Protect Workbook)以更改其状态。如果工作簿当前受保护，该图标将显示为活动状态，并带有灰色背景和边框。
- 如果工作簿没有密码，按“保护工作簿”(Protect Workbook)按钮将立即更改其状态 - 图标的状态将更改以匹配功能区栏上的其他图标。
- 如果工作簿受密码保护，您将看到一个弹出框，要求您输入工作簿密码。输入它并单击“确定”将其删除，然后再次输入它进行确认。这将允许您对工作簿进行结构更改。
与加密的Excel文件一样，如果您不知道密码，则必须使用第三方密码恢复工具(use a third-party password recovery tool)来解锁受密码保护的Excel电子表格文件。如果您打算这样做，请确保先保存文件的副本，以防止潜在的数据丢失或损坏。
如何取消对Excel 工作表的保护(Excel Worksheet)
您还可以保护单个Excel工作表不被创建、编辑或删除。这包括使用或不使用密码保护它们的能力。
最好在不受保护的工作簿中进行这些更改。否则，您可能会发现很难解锁某些功能（例如添加或删除工作表的能力）。但是，即使在锁定的工作簿中，您仍然可以删除工作表保护，但前提是XLSX文件未加密。
如果要取消对Excel工作表的保护，请按照以下步骤操作。
- 打开包含要解锁的工作表的工作簿。
- 在“审阅”(Review)选项卡中，按“保护”(Protect)部分中的“取消保护工作表”(Unprotect Sheet)按钮。
- 如果工作表没有密码，取消保护工作表(Unprotect Sheet)图标将立即将其名称更改为保护工作表(Protect Sheet)。这证实了该工作表不受保护。
- 如果工作表受密码保护，系统将提示您插入工作表密码。如果您知道密码，请输入该密码并按“确定”。如果被接受，工作表将不受保护，您可以开始修改它。
与其他方法一样，在不知道密码的情况下解锁工作表是很棘手的。您需要尝试从其他人那里获取密码，或者使用Passware Excel key(Passware Excel key)等第三方工具来为您删除密码。
保护您的 Excel 数据
取消保护Excel工作表或工作簿将允许您对电子表格进行更改。只要你有密码，过程就很简单。如果没有它，您将需要尝试使用第三方工具来删除密码，除非您可以从原始文件所有者或创建者处获取密码。
正在寻找更简单的方法来锁定某些Excel工作表？您可以锁定 Excel 中的单元格(lock cells in Excel)，以使其他人更难更改某些单元格区域。您还可以尝试将 Excel 文件共享(sharing an Excel file)为只读，以限制不必要的更改。
How to Unprotect an Excel Worksheet or Workbook (With or Without Password)
Do you want to make changеs to your Excel workboоk or worksheet, but find that they’re locked or protected? Іf so, you might need to unprotect them first. This will allow you to edit the content, structure, and formatting of your spreadsheet.
But how do you unprotect an Excel worksheet or workbook? And what happens if you don’t know the password? If you’re unsure how to proceed with unlocking your data in a protected Excel file, follow the steps below.
Unprotecting a Workbook vs. Unprotecting a Worksheet in Excel
Before we start, let’s clarify the difference between unprotecting a workbook and unprotecting a worksheet. A workbook is used to describe an entire Excel file. A worksheet, however, is used to describe the individual sheets in your Excel spreadsheet—the tabs of data you’ll see at the bottom of the window.
Unprotecting a workbook means that you can make structural changes to the workbook as a whole, such as adding, deleting, hiding, or renaming worksheets. You can also change the workbook properties and settings in your Excel spreadsheet by removing the protection from it.
In contrast, unprotecting a worksheet means that you can modify the data and formatting of the worksheet, such as changing the content of a cell, inserting or deleting rows and columns, applying or removing filters, and so on. Other worksheets might remain protected.
There are differences in the type of protection available. Encrypting an Excel file prevents anyone from viewing it without knowing the password. If you simply protect the workbook or worksheets, you’ll still be able to read the data and open the file, but you may need additional passwords to make changes or remove that protection.
How to Remove Excel File Encryption
The first barrier to unprotecting an Excel worksheet or workbook is to remove encryption from the file. Encryption prevents you from opening modern Excel files without first knowing the encryption password.
To do this, you’ll need to have the password for the workbook that was used to encrypt the file. If you don’t have it, you’ll need to try a third-party Excel password removal tool to unlock your file. Make sure to back up your file before you try this.
To remove Excel file encryption, follow these steps.
- Open your encrypted Excel workbook. When prompted, insert the correct password.
- Next, press File > Info.
- Select the Protect Workbook icon.
- From the drop-down menu, select the Encrypt with password option.
- In the Encrypt Document pop-up box, remove the existing password and press OK.
- If the password was accepted, press Save to save the file without the password.
Once you’ve removed file encryption, you should be able to unlock the workbook or individual sheets from the Data menu.
How to Unprotect an Excel Workbook
An Excel workbook can be protected with or without password protection. If you want to unprotect an Excel workbook, follow these steps.
- Open the workbook that you want to unprotect with Microsoft Excel.
- In the Review tab, press Protect Workbook in the Protect section to change its status. If the workbook is currently protected, the icon will appear in an active state with a gray background and border.
- If the workbook doesn’t have a password, pressing the Protect Workbook button will change its status immediately—the icon’s status will change to match other icons on the ribbon bar.
- If the workbook is protected with a password, you’ll see a pop-up box asking you to enter the workbook password. Type it in and click OK to remove it, then type it in again to confirm. This will allow you to make structural changes to the workbook.
As with encrypted Excel files, if you don’t know the password, you’ll have to use a third-party password recovery tool to unlock a password-protected Excel spreadsheet file. If you plan on doing this, make sure you save a copy of your file first, just to protect yourself from potential data loss or corruption.
How to Unprotect an Excel Worksheet
You can also protect individual Excel worksheets from being created, edited, or deleted. This includes the ability to protect them with or without passwords.
It’s best to make these changes in an unprotected workbook. Otherwise, you may find it difficult to unlock certain functionality (such as the ability to add or delete worksheets). However, even in a locked workbook, you may still be able to remove sheet protection, but only if the XLSX file isn’t encrypted.
If you want to unprotect an Excel worksheet, follow these steps.
- Open the workbook that contains the worksheet that you want to unlock.
- From the Review tab, press the Unprotect Sheet button in the Protect section.
- If the worksheet doesn’t have a password, the Unprotect Sheet icon will immediately change its name to Protect Sheet. This confirms that the sheet is unprotected.
- If the worksheet is protected with a password, you’ll be prompted to insert the worksheet password. If you know the password, type it and press OK. If it’s accepted, the worksheet will be unprotected and you can begin to modify it.
As with other methods, unlocking the sheet without knowing the password is tricky. You’ll need to try and source the password from somebody else or use a third-party tool like Passware Excel key to remove it for you.
Protecting Your Excel Data
Unprotecting an Excel worksheet or workbook will allow you to make changes to your spreadsheet. As long as you have the password, the process is simple. Without it, you’ll need to try a third-party tool to remove the password instead, unless you can source it from the original file owner or creator.
Looking for easier ways to lock down some of your Excel worksheets? You can lock cells in Excel to make it harder for others to make changes to certain cell ranges. You could also try sharing an Excel file as read-only to limit unnecessary changes.
