How to Lock Cells in Google Sheets

Prevent unauthorized changes to data by protecting your spreadsheets. In a protected spreadsheet, none of its contents can be changed. However, it's also possible to set up the spreadsheet so that only certain cells and elements can be changed after it's protected.

Protect a Spreadsheet

1. Click Data on the menu bar.
2. Select Protected sheets and ranges.

   The Protected sheets & ranges pane opens on the right.

3. Click Add a sheet or range.
   
4. (Optional) Enter a description.
5. Specify what you want to protect:
   • Range: Protect a cell or cell range from edits.
   • Sheet: Protect a sheet from edits. To leave a range of cells unprotected, check the Except certain cells box.
6. Click Set permissions.
   
7. Specify how you want to limit editing:
   • Show warnings when the spreadsheet is edited.
   • Specify who can edit the spreadsheet.
8. Click Done.
   

The spreadsheet is protected and no changes can be made to the specified content.

Edit or Delete Protection

You can also edit which areas of your spreadsheet are protected, or delete protection from your spreadsheet altogether.

1. Click Data on the menu bar.
2. Select Protected sheets and ranges.

   The Protected sheets & ranges pane displays the protected ranges in this spreadsheet.

3. Click the protected area you want to edit or delete.
   
4. Edit the protection or delete it by clicking the trash icon.
   

The protection is edited or removed from the spreadsheet.