قالب وردپرس درنا توس
Home / Tips and Tricks / How To Protect Cells From Editing In Google Sheets

How To Protect Cells From Editing In Google Sheets



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.

  Select the group of cells to protect.

For selected cells, open the Data menu and click Protect Sheets and Areas.

  Click

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.

 Click Customized from the drop-down menu

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.

 From the people who have access to the spreadsheet, select the user you want to have access to, and then click

Anytime someone tries to edit these cells without permission to edit them

  Prompt to notify the person that they are not allowed to edit these cells

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.

  Click Data, then Protect Sheets and Areas

. Then click the permission rule that you want to change.

 Select the permission y You want to change

. Click on "Set permissions".

 Click Set permissions.

Select "Show alert when editing this area," and then click Done.

] Do you have a warning? Click Warn when editing this area, and then click Done.

The next time you try to edit one of the protected cells, this message appears instead:

 You are editing a range of cells that has been protected

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.

  Click Data, then Protect Sheets and Areas

. In the Protected sheets and panels window on the right, click Sheet, select a sheet from the drop-down menu, and click Set Permissions.

 Click Sheet, and then click a sheet drop-down menu, and finally 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.

 Click Custom from the drop-down menu

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 ,

 Under the people who have access to the sheet, select the user you want, and 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.

 Select the just-created permission rule for the sheet

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.

 Click Except Specific Cells, enter the range of cells you want to edit, and then 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.

 The Prompt Notifying Everyone Who Tries to Work Outside the Specified Range Can not Do This

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.

 In the right pane, click the protection area rule

. Then click on the trash next to the description of the rule.

 Click the trash next to the description.

You will be asked to confirm that you want to remove the protection zone or not. Click on "Remove".

 A prompt to confirm that you really want to remove protection opens. Click Remove

After you remove the protected area, anyone with edit access to your table can edit the contents of the previously protected cells / tables.


Source link