有时您不希望更改 Excel 工作表中的某些单元格。您可以通过学习如何在 Excel 中锁定或解锁单元格来做到这一点。 ^{(Sometimes you don’t want some cells in your excel sheets to be altered. You can do so by learning how to lock or unlock cells in excel. )}

Microsoft Excel为我们提供了一种以表格和有组织的形式存储数据的绝佳方式。但是，当与其他人共享时，这些数据可能会被更改。如果您想保护您的数据免遭故意更改，则可以通过锁定Excel工作表来保护它们。^(Excel)但是，这是一个极端的步骤，可能并不可取。相反，您也可以锁定特定的单元格、行和列。例如，您可以允许用户输入特定数据，但用重要信息锁定单元格。在本文中，我们将看到^{(In this article, we’ll see different ways to )}在 Excel 中锁定或解锁单元格的不同方法。^{(lock or unlock cells in Excel.)}

如何在Excel 中锁定^(Excel)或解锁单元格^{(Or Unlock Cells)}？

您可以锁定整个工作表，也可以根据您的选择仅选择单个单元格。

Excel如何锁定所有单元格？^{(How to Lock All Cells in Excel?)}

要保护Microsoft Excel中的所有单元格，您只需保护整个工作表。默认情况下，工作表中的所有单元格都将受到保护，不会被覆盖或编辑。

1.从屏幕底部的“工作表选项卡”中选择“^{(Worksheet Tab)}保护^{(Protect Sheet)}工作表”，或直接从更改组中的“^{(Changes group)}审阅选项卡^{(Review Tab)}”中选择。

2. 出现“保护工作表^{(Protect Sheet)}”对话框。您可以选择使用密码保护您的 Excel 工作表，也可以将“密码保护您的 Excel 工作表^{(password protect your excel sheet)}”字段留空。 

3.从列表中选择您希望在受保护工作表中允许的操作，然后单击“确定”。^{(Choose the actions from the list that you want to allow in your protected sheet and click on ‘OK.’)}

4. 如果选择输入密码，会出现“确认密码^{(confirm password)}”对话框。再次输入您的密码以完成该过程。^{(Type your password again to finish the process.)}

另请阅读：^{(Also read:)} 如何从 Excel 文件中删除密码^{(How to Remove Password from Excel File)}

如何锁定和保护 Excel 中的单个单元格？^{(How to Lock and Protect Individual Cells in Excel?)}

您可以按照以下步骤锁定单个单元格或一系列单元格：

1. 选择要保护的单元格或范围。您可以使用鼠标或使用关键字上的 shift 和箭头键来完成。使用Ctrl 键和鼠标^{(Ctrl key and mouse)}选择不相邻的单元格和范围^{(non-adjacent cells and ranges)}。

2. 如果要锁定整列和整行，可以通过单击它们的列或行字母来选择它们。您还可以通过右键单击鼠标或使用 shift 键和鼠标来选择多个相邻的列。

3. 您也可以只选择带有公式的单元格。在主页^(Home)选项卡中，单击编辑组^{(Editing group)}，然后单击“查找并选择^{(Find and Select)}”。单击转到特别^{(Go to Special)}。

4. 在对话框中，选择公式^(Formulas)选项并单击确定^(OK)。

5. 选择要锁定的所需单元格后，同时按Ctrl + 1。将出现“格式化单元格^{(Format Cells)}”对话框。您也可以右键单击选定的单元格并选择“设置单元格格式”选项^{( You can also right-click on the selected cells and choose the Format cells option)}以打开对话框。

6. 转到“保护^(Protection)”选项卡并选中“锁定^(locked)”选项。单击OK，您的工作就完成了。

注意：^(Note:) 如果您尝试锁定以前受保护的Excel工作表上的单元格，则需要先解锁工作表，然后执行上述过程。您 ^(You )可以在 2007、2010、2013 和 2016 版本的 Excel 中锁定或解锁单元格。^{(can lock or unlock cells in Excel in 2007, 2010, 2013, and 2016 versions.)}

如何解锁和取消保护 Excel 工作表中的单元格？^{(How to Unlock and Unprotect Cells in Excel Sheet?)}

您可以直接解锁整个工作表以解锁Excel中的所有单元格。

1. 单击更改组^{(changes group)}中“审阅选项卡^{(Review tab)}”上的“取消保护工作表^{(Unprotect Sheet)}”，或通过右键单击工作表^(Sheet)选项卡单击选项。

2. 您现在可以对单元格中的数据进行任何更改。

3. 您还可以使用“设置单元格格式”^{(Format Cells’)}对话框解锁工作表。

4. 按Ctrl + A选择工作表中的所有单元格。然后按Ctrl + 1或右键单击并选择Format Cells。在“设置单元格格式”对话框的“^{(Format Cells)}保护^(Protection)”选项卡中，取消选中“锁定^(Locked)”选项，然后单击“确定^(OK)” 。

另请阅读：^{(Also Read:)} 修复 Excel 正在等待另一个应用程序完成 OLE 操作^{(Fix Excel is waiting for another application to complete an OLE action)}

如何解锁受保护表中的特定单元格？^{(How to Unlock Particular Cells in a Protected Sheet?)}

有时您可能想要编辑受保护的Excel工作表中的特定单元格。通过使用此方法，您可以使用密码解锁工作表上的单个单元格：

1.在受保护的工作表中选择需要通过密码解锁的单元格或范围。

2. 在“查看^(Review)”选项卡中，单击“允许用户编辑范围^{(Allow users to edit Ranges)}”选项。您需要先解锁工作表才能访问该选项。^{( You need to unlock your sheet first to access the option.)}

3. 出现“允许^(Allow)用户编辑范围”对话框。单击^(Click)“新建^(New)”选项。 

4. 出现一个“新范围^{(New Range)}”对话框，其中包含标题、引用单元格^{( Title, Refers to cells, )}和范围密码^{( Range password )}字段。

5. 在标题字段中，为您的范围命名^{(give a name to your range)}。在“引用单元格^{(Refers to cell)}”字段中，键入单元格范围。默认情况下，它已经具有选定的单元格范围。

6.在密码字段中输入^(Password)密码^(password)，然后单击确定^(OK)。

7. 在“确认密码^{(confirm password)}”对话框中再次输入密码，然后单击“确定^(OK)” 。 

8.将增加一个新的范围^{(A new range will be added)}。您可以再次按照这些步骤创建更多范围。

9. 单击“保护工作表^{(Protect Sheet)}”按钮。

10.在整个工作表的“保护工作表”窗口中输入密码，然后^{( Type a password)}选择^{(choose the actions)}您要允许的操作。单击确定^(OK)。

11.在确认窗口中再次输入密码，您的工作就完成了。  ^{(Type the password again in the confirmation window, and your work is done.  )}

现在，即使您的工作表受到保护，一些受保护的单元格将具有额外的保护级别，并且只能使用密码解锁。您还可以授予对范围的访问权限，而无需每次都输入密码：

1. 当您创建范围时，首先单击“权限^{(Permissions)}”选项。

2. 单击窗口中的添加按钮^{(Add button)}。在“输入要选择的对象名称^{(Enter the object names to select)}”框中输入用户的名称。您可以键入存储在您的域中的人的用户名^{(You can type the user name of the person as stored in your domain)}。单击确定^(OK)。

3. 现在在“组或用户名^{(Group or user names)}”下为每个用户指定权限并选中“允许^(Allow)”选项。单击^(Click)OK，您的工作就完成了。

受到推崇的：^{(Recommended:)}

• 如何在 Excel 中交换列或行^{(How to Swap Columns or Rows in Excel)}
• 如何将 Excel (.xls) 文件转换为 vCard (.vcf) 文件？^{(How to convert Excel (.xls) file to vCard (.vcf) file?)}
• 在 Excel 中的工作表之间快速切换^{(Quickly Switch Between Worksheets in Excel)}
• 如何修复图库中未显示的 Whatsapp 图像^{(How to Fix Whatsapp Images Not Showing In Gallery)}

这些都是您可以在 Excel 中锁定或解锁单元格的所有不同方式。^{( lock or unlock cells in Excel.)}知道如何保护您的工作表对于保护它免受意外更改是非常必要的。您可以一次保护或取消保护Excel工作表中的单元格，也可以选择特定范围。您还可以授予某些用户使用或不使用密码的访问权限。仔细按照上面的步骤，你应该没有问题。

How To Lock Or Unlock Cells In Excel? (2022)

Sometimes you don’t want some cells in your excel sheets to be altered. You can do so by learning how to lock or unlock cells in excel. 

Microsoft Excel provides us with an excellent way to store our data in a tabulated and organized form. But this data can be altered when shared among other people. If you want to protect your data from deliberate changes, then you can protect your Excel sheets by locking them. But, this is an extreme step that may not be preferable. Instead, you can lock particular cells, rows, and columns too. For instance, you can allow users to enter specific data but lock the cells with important information. In this article, we’ll see different ways to lock or unlock cells in Excel.

How To Lock Or Unlock Cells In Excel?

You can either lock the entire sheet or just choose individual cells depending upon your choices.

How to Lock All Cells in Excel?

To protect all the cells in Microsoft Excel, you simply have to protect the entire sheet. All the cells in the sheet will be protected from any over-writing or editing by default.

1. Select ‘Protect Sheet’ from the bottom of the screen in ‘Worksheet Tab’ or directly from the ‘Review Tab’ in the Changes group.

2. The ‘Protect Sheet’ dialogue box appears. You can either choose to protect your excel sheet with a password or leave the ‘password protect your excel sheet’ field empty. 

3. Choose the actions from the list that you want to allow in your protected sheet and click on ‘OK.’

4. If you choose to enter the password, a ‘confirm password’ dialogue box will appear. Type your password again to finish the process.

Also read: How to Remove Password from Excel File

How to Lock and Protect Individual Cells in Excel?

You can lock single cells or a range of cells by following the steps below:

1. Select the cells or ranges that you want to protect. You can do it with a mouse or by using the shift and arrow keys on your keywords. Use the Ctrl key and mouse to select non-adjacent cells and ranges.

2. If you want to lock whole column(s) and rows(s), you can select them by clicking their column or row letter. You can also choose multiple adjacent columns by right-clicking on the mouse or using the shift key and mouse.

3. You can also select only the cells with formulas. In the Home tab, click on Editing group and then ‘Find and Select’. Click on Go to Special.

4. In the dialogue box, select the Formulas option and click OK.

5. Once you have selected the desired cells to be locked, press Ctrl + 1 together. ‘Format Cells’ dialogue box will appear. You can also right-click on the selected cells and choose the Format cells option to open the dialogue box.

6. Go to the ‘Protection’ tab and check the ‘locked’ option. Click on OK, and your work is done.

Note: If you are trying to lock cells on a previously protected Excel sheet, you’ll need to unlock the sheet first and then do the above process. You can lock or unlock cells in Excel in 2007, 2010, 2013, and 2016 versions.

How to Unlock and Unprotect Cells in Excel Sheet?

You can directly unlock the entire sheet to unlock all cells in Excel.

1. Click on ‘Unprotect Sheet’ on the ‘Review tab’ in the changes group or click on the option by right-clicking on the Sheet tab.

2. You can now make any changes to the data in cells.

3. You can also unlock the sheet using the ‘Format Cells’ dialogue box.

4. Select all cells in the sheet by Ctrl + A. Then press Ctrl + 1 or right-click and choose Format Cells. In the ‘Protection’ tab of the Format Cells dialogue box, uncheck the ‘Locked’ option and click OK.

Also Read: Fix Excel is waiting for another application to complete an OLE action

How to Unlock Particular Cells in a Protected Sheet?

Sometimes you may want to edit specific cells in your Protected Excel sheet. By using this method, you can unlock individual cells on your sheet using a password:

1. Select the cells or ranges that you need to unlock in a protected sheet by a password.

2. In the ‘Review’ tab, click on the ‘Allow users to edit Ranges’ option. You need to unlock your sheet first to access the option.

3. The ‘Allow users to Edit Ranges’ dialogue box appears. Click on the ‘New’ option. 

4. A ‘New Range’ dialogue box appears with Title, Refers to cells, and Range password field.

5. In the Title field, give a name to your range. In the ‘Refers to cell’ field, type the range of cells. It already has the selected cells range by default.

6. Type the password in the Password field and click on OK.

7. Type the password again in the ‘confirm password’ dialogue box and click OK. 

8. A new range will be added. You can follow the steps again to create more ranges.

9. Click on the ‘Protect Sheet’ button.

10. Type a password in the ’Protect Sheet’ window for the entire sheet and choose the actions you want to allow. Click OK.

11. Type the password again in the confirmation window, and your work is done.  

Now, even though your sheet is protected, some of the protected cells will have an extra protection level and would be unlocked only with a password. You can also give access to the ranges without having to enter a password every time:

1. When you made the range, click on the ‘Permissions’ option first.

2. Click on Add button in the window. Enter the name of the users in the ‘Enter the object names to select’ box. You can type the user name of the person as stored in your domain. Click on OK.

3. Now specify the permission for each user under ‘Group or user names’ and check the Allow option. Click on OK, and your work is done.

Recommended:

• How to Swap Columns or Rows in Excel
• How to convert Excel (.xls) file to vCard (.vcf) file?
• Quickly Switch Between Worksheets in Excel
• How to Fix Whatsapp Images Not Showing In Gallery

These were all the different ways in which you can lock or unlock cells in Excel. Knowing how to protect your sheet is very necessary to protect it from accidental changes. You can either protect or unprotect cells in an Excel sheet all at once or select a particular range. You can also give certain users access with or without a password. Follow the steps above carefully, and you shouldn’t have a problem.

Related posts

• 如何在Excel中交换Columns or Rows [逐步]

• Fix Excel正在等待另一个应用程序来完成OLE action

• 如何在Excel中Copy and Paste Values Without formulas

• 如何从Excel File中删除Password

• 如何在 Excel 中冻结行和列

• Copy Paste无效Windows 10？ 8 Ways修复它！

• 下载grammarly破解免费为Firefox，Chrome，Microsoft Office

• 访问拒绝安装源 - Microsoft Office error

• 修复检索数据。等待几秒钟，然后尝试在 Excel 中再次剪切或复制错误

• 5 Ways在Word中插入Square Root Symbol

• 如何在Safe Mode开始Microsoft Word

• Microsoft Office缺少Ribbon中的Draw Tool Tab？加入它！

• Excel中的Quickly Switch Between Worksheets

• 什么是XLSX file & How打开XLSX File？

• 如何在 Word 和 Google Docs 中创建悬挂缩进

• 如何将Microsoft Office文件保存到iPad上的Dropbox

• 如何在Microsoft Office中恢复已删除的字体

• 书评 - Microsoft Excel 2010 一步一步

• 如何在 Microsoft Excel 中从单元格中删除值但保留公式

• 如何在2021年绘制Microsoft Word