如果您煞费苦心地创建了Excel 工作(Excel)表,您可能希望阻止其他人进行更改。您可以通过学习如何锁定Microsoft Excel工作表中的单元格来做到这一点。
在本教程中,我们还将向您展示如何保护Excel中的工作表和整个工作簿,以阻止人们对整个文档进行更改,而不是对几个单元格进行更改。除此之外,我们还将介绍如何取消保护Excel中的工作表。
如何保护Excel中的工作(Excel)表(Sheet)以防止编辑
您可以使用保护工作表功能来阻止人们更改您的Excel工作表。为此,请打开任何Excel工作簿并选择功能区(Ribbon)菜单上方的审阅选项卡。(Review)Review选项卡位于Data和View选项卡之间。
要保护单个Excel工作表,请单击位于功能区(Ribbon)菜单的保护(Protect)部分中的保护工作表。(Protect Sheet)您现在可以为工作表设置密码(set a password)。
保护工作表(Protect Sheet)的弹出菜单允许对可以在工作表上使用的Excel功能进行精细控制。您可以取消选中要阻止的功能。要阻止人们更改Excel工作表中的单元格,请务必取消选中“设置单元格格(Format)式”选项。
编辑对象(Edit Objects)选项在这里值得特别提及。如果禁用它,人们仍然可以运行嵌入在Excel文件中的宏,但无法删除它。完成后单击确定(Click OK)。
这将保护您正在处理
的Excel电子表格,但如果您有一个包含多个工作表的文档,则必须使用不同的选项来防止所有类型的编辑。(Excel)
要阻止人们在Excel工作簿中添加、移动或删除工作表,请转到“审阅”(Review)选项卡并单击“保护工作簿(Protect Workbook)” 。您将看到一个名为Protect Structure and Windows的弹出窗口。添加密码以阻止人们轻松进行更改,并在完成后选择确定。
锁定(Lock Specific Cells)Excel工作表
中的特定单元格
要锁定Excel工作表中的特定单元格,请打开电子表格并在Windows上按(Windows)Ctrl+A或在Mac上按(Mac)Command+A以选择所有单元格。然后,在Windows上按(Windows)Ctrl+1或在Mac上按(Mac)Command+1打开“设置单元格格(Format Cells)式”窗口。您也可以通过在Windows上按(Windows)Ctrl+Shift+F或在 Mac 上
使用Command+Shift+F键盘快捷键(keyboard shortcut)来打开此弹出窗口。
如果您的键盘有问题,请选择功能区(Ribbon)菜单上方的主页选项卡,然后按(Home)字体(Font)部分右下角的箭头图标。您也可以右键单击任何单元格并选择Format Cells。
选择(Select)保护选项(Protection)卡,取消选中锁定(Locked)复选框,然后选择确定。
现在您应该找到并选择要锁定的单元格或单元格范围。完成后,再次按Ctrl+1,然后转到“保护”(Protection)选项卡。选中锁定(Locked)复选框,然后单击确定。这将锁定Microsoft Excel中的特定单元格,但在阻止其他人编辑这些单元格之前还有一个步骤。
单击(Click)查看(Review)选项卡并选择保护工作表(Protect Sheet)选项。在此处添加密码,然后浏览弹出窗口中的选项列表。取消选中您要阻止的所有内容,然后选择确定。确认您的密码并再次选择确定。
这将阻止Microsoft Excel(Microsoft Excel)中的特定单元格。您将能够编辑Excel文件中未锁定的单元格,但不能编辑已锁定的单元格。请记住,如果您在保护工作表之前应用了条件格式,则即使某些单元格被锁定,格式也会继续按预期触发。
如何在Excel中锁定一系列(Range)单元格(Cells)
您还可以允许人们使用密码来编辑Excel 工作表(Excel worksheet)中特定范围的单元格。这使您可以设置单独的密码来保护Excel工作表,并为您希望人们编辑的每个单元格范围设置第二个密码。
当人们编辑工作表中的单元格时,他们不必取消对整个文档的保护。这将允许您锁定公式单元格,并且只允许人们使用密码来修改需要输入数据的单元格。
为此,请打开电子表格并在文档中选择公式,或者选择整个行(rows)或列。现在转到Review选项卡并选择Allow Edit Ranges。
在允许(Allow) 用户(Users)编辑范围(Edit Ranges)弹出窗口中,单击新建(New)。这将打开一个新范围(New Ranges)弹出窗口,其中包含您选择的所有单元格。
给它一个标题以便于查找,例如Locked Data Input Cells。输入(Enter)单元格范围的密码,单击确定,然后确认密码。最后,使用保护工作表(Protect Sheet)功能锁定工作表。您现在可以使用此密码来编辑您刚刚定义的单元格范围。
继续学习(Learning)和探索 Microsoft Excel(Exploring Microsoft Excel)
既然您已经了解了如何在Microsoft Excel中锁定单元格,您应该继续探索该应用程序以彻底了解它。
开始学习基础知识(start learning the basics)永远不会太晚。您还可以查看如何比较两个不同的 Excel 文件并突出显示它们之间的差异(compare two different Excel files and highlight the differences)。
How to Lock Cells in Microsoft Excel
If you’ve painstakingly created an Excel sheet, уоu might want tо stop others from making changes. You can do this by learning how to lock cells in Microsoft Excel sheetѕ.
In this tutorial, we’ll also show you how to protect sheets and entire workbooks in Excel to stop people from making changes to the entire document, as opposed to a few cells. Along with this, we’ll also cover how to unprotect sheets in Excel.
How to Protect Sheet in Excel to Prevent Editing
You can use the protect worksheet feature to stop people from changing your Excel sheets. To do this, open any Excel workbook and select the Review tab above the Ribbon menu. The Review tab is located between the Data and View tabs.
To protect a single Excel sheet, click Protect Sheet, which is located in the Protect section of the Ribbon menu. You can now set a password for the sheet.
The pop-up menu for Protect Sheet allows granular control over Excel features that can be used on the sheet. You can uncheck the features you want to block. To stop people from making changes to cells in your Excel sheet, be sure to uncheck the Format cells option.
The Edit Objects option deserves a special mention here. If you disable it, people will still be able to run macros embedded in your Excel file, but will not be able to delete it. Click OK when you’re done.
This will protect the Excel spreadsheet you’re working on, but if you have a document with multiple sheets, you will have to use a different option to prevent all types of editing.
To stop people from adding, moving, or deleting sheets in your Excel workbook, go to the Review tab and click Protect Workbook. You’ll see a popup titled Protect Structure and Windows. Add a password to stop people from making changes easily, and select OK when you’re done.
Lock Specific Cells in an Excel Sheet
To lock specific cells in an Excel sheet, open the spreadsheet and press Ctrl+A on Windows or Command+A on Mac to select all cells. Then, press Ctrl+1 on Windows or Command+1 on Mac to open the Format Cells window. You can also open this pop-up by pressing Ctrl+Shift+F on Windows or by using the Command+Shift+F keyboard shortcut on Mac.
If you’re having issues with your keyboard, select the Home tab above the Ribbon menu and press the arrow icon in the bottom-right corner of the Font section. You may also right-click any cell and select Format Cells.
Select the Protection tab, uncheck the Locked check box, and select OK.
Now you should find & select the cells or range of cells that you want to lock. Once you’ve done that, press Ctrl+1 again, and go to the Protection tab. Check the Locked check box and click OK. This will lock specific cells in Microsoft Excel, but there’s one more step before you can stop others from editing these cells.
Click the Review tab and select the Protect Sheet option. Add a password here, and go through the list of options in the pop-up. Uncheck everything you want to block, and then select OK. Confirm your password and select OK again.
This will block specific cells in Microsoft Excel. You will be able to edit unlocked cells in the Excel file, but not the ones you’ve locked. Remember that if you’ve applied conditional formatting before protecting the sheet, the formatting will continue to trigger as expected even if some cells are locked.
How To Lock a Range of Cells in Excel
You can also allow people to use a password to edit a specific range of cells in your Excel worksheet. This lets you set a separate password to protect the Excel sheet and a second password for each range of cells you want people to edit.
When people edit cells in your sheet, they will not have to unprotect the entire document. This will allow you to lock formula cells and only allow people to use a password to modify cells where data input is necessary.
To do this, open a spreadsheet and select formulas in the document, or select entire rows or columns. Now go to the Review tab and select Allow Edit Ranges.
In the Allow Users to Edit Ranges pop-up, click New. This will open a New Ranges pop-up that has all the cells you’ve selected.
Give this a title to make it easy to find, such as Locked Data Input Cells. Enter a password for the range of cells, click OK, and confirm the password. Finally, use the Protect Sheet feature to lock the sheet. You’ll now be able to use this password to edit the range of cells that you just defined.
Keep Learning and Exploring Microsoft Excel
Now that you’ve learned how to lock cells in Microsoft Excel, you should keep exploring the app to know it inside out.
It’s never too late to start learning the basics. You can also check out how to compare two different Excel files and highlight the differences between those.