How to Protect Cells and Ranges in Google Sheets
Google Sheets uses a permission-based protection model — instead of Excel's Locked + Protect Sheet toggle, you specify who can edit specific ranges. This is more powerful for shared sheets but different from what Excel users expect.
⚡ Quick Answer
Select the range, click Data → Protect sheets and ranges. Click Add a range → Set permissions → choose Restrict who can edit this range → pick who's allowed. Click Done.
How Sheets protection actually works
Unlike Excel's binary "Locked or not," Sheets protection is permission-based. Each protected range has an explicit list of who can edit it. Options:
- Only you — only the sheet owner can edit the range
- Custom — specify a list of email addresses that can edit
- Warning — anyone can edit, but sees a confirmation dialog first
Excel: mark cells Locked, then Protect Sheet globally (all-or-nothing per sheet). Sheets: define ranges with per-user permissions. Sheets is more granular — you can have 5 different ranges each editable by different people. Excel would require workarounds.
Method 1: Restrict who can edit
Standard protection — only specified people can edit the range.
Select the range
Highlight the cells you want to protect.
Open Data → Protect sheets and ranges
The Protected sheets & ranges sidebar opens on the right.
Click Add a range
Confirm the selected range (or type a new one). Optionally add a description like "Formula column — don't edit."
Click Set permissions
Choose Restrict who can edit this range.
Choose who can edit
From the dropdown: Only you, or Custom to specify collaborator emails.
Click Done
The range is protected. Non-allowed editors see the range as read-only.
Method 2: Show a warning instead of blocking
Softer protection — anyone can still edit, but they see a "Are you sure?" dialog first. Great for preventing accidents without fully locking people out.
Follow steps 1-4 above
Select range → Data → Protect sheets and ranges → Add a range → Set permissions.
Choose "Show a warning"
Instead of "Restrict who can edit this range", pick Show a warning when editing this range.
Click Done
When anyone (including you) tries to edit, Sheets prompts: "You're editing part of this sheet that shouldn't be changed accidentally. Edit anyway?"
Method 3: Protect an entire sheet
Rather than protecting individual ranges, lock the whole sheet with exceptions.
Open Data → Protect sheets and ranges
Sidebar opens.
Click Add a range → Sheet
Switch to the Sheet tab in the sidebar (instead of the default Range tab).
Choose the sheet
Pick the sheet you want to protect from the dropdown.
Optionally add exceptions
Tick "Except certain cells" and add ranges that should stay editable (like input cells).
Set permissions and click Done
The entire sheet is protected except the exception ranges.
Managing existing protections
Open Data → Protect sheets and ranges
Sidebar shows all existing protections.
Click a protection to edit
Modify range, permissions, or description.
Click trash icon to delete
Removes protection from that range.
Comparison with Excel
| Feature | Google Sheets | Excel |
|---|---|---|
| Model | Permission-based per range | Locked property + Protect Sheet global toggle |
| Different editors per range | Yes, native | Not really |
| Warning-only mode | Yes | Not native |
| Password protection | No (uses account permissions) | Yes (mild deterrent) |
| Works offline | Yes, syncs when online | Yes |
Sheets protection prevents accidents and enforces workflow — it's not real security. Anyone with edit access to the sheet can see all data regardless of range protection. For genuinely sensitive data, don't share the sheet at all, or use view-only sharing and export scrubbed versions.
Sheets Wizard — smart validation instead of blanket protection
Range protection is a workaround for "someone might edit the wrong cell." Better fix: proper data validation with clear error messages so bad input never lands in the sheet. Sheets Wizard can generate validation rules from natural language descriptions — much better than hoping users don't accidentally edit the wrong cell.
Install Sheets Wizard →Frequently asked questions
How do I protect specific cells in Google Sheets?
Select the cells, click Data → Protect sheets and ranges. Click Add a range. Confirm the range and click Set permissions. Choose Restrict who can edit this range → Only you (or add specific editors). Click Done. The cells are now protected.
What's the difference between protecting cells in Sheets vs Excel?
Sheets uses a permission-based model — you specify who can edit a range (owner, specific collaborators, or a warning). Excel uses a Locked property + Protect Sheet toggle. Sheets is more granular for shared files (different people get different edit rights); Excel is simpler for single-user protection but clunkier for collaboration.
How do I set a warning instead of blocking edits?
When setting permissions, choose 'Show a warning when editing this range' instead of 'Restrict who can edit'. Anyone can still edit but sees a confirmation dialog first. Useful for 'accidental edit prevention' where you don't want to fully lock people out.
How do I remove protection from a range?
Click Data → Protect sheets and ranges. In the sidebar, click on the protected range you want to remove. Click the trash icon to delete the protection. Click Done. The range is now editable by anyone with edit access to the sheet.