Can You Lock Specific Cells in Google Sheets?

Yes. In Google Sheets in a web browser, select the cells, then choose Data > Protect sheets and ranges to restrict who can edit that range. You can protect a single cell, a group of cells, or an entire sheet, and you can leave selected cells open for editing.

How cell protection works in Google Sheets

Google Sheets does not use a simple lock checkbox on each cell. Instead, you create a protected range or protect a sheet. A range can be as small as one cell, so the result is effectively the same as locking an individual cell: collaborators who do not have permission cannot change its contents.

Protection controls editing, not visibility. People who can view the spreadsheet can still see protected values. Depending on their access and your organization’s settings, collaborators may also be able to copy or download spreadsheet content. Use sharing permissions to control who can open a file; use protected ranges to reduce accidental or unauthorized edits by people who already have access.

Protection is also separate from formatting. Changing a cell’s color, adding a note, or marking it as a formula cell does not lock it. You need to set up protection explicitly, and a cell’s appearance does not reliably tell collaborators whether it is protected.

Protect a specific range or cell

To protect selected cells, first open the spreadsheet in Google Sheets in a browser and make sure you have permission to change its protection settings. Then:

Select the cell or range you want to protect. For example, select B2:B20 to protect those cells, or select just B2 to protect one cell.
Choose Data > Protect sheets and ranges. A panel opens on the right.
Choose Add a sheet or range. If the panel does not already show the right selection, choose the range option and enter or select the range, such as B2:B20. You can add a description to help explain the rule to other editors.
Choose Set permissions, then decide whether to show a warning when someone edits the range or restrict who can edit it.
If you choose to restrict editing, select the allowed editors—such as only you or specified people—and save the setting.

A warning is a prompt, not a lock: a collaborator can choose to continue editing. To prevent other editors from changing the cells through normal spreadsheet editing, choose the restricted-editing option and specify who is allowed. The precise labels shown in the permissions panel can depend on the account and file.

Choose who can edit the protected cells

When restricting a range, Google Sheets lets you control which spreadsheet editors may change it. You can keep editing limited to yourself or use a custom selection of permitted people. These settings apply to people who already have access to the spreadsheet; protecting a range does not invite someone to the file or give them access to it.

Think about the task before choosing a setting. If coworkers should be able to fill in a form but not change its formulas, protect the formula cells and leave the input cells unprotected. If a range is only at risk of accidental edits, a warning may be enough. If changing it could break a report or template, restrict editing instead.

Keep the allowed-editor list current when responsibilities change. Someone who is permitted to edit a protected range can still change it, so a protection rule is only as restrictive as its permissions. File owners and people with broader control over the spreadsheet may also have powers that ordinary editors do not.

Protect a whole sheet but leave some cells open

You can protect a complete sheet and make exceptions for cells that collaborators need to edit. This is useful for a template with fixed headings and formulas but open fields for new information.

Choose Data > Protect sheets and ranges, then choose Add a sheet or range.
Select the Sheet option and choose the sheet you want to protect.
Use the option to exclude certain cells, then specify the ranges that should remain editable.
Choose Set permissions and decide who can edit the protected sheet.

For example, in a monthly expense sheet, you might protect the headings, formulas, and totals while allowing staff to enter dates and expenses in designated columns. Check the exception ranges carefully: a misplaced or overly broad exception can leave cells editable when you intended to protect them. If different areas need different editor lists, consider protecting specific ranges separately rather than relying on one sheet-wide rule.

Practical examples of when to lock cells

Protection is most useful when a spreadsheet has both shared input areas and cells that should stay consistent. Common cases include:

Formula cells: Protect calculation columns so a collaborator does not accidentally replace a formula with a typed value.
Reference data: Protect a list of rates, categories, or product codes while leaving transaction rows open for entry.
Templates: Protect instructions and labels, but leave blank fields available for each person completing the template.
Summary sheets: Protect totals and charts’ source calculations while collaborators update permitted data-entry tabs.

Imagine a shared project tracker where columns A through D contain task details and column E calculates a status from a formula. You could protect the formula cells in E while leaving the task fields editable. If new rows are added regularly, review the protection as the sheet grows; do not assume that a rule you set for one range automatically covers every future row. Keeping data entry and calculation areas clearly separated can make these rules easier to manage.

What protection does not do

Protected ranges are an editing control, not a password or a security boundary for confidential information. A person who can view a sheet can generally see the protected content. If a value must be hidden from some collaborators, do not put it in a spreadsheet they can access; share a separate file with the appropriate audience instead.

Protection also does not prevent every possible change to a file. It does not replace Drive sharing settings, and it does not make a spreadsheet tamper-proof. A permitted editor can change protected cells, and a person with sufficient file-level authority may be able to alter protection settings. A copy of a spreadsheet can have different protections from the original, depending on how it is created and the permissions that apply.

For these reasons, use protection to prevent mistakes and manage everyday collaboration, not as the sole safeguard for sensitive data or as a substitute for access control. Limit file access to the people who need it, and check the spreadsheet’s sharing settings separately.

Common problems and how to resolve them

If someone says they can still edit a range, check what kind of protection you created. A warning-only rule allows them to proceed after acknowledging the prompt. Open Data > Protect sheets and ranges, select the rule, and review its permissions. Confirm that the range shown in the panel is the same range you intended to protect.

If a collaborator cannot edit cells they are meant to use, check whether the cells are inside a protected range or outside the exceptions on a protected sheet. Also confirm that the person is signed in to the account you added as an allowed editor. When someone has more than one Google account, the account used to open the file may not be the one you expected.

Protection can become confusing when several rules overlap or when a spreadsheet is copied and reused. Give rules clear descriptions, remove outdated rules, and test the intended workflow with a collaborator account when appropriate. If you add rows or columns later, inspect the protected ranges and open input areas rather than assuming the original setup still matches the new layout.

How Google Sheets protection differs from Excel

Google Sheets and Excel both offer ways to limit editing, but the setup is different. In Excel, cells are commonly marked as locked by default, and those lock settings take effect when you protect the worksheet. In Google Sheets, you typically create a protected range or protect a sheet and define editing permissions in the protection panel.

The practical idea is similar: protect formulas or fixed content while leaving input cells available. However, do not assume that a protection setting transfers identically when a file moves between Google Sheets and Excel. If you convert or export a spreadsheet, check the resulting file’s protection and sharing behavior in the destination program.

Frequently Asked Questions

Can I lock cells but let people edit the rest of the sheet?

Yes. Protect only the ranges that should stay unchanged, or protect the whole sheet and set exceptions for cells that people need to edit. Then choose the permitted editors for the protected area.

Can I password-protect cells in Google Sheets?

No. Google Sheets protection uses account-based editing permissions rather than a password that unlocks cells. Restrict access to the file through its sharing settings, and use range protection to control editing by collaborators.

Can I protect cells that contain formulas?

Yes. Select the formula cells and add them as a protected range. Google Sheets does not automatically lock every cell just because it contains a formula, so you need to set up the protection yourself.

Can viewers edit a protected range?

Viewers cannot edit the spreadsheet in the first place. Protection is mainly relevant when deciding what people with editing access may change; it does not turn a viewer into an editor.

Can I protect a single cell?

Yes. Select the cell, such as C5, and protect that range through Data > Protect sheets and ranges. A one-cell range is valid for this purpose.

Choose protection that fits the way people work

For a small, shared spreadsheet, protecting just the formula cells may be the clearest arrangement. For a reusable template, protecting the whole sheet and making input-cell exceptions can be easier to maintain. In either case, decide whether a warning is sufficient or whether editing should be restricted, and verify that the allowed editors and editable ranges match the way the sheet is actually used.

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.