How to Lock Cells in Google Sheets (Protect a Range)

Google Sheets are amazing as you can easily share and collaborate with others.

One of the issues that come with working on a shared Google Sheet is that anyone can make a change in it. This may not be something you want.

So you can easily protect a range of cells in Google Sheets and make sure no one messes up your work.

How to Lock Cells In Google Sheets

Here are the steps to lock cells in Google Sheets:

  1. Go to the Data option
  2. Click on ‘Protect sheets and range’. It will open the ‘Protected sheets and ranges’ pane on the right.How to Protect a Range of Cells in Google Sheets - data
  3. In the ‘Protected sheets and ranges’ pane, click on ‘Add a sheet or range’.how-to-protect-a-range-of-cells-in-google-sheets-add-sheet
  4. Enter a description. While this is optional, if you have multiple ranges that you want to protect, this will help manage it
  5. Below the description field, select from one of the two options (Range or Sheet). In this case, since you want to protect a range of cells, select
  6. In the field below it, click on the grid icon and select the range of cells that you want to protect in the
  7. Click Ok.
  8. Click on the ‘Set permissions’ button to specify who can edit this range. Here you get two options:
    • Show a warning when editing this range: This would allow anyone to edit this range, however, it will show a warning as shown below. This could be useful if you don’t want to restrict editing but want to highlight some rules or caveats. For example, if you want to get the entry in a specific data format, or you want to make sure the user is entering the right content. You can not, however, change the warning message.
    • Restrict who can edit this range: From the drop-down, you can select ‘Only you’ or Custom. When you select custom, you can also add other editors who will have permission to make changes. To add editors, simply enter their email id and click on Done.

In case you want to unlock the cells/range that you’ve already locked, follow the above steps, and when the ‘Protected sheets and ranges’ pane opens, delete the condition you are applied to lock the cells

In case you want to lock all the cells in a worksheet (i.e., take the entire worksheet), right-click on the worksheet tab name and then select the ‘Protect sheet’ option.

So this is how you can easily lock cells in Google Sheets.

I hope you found this tutorial useful!

You May Also Like the Following Tutorials:

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.