How to Lock Cells
in Google Sheets
Select the cells you want to lock by clicking and dragging over them.
Click on “Data” in the top menu and choose “Protect sheets and ranges.”
In the right panel, enter a name for the protected range if needed and click “Set permissions.”
Choose who can edit the locked cells—either restrict editing to yourself or allow specific users.
Click “Done” to save the changes, and the selected cells will now be locked for unauthorized editing.
If needed, return to the same menu to adjust permissions or remove cell protection.
