How to Protect a Range of Cells in Google Sheets

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 Protect a Range of Cells in Google Sheets

Here are the steps:

  • Go to Data –> Protect Sheets and Ranges. It will open the ‘Protected sheets and ranges’ pane on the right.How to Protect a Range of Cells in Google Sheets - data
  • 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
  • Enter a description. While this is optional, if you have multiple ranges that you want to protect, this will help manage it well.how-to-protect-a-range-of-cells-in-google-sheets-description
  • 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 Range.how-to-protect-a-range-of-cells-in-google-sheets-add-range
  • In the field below it, click on the grid icon and select the range of cells that you want to protect in the sheet.how-to-protect-a-range-of-cells-in-google-sheets-grid-icon
  • Click Ok.
  • 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 date 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 the permission to make changes. To add editors, simply enter their email id and click on Done.

You May Also Like the Following Tutorials:

FREE Google Sheets Tips Ebook

Get Work Done Faster with these 10 Google Sheets Tips

X