Protecting individual cells in Google Sheets is a great way to prevent data in your worksheet from being accidentally or intentionally modified by anyone looking at the worksheet. Fortunately, Sheets provides a handy tool to protect people from changing cells in your document.
Protecting cells in Google Sheets
One of the best features of Google Sheets (and all other Google apps) is the ability for those who do this Edit access to collaborate on documents in the cloud. However, sometimes you do not want the people you share a document with to edit certain cells in your worksheet without completely revoking them. Here the protection of certain cells can be helpful.
RELATED: To create sharable download links for files on Google Drive
Start your browser, open a Google Sheet that contains the cells you want to protect, and then select the cells.
For selected cells, open the Data menu and click Protect Sheets and Areas.
The Protected sheets and areas pane appears on the right. Here you can enter a brief description and then click "Set Permissions" to customize the protection privileges of the cell.
<img class = "alignnone wp-image-412401 size-full" data-pagespeed-lazy-src = "https://www.howtogeek.com/wp-content/uploads/2019/04/x2019-04 -25_17h10_09.png.pagespeed.gp + jp + jw + pj + ws + js + rj + rp + rw + ri + cp + md.ic.OFtEfo2AqA.png "alt =" Enter a description and click " By default, any user who is allowed to edit the document will be allowed to edit any cell on the page, click the drop-down menu under "Restrict who can edit this section," and then click "Custom." to specify who is allowed to edit the selected cells.
By default, anyone who can edit is already selected by default with whom you shared editing permissions Disable anyone who does not want to edit the selected cells, and then click Done.
Anytime someone tries to edit these cells without permission to edit them
RELATED: The Best Google Sheets Add-Ons Ons
Viewing a warning message when editing cells
However, if you prefer to edit the cells, you have a warning message for all users. If you want to edit certain cells, you can do so.
In your Sheets document, go back to Data> Protected sheets and areas in the toolbar.
. Then click the permission rule that you want to change.
. Click on "Set permissions".
Select "Show alert when editing this area," and then click Done.
The next time you try to edit one of the protected cells, this message appears instead:
Protecting an entire sheet in Google Sheets
If you want to protect a whole sheet so nobody but you can edit it, you can just share it with them, but give them only view instead of permission to edit.
However, suppose you want to protect most of a sheet, but leave some cells open for editing – as you would for a form or an invoice. In this case, users still need permission to edit, but it would be quite difficult to select all cells on the worksheet, with the exception of the few that you want to allow for editing.
There is another way. You can protect the entire sheet and then grant access to specific cells.
Open your document and go back to Data> Protected sheets and areas in the toolbar.
. In the Protected sheets and panels window on the right, click Sheet, select a sheet from the drop-down menu, and click Set Permissions.
. As in the previous cell protection example, you must specify who can edit the sheet in the window that opens.
Click Click in the drop-down menu under "Restrict who can edit this area" and select "Custom" to specify who is allowed to edit the selected sheet.
Users who can edit turn off the selection for everyone you want to revoke the edit permissions on for this worksheet d Then click Done ,
Anyone who has access to your document can continue to open and see the contents of the sheet you have protected, but can not make any changes or edits to the actual worksheet.
Adding Exceptions to a Protected Worksheet
When protecting an entire worksheet, Google Sheets locks every single cell. However, if you want to grant editing access to just a few cells, you can specify which ones are editable.
Back to Data> Protected sheets and areas from the toolbar and then from the opening pane Click the rule for the protected sheet you want to edit.
RELATED: Import an Excel document into Google Sheets
and then click Next , toggle "Except Specific Cells" and enter the cell range you want to edit. Click Done.
If someone tries to edit other than the cells you want If they are editable, they will see the same prompt as before and notify them that they can not.
Removing Permission Rules
To remove permission rules that you just created Open the Protected sheets and areas area by going to Data> Protected sheets and areas. Click here on the rule you want to delete.
. Then click on the trash next to the description of the rule.
You will be asked to confirm that you want to remove the protection zone or not. Click on "Remove".
After you remove the protected area, anyone with edit access to your table can edit the contents of the previously protected cells / tables.