How to protect Cells in Google Sheets 🔐| 2 min guide

How to protect Cells in Google Sheets 🔐| 2 min guide
Reading Time: 4 minutes
How to protect Cells and Sheets in Google Sheets
Protect Cells in Google Sheets

In this article, we will see how to protect cells in Google Sheets. We will also have a look at how to protect individual sheets in your spreadsheets.

Why protect cells in Google Sheets?

You can choose who can edit some specific cells or sheets in your Google Sheets. It is very useful when you have a lot of people working on the same Google Sheet file. You can choose people who can edit the values. It also alerts the users if they don’t have the access to edit the cell. Hence a user should know how to protect cells in Google Sheets.

Protect Cells In Google Sheets

If you want to keep values for some cell’s content and don’t want anyone to change their values, you can use this feature.

Sample Google Sheet file
Figure 1: Sample Google Sheet File

If you want to fix the commission rate to 8 per cent and you don’t want anyone to change it, you can follow the given steps.

  • Select the cells you want to lock. Right-click and click on Protect Cells
Opening the "Protect range" option
Figure 2: Opening “Protect range” option
  • A sidebar would open. Click on “Add sheet or Range”.
Protect range sidebar
Figure 3: “Protect range” Sidebar
  • Add a description for the cell you’re locking.
Naming the rule
Figure 4: Naming the Rule
  • Set the range for the cell and click on “Set permissions”.
Setting permissions
Figure 5: Select Range and Continue
  • Set the permissions for the cell. Here we would give permissions to only ourselves so that no one else could change the values for the given cell.
Selecting permissions
Figure 6: Select Permision
  • If an unauthorised person tries to update the value of the cell, he/she would be shown the following error.
Error dialog box
Figure 7: Error is shown when an unauthorised user tries to make a change to a locked cell
  • If you want to permit more people you can choose “Custom” while choosing the permission and roles and you’ll be presented with the following screen.
Giving access to other users
Figure 8: Giving cell access to users
  • Enter the people you want to give permission to and click “Done”.

Locking Entire sheets instead of a few cells

You can also lock entires sheets instead of a few cells in Google Sheets. Simply while declaring the essentials, choose “Sheet” instead of “Range”.

Protecting sheets in Google Sheets
Figure 9: Protecting Sheets in Google Sheets
  • You can also choose to exclude a few cells while locking a sheet by clicking on the “Except certain cells” in the checkbox.
Excluding cells while protecting sheets
Figure 10: Excluding Cells while protecting Sheets
  • To exclude cells, simply add the ranges.
  • The rest of the steps are the same as the previous sections and shouldn’t be any different.

Unlock the protected cell

Unlocking a protected cell is pretty easy. Simply follow the given steps.

  • Select the cells you want to lock. Right-click and click on Protect Cells
Opening protected range to delete rules
Figure 11: Opening “Protect Range” to Delete Rules
  • Select the rule you want to delete
Choosing target rules to Delete Rules
Figure 12: Choosing target Rules to Delete Rules
  • Click on the trash icon next to the rule name. Confirm the popup that comes up and it should unlock your cell.
Deleting rules in protected range
Figure 13: Deleting Rules in “Protect Range”

Conclusion

We saw how to protect cells in Google Sheets. It is very useful when you have a lot of people working on the same sheet and you only want some people to have edit access for important fields. You can read more about protecting, hiding and editing sheets here.

See Also

How to import JSON in Google Sheets: See how to work with JSON using Apps Script Editor

Using Vlookup and Hlookup together: Learn how to perform 2-D lookups by combining Vlookup and Hlookup