How to Protect Cells From Editing in Google Sheets

 

Protecting Cells in Google Sheets

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

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 click “Customized” to set who is permitted to edit the selected cells.

Under the list of people who can edit, everyone with whom you’ve shared edit permissions is already selected by default. Deselect anyone you don’t want to be able to edit the selected cells and then click “Done.”

Now, anytime someone without permission to edit these cells attempts to make any changes, a prompt with the following message in Sheets comes up: