如何防止单元格在Google表格中进行编辑

Protecting individual cells in Google Sheets is a great way to prevent data in your spreadsheet from getting changed—accidentally or intentionally—by anyone viewing the sheet. Fortunately, Sheets provides a handy tool to prevents people from altering cells in your document.

保护Google表格中的各个单元格是一种很好的方法，可以防止任何查看表格的人有意或无意地更改电子表格中的数据。 幸运的是，Sheets提供了一个方便的工具来防止人们更改文档中的单元格。

保护Google表格中的单元格 (Protecting Cells in Google Sheets)

One of the best features of Google Sheets (and all the other Google apps) is the ability for anyone with edit access to collaborate on documents in the cloud. However, sometimes you don’t want the people you’re sharing a document with to edit specific cells in your sheet without completely revoking their ability to edit. This where protecting specific cells comes in handy.

Google表格(以及所有其他所有Google应用)的最佳功能之一是，具有编辑权限的任何人都可以在云中对文档进行协作。 但是，有时您不希望与文档共享的人员在不完全取消其编辑能力的情况下编辑工作表中的特定单元格。 这在保护特定细胞方面很方便。

Fire up your browser, open a Google Sheet that has cells you want to protect, and then select the cells.

启动浏览器，打开包含您要保护的单元格的Google表格，然后选择单元格。

With the cells selected, open the “Data” menu and then click “Protect Sheets and Ranges.”

选择单元格后，打开“数据”菜单，然后单击“保护图纸和范围”。

The Protected Sheets and Ranges pane appears on the right. Here, you can enter a brief description and then click “Set Permissions” to customize the cell’s protection permissions.

“保护的图纸和范围”窗格显示在右侧。 在这里，您可以输入简短说明，然后单击“设置权限”以自定义单元的保护权限。

By default, anyone who already has permission to edit the document is allowed to edit every cell on the page. Click the drop-down menu under “Restrict Who Can Edit This Range” and then