Lock Cells in Google Sheets: Steps and Limits

Yes. In Google Sheets, select the cells you want to lock, then choose Data > Protect sheets and ranges to control which collaborators can edit them. You can also protect an entire sheet while leaving selected cells editable, but protection is an editing restriction—not a password or a way to keep data confidential.

What locking cells means in Google Sheets

Google Sheets calls this feature protecting a range or sheet. A spreadsheet editor can normally change any cell in the file. A protected range lets you limit editing of a chosen set of cells, while keeping other parts of the spreadsheet available for collaboration. For instance, you could let a team enter information in a form-like table but prevent changes to its headings and calculation cells.

Protection is tied to the Google account permissions on the spreadsheet. It does not lock a cell in the same way that a physical key locks a box, and it does not encrypt the cell’s contents. It is meant to reduce accidental or unauthorized edits by people who have editing access to the spreadsheet. If a collaborator only has viewer access to the file, they cannot edit cells in the first place.

How to protect a range of cells

Use Google Sheets in a web browser for the clearest access to the protection controls. First select the cells to protect. You can select a single cell, a block such as B2:D20, or non-adjacent cells by making multiple selections where supported. Then open the protection panel:

Select the cell or range in the sheet.
Choose Data > Protect sheets and ranges.
In the side panel, choose Add a sheet or range if a new protection rule is not already being created.
Check that the range shown in the panel is the one you intend to protect. You can edit the range there and optionally add a description to distinguish it from other rules.
Choose Set permissions, then choose who is allowed to edit the protected range.
Choose the restricted-editing option and set the allowed people, or use the warning option if you only want an alert before someone edits.
Confirm the permissions and close the panel.

For a restricted range, you can generally limit editing to yourself or specify particular collaborators who may edit it. The precise choices depend on your account and sharing setup. A person who is not permitted to edit should be prevented from changing the protected cells, while authorized editors can continue working there. Protection does not remove someone’s file-level role or grant them access to a spreadsheet they could not already open.

Protect a whole sheet but leave some cells open

Protecting a sheet is useful when most of a tab should remain unchanged but a few cells are intended for data entry. Open Data > Protect sheets and ranges, choose Add a sheet or range, and select Sheet in the panel. Choose the sheet you want to protect. If appropriate, enable the option to exclude certain cells from protection, then specify the cells collaborators should still be able to edit. Finish by setting permissions.

For example, a monthly planning tab might contain fixed labels and formulas, with staff entering figures only in C5:C25. You could protect the sheet and make C5:C25 the exception. Check the exception range carefully: if it is too broad, collaborators can edit more than intended; if it is too narrow, ordinary data entry may be blocked.

Sheet protection and range protection are different ways to define what is editable. A protected sheet with exceptions is often easier to manage when nearly everything on the tab should be restricted. Separate protected ranges can be more practical when only a few scattered areas need protection and the rest of the sheet should remain editable.

Choose between restricting edits and showing a warning

Google Sheets offers two different purposes that are easy to confuse. Restricted editing prevents people outside the allowed list from editing the protected area. A warning rule, by contrast, displays a confirmation message when someone tries to edit; it does not stop a determined editor from proceeding. Use the warning option for a reminder about a delicate area, not when you need a firm editing boundary.

Consider how the sheet is used before choosing. If staff should enter values in a designated input range and must not alter the formulas beside it, restrict the formula cells and leave the input cells open. If collaborators are trusted but may occasionally overwrite a heading, a warning may be enough. Test the result with an appropriate collaborator account when possible, rather than assuming that the setting behaves as intended for every person.

Useful examples and ways to organize protections

Protection is most effective when the editable areas are easy to identify. In a shared budget tracker, for example, you might protect column A containing category names and the cells that calculate totals, while leaving the monthly amount columns open to the people responsible for entering figures. In an inventory sheet, protect item identifiers and formulas but allow assigned staff to update stock counts.

A few planning choices can make a shared sheet less confusing:

Use a clear description for each protected range, such as Formula cells or Manager review area.
Keep intended input cells visually distinct with a fill color or a note explaining what belongs there.
Protect formulas and fixed reference data rather than broadly restricting cells people need for normal work.
Review the protected ranges when you insert rows, add new sections, or change the sheet layout.
Tell collaborators which cells they should edit and who to contact if a legitimate change is blocked.

Formatting can help guide users, but color alone does not enforce an editing rule. Conversely, protection may not make the workflow self-explanatory: a collaborator who sees an error may not know whether to ask the owner, use an input cell, or request a permission change.

Common problems and how to fix them

If you cannot edit a cell, it may fall inside a protected range or on a protected sheet. Open Data > Protect sheets and ranges and review the rules in the panel. If you own the spreadsheet or have permission to manage the protection, you can adjust the range, change its allowed editors, or remove the rule. If you do not have the necessary access, ask the file owner or an authorized editor to make the change.

If someone still appears able to edit a cell, check whether the rule is only a warning, whether that person is on the allowed-editor list, and whether the selected range actually includes the cell. Also check for overlapping rules or a sheet-level exception that leaves the cell open. A rule aimed at one tab or range does not automatically protect every other tab in the file.

When adding rows or changing a layout, revisit the range definitions rather than assuming that every new cell inherits the intended protection. If a user pastes data into a larger area than expected, the operation may touch both editable and protected cells and be blocked or require adjustment. A practical test is to try the normal editing task with an account that has the same role as the intended collaborators.

What cell protection does not do

Protected cells are not a security boundary for sensitive information. People with access to a spreadsheet may still be able to see information they are allowed to view, and protection should not be treated as hiding or encrypting data. Hiding a sheet or a row is also not the same as restricting access to its contents. If some collaborators must not see particular information, do not put that information in a file they can access; use separate files and share each only with the appropriate people.

Protection also does not replace sharing permissions. The file’s sharing settings determine who can open it and whether they have viewer, commenter, or editor access. Protected-range settings add an editing control inside a spreadsheet for users who otherwise have editing access. Review both kinds of settings when preparing a file for collaboration, and avoid relying on cell protection to prevent copying, sharing, or disclosure of information.

Google Sheets protection compared with Excel

Excel also has worksheet protection and controls for editable cells, but its menus and protection model are not identical to Google Sheets. In Sheets, use Data > Protect sheets and ranges and choose the allowed editors. Excel’s worksheet-protection controls are configured through its own interface, and workbook sharing and file permissions are handled separately. Instructions for one program should not be assumed to match the other.

Both products use protection primarily to control editing, not to make a spreadsheet’s contents secret. If a team moves a workbook between Excel and Google Sheets, review the protection settings after conversion instead of assuming every rule will transfer exactly. The people who need to edit the file, the selected ranges, and the sharing permissions should all be checked in the destination program.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell, open Data > Protect sheets and ranges, and set permissions for that range. A single-cell range is valid; you can also protect a larger block or sheet.

Can I lock cells but let people edit the rest of the sheet?
Yes. Protect only the cells that should not be changed and leave the remaining cells editable. Alternatively, protect the whole sheet and set exceptions for the cells people need to edit.

Can I password-protect cells in Google Sheets?
No. Google Sheets protection uses account-based permissions rather than a password assigned to a cell or range. Set file sharing and protected-range permissions for the relevant Google accounts.

Can viewers edit an unprotected cell?
No. A viewer cannot edit the spreadsheet simply because a cell is unprotected. The file owner must give that person editor access for them to make changes.

Why can’t I change a protected cell?
You may not be an allowed editor for its protected range, or the sheet may be protected without an exception for that cell. Ask the owner or an authorized editor to review the protection settings.

Does hiding a sheet lock its cells?
No. Hiding a sheet changes whether it is displayed in the tab bar; it is not a substitute for protection or access control. Protect the sheet to restrict editing, and use separate files if certain people must not see its data.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.