قالب وردپرس درنا توس
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 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.

  Select the set of cells you want to protect

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

  click on Data and then on Protect Sheets and Stretches

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.

  Enter a description and then click Set permissions

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.

  On the drop-down list, click Custom

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

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

  Please tell the person that they may not edit these cells

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

  click on Data and then on Protect Sheets and Steps

Then click on the permission rule you want to change.

 Select permission y you want to change

Click "Enter permissions".

 Click Set permissions

Select "Show a warning when editing this interval" and then click "Done."

 Rather show a warning? Click Show a warning when editing this area and then click Done

The next time someone tries to edit one of the protected cells, they will receive this message instead:

 The kind warning that you are editing a number of cells that have been protected

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 on Data and then on Protect Sheet and Steps

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.

  On the drop-down list, click Custom

Below the list of people who can edit, deselect who you want to revoke change permissions for this sheet d, click "Done."

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

 Select the sheet permission rule you just created

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

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

 The promo that tells someone who is trying to edit outside the specified area can not do it

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.

 Click on the protected line rule from the box to the right

Next, click on the trash can, which is next to the rule's description.

 Click on the trash bin next to the description

You are prompted to confirm that you want to remove the protected area or not. Click "Delete."

 A quick verification that you really want to remove the cover opens. 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.