Can You Lock Cells in Google Sheets? How It Works

Yes. In Google Sheets, you can protect individual cells, ranges, or an entire sheet so that selected people cannot edit them. In a web browser, go to Data > Protect sheets and ranges, choose what to protect, and set editing permissions; this is an access control for edits, not a password that hides or encrypts the data.

How cell protection works

Google Sheets calls this feature protecting a sheet or range rather than locking cells. A protected range can be a single cell, a block of cells, or multiple selected cells. A protected sheet applies restrictions across a whole tab, with an option to leave specific cells editable. The protection is attached to the spreadsheet, so collaborators who open the file encounter the permission rules you set.

Protection is useful when people need to work in the same file but should not accidentally overwrite formulas, headings, or approved figures. It does not stop them from selecting a protected cell or seeing its contents. Nor does it replace the spreadsheet’s ordinary sharing permissions: someone who only has Viewer access cannot edit the sheet in the first place, while protection lets you put narrower limits on people who otherwise have Editor access.

Protect a specific cell or range

Use a range protection when only certain parts of a sheet should be off-limits. For example, a budget template might let teammates enter amounts in B4:B20 while protecting the formulas in C4:C20 and the totals row. To set it up in Google Sheets in a browser:

Select the cell or range you want to protect. You can also open Data > Protect sheets and ranges first, then enter a range in the sidebar.
Choose Data > Protect sheets and ranges. A sidebar opens on the right.
Check that the range shown is correct. Optionally give the protection a descriptive name, such as Formula cells or Approved rates.
Select Set permissions. Choose whether to show a warning when someone edits the range or to restrict who can edit it.
If you choose restricted editing, select the permitted editors offered in the dialog, then save the setting.

For example, protecting C4:C20 while leaving B4:B20 open means collaborators can enter their own figures without changing the corresponding calculations. Check the selected range before saving: a misplaced row or column reference can protect the wrong cells or leave important formulas exposed.

Protect a whole sheet and allow exceptions

Use sheet protection when most of a tab should remain unchanged. In the protection sidebar, choose Sheet instead of Range and select the tab you want to protect. You can then configure who may edit it. If a few cells need to stay available for input, use the option to exclude certain cells from the protection and specify those ranges.

This approach works well for a form-like worksheet. Suppose a weekly report has instructions, labels, and formulas across the tab, but staff should fill in D5:D12. Protect the sheet and add D5:D12 as an exception. People can enter updates in those cells while the rest of the tab is protected, subject to the permissions you choose.

Before applying a sheet-wide rule, consider whether collaborators need to insert rows, change formatting, or update any other part of the tab. A broad protection can get in the way of ordinary work. If only formulas or a few key cells need safeguarding, protecting those ranges may be less disruptive.

Choose between a warning and restricted editing

Google Sheets offers two different levels of protection. A warning alerts someone when they try to edit a protected area, but it does not block the edit: the person can confirm and continue. Choose this when the goal is to prevent accidental changes while keeping the file flexible for trusted collaborators.

Restricted editing is the stronger choice when only specified people should be able to change a range or sheet. The permission dialog lets you select who can edit. The spreadsheet owner retains control, and the available choices depend on the file and account permissions. Check the names or groups in the dialog rather than assuming that every editor will automatically be excluded.

These settings are separate from sharing the file. If someone should not see the spreadsheet at all, change the file’s sharing access rather than relying on cell protection. If someone can view the spreadsheet but should not alter it, give them Viewer access instead of Editor access. Protection is most useful for a person who needs to edit some parts of a spreadsheet but not others.

Practical ways to use protected cells

Protection is especially helpful in collaborative templates, but it is worth deciding in advance which areas are inputs and which are controlled. Common examples include:

Formula columns: Leave entry cells editable, while protecting calculated totals, tax estimates, or status formulas.
Reusable templates: Protect instructions, headings, and layout so each team can fill in its own designated fields.
Reference tables: Limit edits to approved lists, standard rates, or codes that other tabs rely on.
Review workflows: Protect finalized sections after a review, while leaving a separate notes or follow-up area open.

A clear layout makes these rules easier to follow. Use labels such as Enter data here and Formula—do not edit, and consider using a consistent fill color for input cells. Those visual cues do not enforce permissions, but they help collaborators understand how to work in the sheet without repeatedly encountering blocked edits.

What protection does not do

Protected cells are not hidden cells. Anyone who has permission to view the spreadsheet can generally see the protected content, including formulas and values. Protection is also not encryption, a password lock, or a way to keep confidential information from an editor. If information must not be visible to a person, do not include it in a spreadsheet shared with that person; use file-level access controls or a separate file with appropriate sharing permissions.

Google’s protection feature is intended to prevent or discourage editing, not to make data impossible to copy or redistribute. Depending on the person’s access and the file’s settings, an editor may still be able to copy information or make changes in a copy of the spreadsheet. Protection also does not stop an authorized editor from changing the protection settings if their access allows it. Use it as a practical guard against accidental edits and to manage routine collaboration, not as a security boundary for sensitive data.

Protection does not validate information entered into the cells you leave editable. If a field must contain a date, a number in a particular range, or a choice from an approved list, use data validation as well. Data validation controls what can be entered; protection controls who can edit specified areas. The two features solve different problems and can be combined.

Common problems and fixes

If a collaborator says they cannot edit a cell, first check whether it is inside a protected range or a protected sheet. Open Data > Protect sheets and ranges and review the rules in the sidebar. Overlapping protections can make the arrangement confusing, so remove outdated rules and keep names and ranges specific.

If someone can still edit an area you expected to block, check whether the protection is set to warning rather than restricted editing. A warning is not a hard stop. Then confirm the correct cells or sheet were selected, and review the permitted editors in the permission dialog. Also check whether the person is the file owner or has access that lets them manage the spreadsheet.

When the menu or controls are not available, confirm that you have permission to edit the spreadsheet and are using the browser version of Google Sheets. The interface on phones and tablets may not expose the same protection controls as the desktop browser. Account type, organizational policies, and file ownership can also affect which actions are available. Ask the owner or a Workspace administrator to check access if the controls remain unavailable.

Finally, remember that protection does not freeze the spreadsheet’s structure in every possible way. Collaborators may still be able to work in unprotected cells, and an open exception can be edited by people allowed to edit it. Test the setup with an appropriate collaborator account, or ask a colleague to confirm the intended cells are editable before distributing a template widely.

How Google Sheets differs from Excel

Google Sheets and Microsoft Excel both let you limit changes to parts of a spreadsheet, but their protection systems are not identical. In Sheets, use Data > Protect sheets and ranges and choose which people can edit. In Excel for Microsoft 365 on Windows, worksheet protection is managed from Review > Protect Sheet, with options that control actions such as selecting or formatting cells. Excel also distinguishes worksheet protection from protecting the workbook structure.

Neither feature should be treated as a substitute for controlling who can access sensitive information. In particular, Google Sheets protection is based on editor permissions rather than a password that hides a range. If you are moving a workbook between programs, review the protection settings after conversion; do not assume a protected range in one application will behave exactly the same way in the other.

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 one-cell range is treated like any other protected range.

Can I lock cells but leave other cells editable?

Yes. Protect only the cells that should not be changed, or protect the entire sheet and add the cells people may edit as exceptions. Set the permitted editors in the protection settings.

Can I password-protect cells in Google Sheets?

No. Google Sheets protection uses account-based editing permissions and does not give an individual range a password. Use file-sharing controls to manage access, and do not share information with people who should not be able to view it.

Can I hide a formula by protecting its cell?

No. Protection limits editing, not visibility. A viewer or editor with access can still see cell contents. Keep confidential formulas or data in a separate file if collaborators should not see them.

Why can someone still edit a protected cell?

The range may be set to show a warning rather than restrict editing, or the person may be allowed to edit it. Check the selected range and the permitted-editor list under Data > Protect sheets and ranges.

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.