To lock cells in Google Sheets, select a range or sheet and open Data > Protect sheets and ranges. You can restrict editing or show a warning that still allows the user to continue. This is useful for protecting formulas, approved reference values, and other controlled content while leaving designated input cells editable.
Protection controls editing, not confidentiality. Protected cells remain visible to people who can view the file, and Google says protected sheets and ranges should not be used as a security measure. If the requirement is to restrict access to sensitive information, review file sharing and applicable Drive or Workspace controls instead.
Use Google Sheets protection to control who can edit a range or sheet. Do not use it to hide, encrypt, or make spreadsheet contents confidential.
Choose the right protection behavior
A range protection applies to selected cells, such as formulas, approved rates, or identifiers. A sheet protection applies to an entire tab and can include exceptions for specific input cells.
You can restrict editing or choose Show a warning when editing this range. A warning adds friction but does not block the edit or prove that anyone approved it. Choose the behavior according to the cell’s role and the team’s review process, not according to its color. Formatting can help people navigate a sheet, but it is not an access rule.
For a hypothetical budget, you might restrict calculated cells in B2:B500, leave designated inputs in C2:C500 editable, and use either a warning or a restriction for review-status cells in D2:D500. These ranges are illustrative. The workbook owner should decide which cells require control.
Protect selected cells or a range
Use this workflow when only particular formulas or reference cells need protection:
- Open the Google Sheets file and select the cells.
- Choose Data > Protect sheets and ranges.
- In the side panel, choose Add a sheet or range, select Range, and confirm or enter the range notation.
- Optionally add a description such as Calculated margin or Approved rates.
- Choose Set permissions or Change permissions, select the editing restriction or warning behavior, and select Done.
Before saving, compare the displayed range with the cells you intended to control. Descriptions are especially useful when several protections overlap or another editor will maintain the file. Google documents the workflow, but labels and available choices can vary by account context.
Protect a sheet while leaving input cells editable
Sheet protection fits a tab that is mostly controlled content with a small, explicit data-entry area. Open Data > Protect sheets and ranges, add a protection, choose Sheet, select the intended tab, and enable Except certain cells when specific ranges must remain editable. Set the permissions and select Done.
C2:C500 range.If the goal is only to protect formulas, a clearly scoped range is often easier to maintain than a whole-sheet rule. Check the protection panel for overlapping entries when a cell behaves differently from expectation.
Show a warning without blocking edits
Select the range, open Data > Protect sheets and ranges, and add or select its protection. Choose Set permissions, select Show a warning when editing this range, and select Done. Users can proceed after seeing the warning.
Use warning mode when legitimate overrides are expected and another process handles review. Use a restriction when editing must remain limited to named people. A dismissed warning is not an approval record.
Remove a protection and restore access
Open Data > Protect sheets and ranges, select the relevant protection in the panel, and delete it. Confirm if prompted. Removing one protection does not remove other protections elsewhere in the file, so test the target cells and inspect the remaining entries if access is still blocked.
Viewers and commenters cannot create protection changes, while editors can configure protections, subject to owner permissions. Do not assume that every collaborator can unlock a range. An editor who can change the protection setup may also be able to alter the rule itself.
Understand the security limits
Protected cells remain visible, and protected sheets and ranges do not use a password. Google documents that collaborators may still print, copy, paste, import, or export copies of a protected spreadsheet. Hidden sheets are not a confidentiality boundary either: editors can unhide them, and hidden content may be accessible through copies.
Share sensitive files only with people who should have access. For confidentiality, export control, or compliance evidence, review the relevant Drive or Workspace governance controls rather than relying on protected ranges.
Google documents separate features including version history, Drive file activity, and the Activity dashboard. Their coverage and availability depend on the feature and account conditions. Do not treat them as a universal record of every view, export, copy, or downstream use.
Test the setup before sharing it
Use an ordinary collaborator account where practical, rather than testing only as the owner. Review the protection list, confirm the intended exceptions, and test warning behavior separately from hard restrictions. If the protection menu is missing, Google identifies Microsoft Office editing mode as a possible reason; converting the file to Google Sheets format may be required.
- Confirm the selected range or sheet matches the intended cells.
- Check the authorized editors and every editable exception.
- Test a protected cell and an intended input cell with an appropriate non-owner account.
- If using warning mode, confirm that the warning appears and the edit can proceed.
- Check for overlapping or duplicate protection definitions.
- Review file access and external sharing when the sheet contains sensitive information.
If protections need periodic review, keep a separate team-maintained inventory with one row per protection definition, not one row per cell or edit. A proposed illustrative record can include the file, sheet, normalized range, protection type, permission mode, authorized editors, description, owner, and review date. This is an operational recommendation, not a Google export format or documented API response.
If multiple processes can update that inventory, do not use lookup-then-create as the only deduplication method. Define a database-enforced unique identity over the file, sheet, normalized range, permission mode, and authorized-principal set, then use a transactional upsert. That model is for an external inventory system and does not imply that Google Sheets protection supplies database uniqueness.
When a workflow tool may fit better
Google Sheets remains a practical choice when collaborative calculations and lightweight tabular work are central. A task-oriented workspace may fit better when ownership, workflow state, recurring work, and task-linked operations are more important than spreadsheet formulas.
ClickUp Table view presents tasks as rows and fields as columns. It is not an automatic replacement for a formula-driven workbook. Table view and Custom Field permissions can support task-oriented organization and field access controls where the plan supports them, but permissions are not the same as spreadsheet data validation. Automations and Workspace audit logs also have documented plan, role, event, usage, and retention conditions.
Choose based on the system of record. Keep calculations in Sheets when formulas are primary. Assess a task-oriented platform when responsibilities and workflow transitions are primary, after checking current plan limits and audit requirements. For task-linked workflow design, see ClickUp setup and automation.
Common questions about Google Sheets protection
Can I lock a sheet with a password?
No. Google says protected sheets and ranges cannot be password-protected.
Can users still edit after a warning?
Yes. Warning mode prompts users but does not block the edit.
Why can another editor still change a cell?
Check whether the rule is warning-only, whether the person is authorized, whether the correct range was selected, and whether another protection applies. Editors can configure protections, so a rule is not a defense against an editor who intentionally changes the setup.
Does removing one protection unlock the whole file?
No. It removes the selected protection only. Review the protection panel if editing remains blocked.