Lock Cells in Google Sheets: Why It May Not Work

You cannot lock a cell in Google Sheets the same way you can in Excel by changing a cell’s Locked setting. Instead, Google Sheets controls editing through protected ranges or protected sheets; if that option is missing or does not stop someone from editing, your access level, file type, or protection settings are usually the reason.

What locking cells means in Google Sheets

In a spreadsheet, locking usually means preventing people from changing certain cells while leaving other cells editable. A common example is a form-like worksheet where people can enter quantities in a few columns but must not overwrite formulas, headings, or reference data.

Google Sheets handles this with protected ranges and protected sheets, rather than a per-cell Locked checkbox. A protected range can cover one cell, a block of cells, or a non-adjacent selection. A protected sheet restricts editing across a whole tab, with the option to leave particular cells unprotected. Protection is an editing control, not a way to hide cell contents.

This distinction can make the feature seem unavailable if you are looking for an Excel-style Format Cells setting. In Google Sheets, the relevant controls are in the Data menu, and permissions are assigned to people or groups rather than activated by a cell-format property.

How protection works

Protection is applied to a range or sheet in the spreadsheet. When you configure it, you can either restrict who is allowed to edit the protected area or show a warning when someone tries to change it. Those choices behave differently: a warning is only a prompt, while restricted editing blocks changes by people who are not permitted to edit that area.

To create a protected range in a browser:

Select the cells you want to protect. For example, select C2:C50 if those cells contain formulas.
Choose Data > Protect sheets and ranges.
In the panel that opens, choose Add a sheet or range, then confirm or adjust the range shown.
Choose Set permissions and select whether to restrict editing or show a warning. For a restriction, choose who can edit the range and save the setting.

To protect an entire tab, use the same panel and choose the sheet option. You can allow specific cells on that sheet to remain editable, which is useful when a template has fixed calculations but needs blank input fields. Check the selected range before saving: protecting the wrong tab or an overly broad range can prevent collaborators from entering information where you intended them to.

Why the protection option may be unavailable

The most common reason is that you do not have permission to change the spreadsheet. Viewers can read a sheet, and commenters can leave comments, but neither role can edit cell contents or set editing protections. If you need to configure protection, ask the owner to grant you Editor access or make the change for you. A file can also have editing restrictions at the sharing level, which are separate from protections on individual ranges.

Another possibility is that the file is still an Excel workbook rather than a native Google Sheets file. Google Drive can open and edit Office files, but some Sheets-specific features and menus may not be available in Office editing mode. If you are allowed to convert the file, use File > Save as Google Sheets, then check the Data menu in the converted copy. Conversion creates a Google Sheets version; keep the original if you need to preserve it or compare formatting and formulas.

The interface matters, too. The instructions above apply to Google Sheets in a web browser. On a phone or tablet, menus and editing controls can differ, and some protection-management tasks may be easier or only available in the desktop browser interface. Open the spreadsheet at sheets.google.com on a computer if you cannot find the protection panel in the app.

Finally, make sure you are in the spreadsheet itself and not viewing a downloaded copy, preview, or published version. A published page is for viewing, not for changing spreadsheet protections. If the Data menu is present but the protection option is absent, check whether you are an editor and whether the file has been converted to Google Sheets before troubleshooting the selected cells.

Choose a range or protect the whole sheet

Use a range protection when only particular cells should be restricted. For instance, if a budget sheet has formulas in D2:D30 and users enter expenses in B2:B30, protect D2:D30 and leave the input column open. This is usually easier for collaborators because it preserves access to the cells they need.

Protect a whole sheet when most of its contents should stay unchanged. You can then designate exceptions, such as an input column or a small set of fields. This is often a better fit for a reusable report or template. Before sharing, test the arrangement with a collaborator account or ask a permitted editor to confirm that the intended input cells remain editable.

Protection settings can become confusing when ranges overlap or when a sheet has many exceptions. Give protected sections clear names in the protection panel when appropriate, and review the list if a collaborator reports that a cell is unexpectedly blocked. A rule for the whole sheet and a rule for a smaller range may both be relevant, so check all protections affecting the area rather than assuming the cell itself has a single lock setting.

Common problems after setting protection

A warning appears, but editing still works: The range is set to show a warning, not to restrict editors. Change the permission choice if you need a block.
A collaborator can still edit: That person may be included among the permitted editors, may have ownership-level control, or may be editing a different range than the one protected. Review the exact range and its allowed editors.
You can edit a protected cell yourself: That does not necessarily mean protection failed. Owners and people granted permission to edit the protected area can still make changes.
Someone cannot enter data in a cell: The cell may be inside a protected range or outside the exceptions on a protected sheet. Review the rule and adjust the open cells rather than removing all protection.
The menu is missing: Confirm that you have Editor access, are using the actual spreadsheet, and are not working in an Office file or a limited mobile interface.

If a collaborator is blocked unexpectedly, ask them to note the tab and cell address, then compare that address with the rules in Data > Protect sheets and ranges. This is more reliable than repeatedly changing sharing permissions, because spreadsheet-wide sharing and range protection solve different problems.

Protection is not a password or a privacy feature

Protected ranges are intended to prevent accidental edits and manage collaboration. They are not encryption, and they do not make data confidential. People who can view the spreadsheet may still be able to see protected cell contents; depending on their access and the file’s settings, they may also be able to copy information or make another copy. Do not use cell protection as a substitute for limiting who can access sensitive information.

Google Sheets protection also does not create a password that an editor must enter to unlock a cell. If you need someone to edit a protected area, adjust the permitted editors or change the protection rule. If you need to keep information private, share a separate file with only the people who should see it, and choose the file’s sharing access carefully.

Another frequent misconception is that hiding a tab is the same as protecting it. Hiding a sheet changes what is immediately visible in the workbook; it is not a reliable confidentiality boundary for people with access to the file. Use sharing controls for access to information, and use protected ranges to reduce unwanted changes.

Google Sheets protection compared with Excel

In Excel, users commonly mark cells as locked or unlocked and then protect the worksheet. The lock property by itself does not stop editing until sheet protection is enabled. Google Sheets uses a different model: define the protected range or sheet, then specify who may edit it. As a result, instructions that say to right-click a cell, open Format Cells, and clear or select a Locked box do not describe the Google Sheets workflow.

Both programs can help preserve formulas while allowing selected inputs, but their controls and permission models are not identical. If a workbook will move between Excel and Google Sheets, check its protections after converting or importing it rather than assuming that every restriction transfers in the same way. For a collaborative Google Sheets file, use the Sheets protection panel; for an Excel workbook, use Excel’s worksheet-protection tools.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell and create a protected range for it through Data > Protect sheets and ranges. Choose restricted editing if you want to block people who are not permitted to edit it; a warning alone does not block changes.

Why can I edit a cell that is protected?
You may be the spreadsheet owner or an editor explicitly allowed by that protection rule. Also verify that the cell is actually included in the protected range and that the rule restricts editing rather than merely displaying a warning.

Can I protect cells with a password?
No. Google Sheets range and sheet protections use account-based editing permissions, not a password for unlocking individual cells. Change who is allowed to edit, or adjust the file’s sharing access if you need to change who can open it.

Can viewers edit a protected range?
Viewers cannot edit spreadsheet cells, protected or otherwise. Protection rules are mainly useful when some people have Editor access but should not change particular areas.

Can I lock cells in the Google Sheets mobile app?
The protection controls may not be available in the same way as in the browser. If you cannot find them, open the spreadsheet in Google Sheets on a computer and use 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.