How to Protect cells using Protect sheets and Ranges in Google Sheets

Published June 16, 2022

You can edit documents in the cloud with anyone with editing permissions with Google Sheets. By disabling editing in a specific cell, you can prevent someone from making changes in that cell without completely removing their editing permissions. This can be achieved using cell protection. In this article, we are going to go through how we can protect formulas in Google sheets

How to Protect cells using Protect sheets and Ranges in Google Sheets 

Step 1: Open a Google sheet spreadsheet and select the cells you want to protect.

How to Protect cells using Protect sheets and Ranges in Google Sheets

 

Step 2: Now, on the Google sheets menu, click on “Data”

How to Protect cells using Protect sheets and Ranges in Google Sheets2

 

Step 3: On the “Data” submenu, click on “Protect sheets and Ranges”

How to Protect cells using Protect sheets and Ranges in Google Sheets3

 

Step 4: In the Protected Sheets and Ranges pane on the right, you can enter a brief description and click "Set Permissions" to customize the cell's protection permissions.

How to Protect cells using Protect sheets and Ranges in Google Sheets4

 

Step 5: By default, anybody with permission to modify the document may alter every cell on the page. To restrict who may edit the chosen cells, use the dropdown option under "Range editing permissions" and then click either "Custom" or “Only you.

How to Protect cells using Protect sheets and Ranges in Google Sheets5

 

If you choose “only you,” it is only you who will be able to edit the selected column; on the other hand, if you choose the “custom” option, then it will be only the selected individuals who will be able to edit the selected cells. In this case, we are going to select “Only you.”

 

Step 6: Click “Done” 

How to Protect cells using Protect sheets and Ranges in Google Sheets6

 

Step 7: Now, the selected range (column D) will be protected from editing, and other users will not be able to edit the column endless permitted.

How to Protect cells using Protect sheets and Ranges in Google Sheets7

 

Conclusion

In conclusion, we have learned how to protect a specific cell range in Google sheets.  Using this method, you can prevent the sheets from being accidentally, intentionally, or unauthorized edited by the users who have been granted editing permissions

 

Keywords: Google Docs, Google Sheet, How to Protect cells using Protect sheets and Ranges in Google Sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

67 Views