In one of our previous tutorials, we learned how to protect our spreadsheets and lock certain sheets in Google Sheets. We will now learn how to lock individual cells and ranges in Google Sheets.
Step 1: Select the cell or the range of cells to lock.
Step 2: Right click on the selected range. A long list of options will appear. Select Protect range.
Step 3: A sidebar will appear on the right side of Google Sheets with title Protected sheets & ranges.
As you can notice on the sidebar, the range is already specified in the range under the Range tab.
Step 4: Click Set permissions. A pop-up box will appear, giving you the options for protecting the range:
- Show a warning when editing this range - the user accessing the sheet can still edit it after a warning is shown
- Restrict who can edit this range - only a selected list of users can edit the range:
- Only you - only the owner of the spreadsheet can edit the specified range. This is what you need to select if you want to lock the cells for everyone else.
- Custom - a selected number of users can be added to have permissions to edit the specified range. In the box, type the email address, then type space to separate the entries.
Step 5: Click Done.
The selected range of cells is now locked for editing.