How To Lock Cells Or Protect A Sheet In Google Sheets (2026)
Google Sheets lets you lock a whole sheet or just a few cells so other people cannot change them by accident.
The feature is called protected sheets and ranges, and it takes about a minute to set up on a computer.
You can also allow some cells to stay editable, which is handy for forms and shared trackers.
Quick answer: lock cells in Google Sheets
| Goal | Where to click |
|---|---|
| Lock a range of cells | Data, Protect sheets and ranges, Add a sheet or range, then highlight the cells |
| Lock a whole sheet | Pick the sheet in the panel, and optionally check Except certain cells |
| Warn instead of block | Set permissions, then Show a warning when editing this range |
| Remove the lock | Data, Protect sheets and ranges, then click the delete icon next to the protection |
You need to be the owner or an editor of the spreadsheet to set any of this up.
Protect a range of cells
- Open the spreadsheet in Google Sheets on a computer.
- Click Data, then Protect sheets and ranges, and a panel opens on the right.
- Click Add a sheet or range.
- Click the spreadsheet icon and highlight the cells you want to lock.
- Click Set permissions.
- Choose how to limit editing, then click Done.
To change a lock you already made, click that protection in the panel instead of adding a new one.
Protect a whole sheet
- Click Data, then Protect sheets and ranges.
- Click Add a sheet or range.
- Pick the sheet you want to protect.
- To leave some cells open for typing, check Except certain cells and select them.
- Click Set permissions and choose who can edit.
This is the usual setup for a template, where only the input cells should stay open.
Choose who can edit
| Permission option | What happens |
|---|---|
| Show a warning when editing this range | Anyone can still edit, but they must confirm first |
| Only you | Only you can edit, plus the owner if you are not the owner |
| Only domain | Only people in your organization can edit, and it is available only when everyone in your domain can edit the spreadsheet |
| Custom | Only the people you select can edit |
| Copy permissions from another range | Reuses the permissions of another range or sheet |
Pick Custom when a shared sheet needs a few named editors and everyone else should be locked out.
See which cells are locked
Go to View, then Show, then Protected ranges.
Protected cells then appear with a striped background, so you can spot them at a glance.
Remove or change protection
- Click Data, then Protect sheets and ranges.
- In the panel, click Cancel to show all protected ranges.
- Find the protection you want to remove.
- Click its delete icon.
Editors can control who edits ranges and sheets, but they cannot remove an owner’s permissions.
What protection cannot do
| Limit | Detail |
|---|---|
| No password | You cannot add a password to protection |
| Not a security measure | People with access can still print, copy, paste, import and export copies |
| Formatting | You cannot lock cell formatting while allowing input edits on the same sheet |
| Office files | If Protected sheets and ranges is missing, you are probably editing an Office file, so convert it to Google Sheets first |
| Copies | Editors can copy a protected sheet or the whole workbook, and viewers can copy the spreadsheet |
Google states plainly that protection is not meant as security, so share a sheet only with people you trust.
Hiding a sheet is not the same as protecting it
- Click the sheet tab.
- Click the down arrow on the tab.
- Click Hide sheet.
The Hide sheet option appears only when the spreadsheet has two or more sheets.
To bring it back, go to View, then Show, and select the sheet.
All editors can unhide a hidden sheet, and viewers can still reach its content, so use protection if you need real control over editing.
Check who changed a cell
If a value changed before you added protection, Sheets can show who edited that cell.
- Open the spreadsheet at sheets.google.com.
- Right-click the cell.
- Choose Show edit history.
Google says this history leaves out added or deleted rows and columns, format changes, changes made by formulas, and changes made before a version restore.
Other sheet tab actions worth knowing
The same Google help page lists a few tab actions that are useful when you are organizing a protected workbook.
| Action | How |
|---|---|
| Duplicate a sheet | Click the tab’s down arrow, then Duplicate, and the copy appears next to the original |
| Copy to another spreadsheet | Click the down arrow, choose Copy to, pick the destination, then click Select |
| Rename a sheet | Double-click the tab name and type a new one |
| Change tab color | Click the down arrow, then Change color |
| Act on several sheets at once | Hold Shift, select the tabs, then choose copy, delete, duplicate, hide or move |
Duplicating a sheet is a quick way to keep an unprotected working copy while the original stays locked.
If someone says they cannot edit a locked cell
That is exactly what protection is for, so the fix is to change the permissions rather than the cell.
- Open Data, then Protect sheets and ranges, and add their account under Custom.
- If they only have View access, they can click Request edit access in the file and send the request to the owner.
- If they are signed in to the wrong Google Account, they should sign out and open the link with the right one.
If the cell is not protected and still will not accept edits, Google suggests using a supported browser, checking that the file is not too large, clearing your cache and cookies, and turning off browser extensions.
Related guides
If your spreadsheet is lagging after you add rules and formulas, see why Google Sheets is so slow.
To undo a mistake someone already made in a sheet, read how to restore an earlier version of a Google Doc, which also covers Sheets.
Spreadsheet opens but will not edit on a phone? See why you can’t edit a Google Sheet on your iPhone.