How to Lock Cells in Google Sheets main image

When collaborating with people on Google Sheets, Locking certain cells is an extremely useful tool. I will show you how to do so in just a few easy steps.

Step #1: Access "Protected Ranges"

How to Lock Cells in Google Sheets Step 1

Right click the cell that you want to protect. Then, in the drop-down menu click on "Protected Range". That will take you to the "Protected Sheets and Ranges" menu

Step #2: Name It and Set the Range

How to Lock Cells in Google Sheets Step 2

In the "Protected Sheets & Ranges" menu, you will fill in the name and range of your locked cell. The range should already be there if you right clicked the proper cell. Then you will click on the green "Set Permissions" button.

Step #3: Set Permissions

How to Lock Cells in Google Sheets Step 3

Here, you will be able to control who can and cannot edit the cell. you can also manually add new email addresses to your "team" of editors.

Step #4: Verify That it Works

How to Lock Cells in Google Sheets Final

Lastly, you should test your protections by trying to edit the cell from an email account that is restricted.

If the account is properly restricted, nothing will happen to the cell and a notification will appear and inform you that the cell is protected.

That is how you lock, or protect, cells in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!