How to Protect Cells From Editing in Google Sheets - WindowsTips.net - Windows Tips and Tricks with Geek

Saturday, February 12, 2022

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.

Select the set of cells you want to protect

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

click Data, then on 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.

Enter a description, then click Set 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.

From the drop-down menu, click Customised

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.”

From the people who have access to the sheet, choose who you want to have access, 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:

Prompt telling the person they aren't allowed to edit these cells

No comments:

Post a Comment