Protecting individual cells in Google Sheets is a great way to prevent data in your spreadsheet from being inadvertently or intentionally-by someone looking at the sheet. Fortunately, Sheets provides a useful tool for protecting people from changing cells in your document.
Protecting Cells in Google Sheets
One of the best features of Google Sheets (and any other Google apps) is the ability for anyone with access to access to collaborate with documents in the cloud. Sometimes you don't want the people you share a document to edit specific cells in your sheet without completely recalling their ability to edit.
How to create divisible download links for files on Google Drive
Look up your browser, open a Google sheet that contains cells you want to protect, and then select the cells.
With the selected cells, open the "Data" menu, and then click "Protect Sheets and Ranges."
Box for protected sheets and stretches appears on the right. Here you can enter a short description and then click "Set permissions" to customize the cell's protection state.
By default, anyone who already has permission to edit the document has the option to edit each cell on the page. Click on the drop-down menu under "Restrict who can edit this range" and then click "Custom" to set who can edit the selected cells.
Under the list of people who can edit, everyone you have shared editing permissions has already been selected by default. Deselect someone who does not want to be able to edit the selected cells and then click "Done".
Now, whenever someone who has no permission to edit these cells tries to make any changes, a prompt comes with the following message in Archive:
] RELATED: The best addition to Google Sheets
Here's how to show a warning message when you Editing Cells
If you would rather be able to edit the cells, you can instead get a warning message for anyone trying to edit specific cells, you can also do so.
Return to Data> Protected Sheets and Steps in the toolbar of your Archive document.
Then click on the permission rule you want to change.
Click "Enter permissions".
Select "Show a warning when editing this interval" and then click "Done."
The next time someone tries to edit one of the protected cells, they will receive this message instead:
Protecting an entire sheet in Google Sheets
If you want to protect an entire sheet so that no one but you can edit it, the easiest way to share the sheet with them is to just give them view instead of editing permission.
But say you wanted to protect most of a sheet, but leave some cells open for editing – as you would with a form or invoice. In that case, people would still need to edit the state, but it would be painful to select all the cells on the sheet except the few you want to allow editing.
There is another way. You can protect the entire sheet and then allow access to specific cells.
Open the document and return to Data> Protected Sheets and Steps in the toolbar.
Click "Sheet", select a sheet from the drop-down menu, and then click "Set permissions". Click Sheet and then select a sheet from the drop-down menu, and finally click Enter state "width =" 364 "height =" 386 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this ); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "/>
Just as in the previous example to protect cells, you must specify who can edit the sheet in the window that opens.
Click on the drop-down menu under "Restrict who can edit this range" and select "Custom" to set who has the right to edit the selected sheet.
Below the list of people who can edit, deselect who you want to revoke change permissions for this sheet d, click "Done."
All who have r access to the document can still open and view the contents of the sheet you have protected, but they cannot make any changes or changes to the sheet itself.
How to add exemptions to a protected sheet
When protecting an entire sheet, Google Archive locks each individual cell. However, if you want to provide editing access to only a few cells, you can specify which is editable.
Jump back to Data> Protected sheets and paths from the toolbar, then from the box that opens, click the protected sheet rule you want to edit.
RELATED: To import an Excel document into Google Sheets
Next, switch "besides certain cells" and then enter the cell range as you want to edit. Click "Done".
Finally, if someone tries to edit other cells than the ones you have edited, they will see same prompt as before and notify them that they cannot.
How to remove permissions
To remove some of the permissions you just did open the Protected Sheets and Range window by going to Data> Protected Sheets and Steps. Click here to click on the rule you want to delete.
Next, click on the trash can, which is next to the rule's description.
You are prompted to confirm that you want to remove the protected area or not. Click "Delete."
After deleting the protected area, anyone who has edited access to your spreadsheet can edit the contents of the previously protected cells / sheets.