Lock Cells in Google Sheets: How Cell Protection Works

Yes. In Google Sheets, use Data > Protect sheets and ranges to restrict editing of selected cells or an entire sheet; you can also show an edit warning without blocking changes. Protection controls who can edit, but it is not a password or a way to keep information confidential.

What “locking” cells means in Google Sheets

Google Sheets does not use “locked” in exactly the same way as Excel. In Sheets, collaborators who have editor access can generally edit cells unless a sheet or range has been protected. A protected range can limit editing to selected people, while a protected sheet can prevent edits across a tab, with the option to leave particular cells open.

Protection is useful for preventing accidental changes to formulas, headings, reference tables, or carefully prepared layouts. For example, a project tracker might let teammates update status and due-date columns but restrict the formula columns that calculate completion. The cells remain visible; protection is about editing, not hiding their contents.

It is also possible to set a warning rather than a restriction. That option reminds someone that a range is important when they try to edit it, but it does not stop them from proceeding. Choose a restriction when edits must be limited, and a warning when you mainly want to discourage mistakes.

How to protect a specific range

To restrict editing of a few cells, open the spreadsheet in a web browser and follow these steps:

Select the cells you want to protect. You can select a range such as B2:B50 or a group of cells.
Choose Data > Protect sheets and ranges.
In the panel that opens, choose Add a sheet or range if a range is not already listed.
Check the range shown in the panel and adjust it if necessary. You can also give the protected area a descriptive name, such as “Calculated totals.”
Choose Set permissions, then decide whether to restrict editing or show a warning. For a restriction, choose who is allowed to edit the range and save the setting.

The exact wording or available choices can vary with account access and the protection you are editing. If you choose a restricted range, the permission options let you keep editing limited to yourself or allow specified editors. Take care to include the people who genuinely need to change those cells; other editors may see a notice that the range is protected when they try.

A practical example is a shared expense sheet. You could protect the cells containing tax-rate assumptions and total formulas, while leaving the rows where colleagues enter their own expenses editable. Protect the formula cells rather than the whole table if collaborators need to add new rows or update inputs.

How to protect a whole sheet and leave some cells open

If most of a tab should be read-only for collaborators, protect the sheet instead of selecting every cell. Open Data > Protect sheets and ranges, choose Add a sheet or range, and select the sheet option in the panel. Confirm that the correct tab is selected before setting permissions.

A protected sheet can have exceptions. In the protection panel, use the option to exclude certain cells or ranges, then specify the cells collaborators should still be able to edit. For example, a “Monthly Report” tab could be protected while cells B2:B10 remain available for staff to enter monthly figures. This approach is easier to maintain than protecting the sheet and separately managing many protected blocks, provided the editable areas are clearly defined.

Before sharing, try to think through how the sheet will be used. If collaborators need to insert rows, sort data, or make changes in areas beyond the exceptions, a tightly protected sheet may interrupt their work. A protected range around the calculations can be a better fit when the rest of the sheet needs to remain flexible.

Choosing between a warning, a range, and a sheet

The right setting depends on whether you want to prevent a particular mistake or establish a clear editing boundary. These are useful starting points:

Use a warning for cells people should normally leave alone, but where occasional edits are acceptable. It is a reminder, not an access restriction.
Protect a range when only specific cells—such as formulas, fixed labels, or lookup values—should have limited editors.
Protect a sheet when the tab should generally not be changed, but some input cells need to stay open.
Review sharing access when someone should not be able to edit the spreadsheet at all. Use the file’s sharing settings to change their role rather than relying only on cell protection.

For a collaborative template, a common pattern is to protect formula columns, leave input columns open, and add a warning to important instructions. For a finalized reference tab, protecting the entire sheet may be simpler. The goal is not to protect every cell automatically; it is to make the intended editing workflow clear.

Who can edit a protected range?

Protection permissions work alongside the spreadsheet’s sharing permissions. A person who has editor access to the file may still be prevented from editing a protected area if that person is not allowed by the protection rule. Conversely, giving someone permission to edit a protected range does not give them access to a file they cannot otherwise open.

File owners retain control over the spreadsheet and its protections. When setting a custom list of allowed editors, check the identities carefully and consider whether the people need continuing access. If a collaborator’s role changes, revisit both the file’s sharing settings and any custom protected-range permissions. Removing someone from a range’s allowed editors is not the same as removing them from the spreadsheet.

It is helpful to distinguish an editor from a commenter or viewer. Viewers and commenters cannot freely edit ordinary cells in the first place, so protecting cells is most relevant when a file is shared with editors. If a person only needs to review information, giving them viewer or commenter access may be simpler than granting edit access and protecting many parts of the file.

What protection does not do

Protected ranges are an editing control, not a security boundary for sensitive information. People who can access a spreadsheet may be able to view protected cell contents. Protection does not encrypt the values, conceal formulas, or turn a sheet into a confidential vault. Do not put passwords, private identifiers, or other sensitive material in a sheet on the assumption that protection hides it.

Likewise, hiding a tab is not equivalent to protecting it. A hidden sheet is out of sight in the normal tab bar, but hiding is primarily an organization feature, not a substitute for carefully controlling access. If information should not be available to a collaborator, do not share that information with them in the same spreadsheet; use file-level access and keep restricted data in a separately controlled file.

Editors may also be able to make a copy of a spreadsheet or use other available ways to work with information they can access, depending on the file’s settings and their permissions. Protection should therefore be treated as a way to reduce accidental or unauthorized edits within a shared workflow, not as a guarantee that a recipient cannot reproduce visible data.

Common problems and how to fix them

If someone can still edit cells you expected to lock, first check whether you set a warning instead of a restriction. Open Data > Protect sheets and ranges, select the relevant rule, and review its permissions. Also confirm that the protected range actually includes the cells in question; a rule for B2:B20 will not protect B21.

If a collaborator cannot edit cells that should be open, check whether the sheet itself is protected and whether those cells were added as exceptions. Confirm that the person is signed in to the account included in the allowed-editor list. A colleague using a different Google account may not match the identity you intended to authorize.

When a protected range blocks a legitimate task, do not remove all protection without checking what else the rule covers. Edit the range or its allowed-editor list, or create a clearly defined exception if the whole sheet is protected. If someone needs to make a one-time change, the owner or an authorized editor can adjust permissions and restore the intended protection afterward.

Protection can also become confusing when a spreadsheet is copied, reorganized, or handed to a new owner. After substantial changes, review the protection panel and test the sheet using an account with the intended collaborator role if possible. A quick review can catch a rule that points to an old area or leaves an important formula column unprotected.

How this differs from Excel

Google Sheets and Excel both offer worksheet protection, but their default models differ. In Excel, cells are marked as locked by default, and that setting takes effect when worksheet protection is turned on. In Google Sheets, cells are generally editable by file editors until a range or sheet is protected through the protection panel.

Excel’s sheet-protection controls and Google Sheets’ protected-range permissions are not interchangeable in every detail. A workbook converted between the two programs may not preserve every feature or permission in the same way. If a spreadsheet will be used in both, check the protections after conversion and test the actual editing experience rather than assuming that a lock setting has carried over exactly.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell, open Data > Protect sheets and ranges, add or confirm the range, and set restricted permissions. A single cell is simply a range containing one cell.

Can I lock cells but let people edit the rest of the sheet?
Yes. Protect only the cells or ranges that should have limited editing. Leave the rest of the sheet unprotected, while remembering that other file editors can then edit those unprotected cells.

Can I protect a sheet but allow edits in certain cells?
Yes. Protect the sheet and add the cells or ranges that should remain editable as exceptions in the protection settings. Check the exceptions after changing the sheet layout.

Does protecting cells hide their contents or formulas?
No. Protection limits editing; it does not conceal cell values or provide confidentiality. Use sharing controls and separate files when someone should not see particular information.

Can I password-protect a range in Google Sheets?
Google Sheets’ protected-range feature is based on editing permissions, not a password that unlocks a range. Choose who can edit, and manage access through the spreadsheet’s sharing and protection settings.

Why can an editor still change a protected cell?
Check whether the rule is only a warning, whether the cell falls inside the protected range, and whether that editor is on the allowed list. Also confirm that the person is using the Google account whose permissions you set.

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.