This Scribe shows you how to lock certain ranges (groups of cells) or entire sheets in Google Sheets
Navigate to your spreadsheet
Right click on a cell in the range you want to lock
Zoom Saved
Hover your mouse over "View more cell actions" at the bottom of the menu and click "Protect range"
Zoom Saved
A side panel will appear. Click "Add a sheet or range"
Zoom Saved
If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field
Zoom Saved
If you want to protect a whole sheet, select "Sheet"
Zoom Saved
Select the sheet you want to lock by opening up the dropdown
Zoom Saved
Click "Set permissions"
Zoom Saved
You can set it so only you can edit the restricted range/sheet, or you can set a custom permission.
Zoom Saved
To finalize, click "Done"
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key