Guide
How to Lock Cells in Google Sheets
Easily protect important data in your Google Sheets by locking specific cells. This ensures that only authorized users can edit or modify the locked content.
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.