How to lock cells and sheets in Google Sheets
Tiffany Zhao
|
10 steps
|
49 seconds
Google Sheets
information ordinal icon
This Scribe shows you how to lock certain ranges (groups of cells) or entire sheets in Google Sheets
1
Navigate to your spreadsheet
2
Right click on a cell in the range you want to lock
3
Hover your mouse over "View more cell actions" at the bottom of the menu and click "Protect range"
4
A side panel will appear. Click "Add a sheet or range"
5
If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field
6
If you want to protect a whole sheet, select "Sheet"
7
Select the sheet you want to lock by opening up the dropdown
8
Click "Set permissions"
9
You can set it so only you can edit the restricted range/sheet, or you can set a custom permission.
10
To finalize, click "Done"