How to lock cells and sheets in Google Sheets ?
|
Aug 28, 2024
|
Google
|
10 Steps
How to lock cells and sheets in Google Sheets ?
Google
|
10 Steps
1
Navigate to https://docs.google.com
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
Click the "Select range" field field
If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field
6
Click "Sheet"
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"
By following these steps you can lock cells and sheets in google sheets