|

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

GoalWhere to click
Lock a range of cellsData, Protect sheets and ranges, Add a sheet or range, then highlight the cells
Lock a whole sheetPick the sheet in the panel, and optionally check Except certain cells
Warn instead of blockSet permissions, then Show a warning when editing this range
Remove the lockData, 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

  1. Open the spreadsheet in Google Sheets on a computer.
  2. Click Data, then Protect sheets and ranges, and a panel opens on the right.
  3. Click Add a sheet or range.
  4. Click the spreadsheet icon and highlight the cells you want to lock.
  5. Click Set permissions.
  6. 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

  1. Click Data, then Protect sheets and ranges.
  2. Click Add a sheet or range.
  3. Pick the sheet you want to protect.
  4. To leave some cells open for typing, check Except certain cells and select them.
  5. 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 optionWhat happens
Show a warning when editing this rangeAnyone can still edit, but they must confirm first
Only youOnly you can edit, plus the owner if you are not the owner
Only domainOnly people in your organization can edit, and it is available only when everyone in your domain can edit the spreadsheet
CustomOnly the people you select can edit
Copy permissions from another rangeReuses 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

  1. Click Data, then Protect sheets and ranges.
  2. In the panel, click Cancel to show all protected ranges.
  3. Find the protection you want to remove.
  4. Click its delete icon.

Editors can control who edits ranges and sheets, but they cannot remove an owner’s permissions.

What protection cannot do

LimitDetail
No passwordYou cannot add a password to protection
Not a security measurePeople with access can still print, copy, paste, import and export copies
FormattingYou cannot lock cell formatting while allowing input edits on the same sheet
Office filesIf Protected sheets and ranges is missing, you are probably editing an Office file, so convert it to Google Sheets first
CopiesEditors 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

  1. Click the sheet tab.
  2. Click the down arrow on the tab.
  3. 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.

  1. Open the spreadsheet at sheets.google.com.
  2. Right-click the cell.
  3. 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.

ActionHow
Duplicate a sheetClick the tab’s down arrow, then Duplicate, and the copy appears next to the original
Copy to another spreadsheetClick the down arrow, choose Copy to, pick the destination, then click Select
Rename a sheetDouble-click the tab name and type a new one
Change tab colorClick the down arrow, then Change color
Act on several sheets at onceHold 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.

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.

Official sources

Leave a Reply

Your email address will not be published. Required fields are marked *