Can You Lock Certain Cells in Google Sheets? Here’s How

Can You Lock Certain Cells in Google Sheets? Here's How

Yes. In Google Sheets in a web browser, select the cells, choose Data > Protect sheets and ranges, and set who can edit that range. You can also protect an entire sheet while leaving selected cells open, which is useful when people need to enter information but should not change formulas or headings.

What cell protection does in Google Sheets

Google Sheets calls this feature protecting a range or a sheet. Protection restricts who can make changes in the selected area; it does not turn cells into read-only fields for every purpose, nor does it encrypt their contents. A person who is allowed to edit the spreadsheet may still be able to see protected information. Treat protection as a way to prevent accidental or unauthorized edits by collaborators, not as a way to keep confidential data secret.

Protection is useful in shared trackers, budgets, schedules, forms, and project plans. For example, a team may need to enter quantities in column C while preserving product names in column A and formulas in column D. Protecting A and D can help keep the sheet’s structure and calculations intact without stopping collaborators from updating the intended input cells.

Protection is separate from the spreadsheet’s general sharing settings. Sharing determines whether a person is an editor, commenter, or viewer across the file. Protected ranges add an editing restriction for particular parts of a spreadsheet. A viewer cannot edit the file at all; a protected range is most relevant when someone already has editing access but should not change a specific area.

How to protect selected cells or a range

Use Google Sheets in a browser and follow these steps. You can select a single cell, a continuous range, or a range entered directly in the protection sidebar.

Select the cells you want to protect. For example, click the name box to the left of the formula bar and enter B2:B20 if that is the range to protect.
Choose Data > Protect sheets and ranges. A sidebar for protected sheets and ranges opens.
Choose Add a sheet or range if a protection rule is not already being created, then check the range shown in the sidebar. Give the rule a descriptive name, such as “Calculated totals” or “Do not edit: headings.”
Select Set permissions. To prevent edits, choose the option to restrict who can edit the range, then choose who is allowed. Depending on the available choices, you can limit editing to yourself or specify permitted collaborators.
Confirm the permissions. Try the rule with an appropriate collaborator or account if you need to verify that it behaves as intended.

Google Sheets may warn an editor when they try to change a protected range, depending on the permission option selected. A warning is not the same as a restriction: it alerts people but still lets them proceed. If the goal is to stop edits by particular collaborators, choose the restriction option rather than the warning-only option.

Protect a whole sheet but leave input cells editable

Sometimes it is easier to protect everything on a tab except the cells people are meant to fill in. This is a good fit for a template where formulas and labels are fixed but a few fields, such as “Date,” “Owner,” or “Status,” need regular updates.

Open Data > Protect sheets and ranges, then choose Add a sheet or range.
Choose the option to protect a sheet and select the tab you want to protect.
If the sidebar offers an Except certain cells field, enter the ranges that should remain editable, such as B2:B20 and D2:D20.
Choose Set permissions and restrict who can edit the protected sheet.

The exception ranges are the deliberately open areas; the rest of the sheet is covered by the protection rule. Check the ranges carefully before applying it. If a collaborator reports that a permitted input cell is blocked, revisit the exception list and confirm that it includes the correct tab and cell addresses. This approach can be easier to maintain than creating many separate protection rules, especially when a sheet has a large protected area and only a few editable sections.

Choose between protecting a range and protecting a sheet

Use a protected range when only particular cells need restrictions and the rest of the tab should stay editable. This is usually the clearest option for a small set of formulas, a header row, or a reference table embedded in a working sheet.

Protect the whole sheet with exceptions when most of the tab should be left alone and only a handful of input areas should remain open. For instance, a monthly reporting template might have formulas throughout the sheet but allow edits only in a few designated entry columns. A whole-sheet rule with exceptions can make the intended editing areas easier to explain.

Before choosing, consider how the spreadsheet will change over time. If rows or columns are frequently added, several narrowly defined range rules may need maintenance. If a sheet is frequently copied as a template, test the resulting copy and its protections before distributing it. Clear labels and a short instruction near the editable cells can also prevent confusion: collaborators should not have to guess which cells are meant for them.

What protected cells do not do

Google Sheets protection is not a password lock for individual cells. It does not hide their contents from editors, and it should not be used to store secrets or sensitive information in a shared file. People with access may be able to view or copy data even when they cannot edit the protected cells. If someone should not see the data, change the file’s sharing access or keep that data in a separate, appropriately restricted file.

Protection also does not replace a backup or version history. A collaborator may make other changes to an unprotected area, and mistakes can still happen elsewhere in the spreadsheet. For important work, use sensible sharing permissions and retain an appropriate copy or recovery process. The protection feature is a guardrail around edits, not a complete data-loss prevention system.

Finally, do not confuse cell protection with formatting. Changing a cell’s color, adding a note, or applying data validation does not by itself prevent someone from editing it. Those tools can guide data entry, but the protected-range or protected-sheet setting is what controls editing permissions for the covered area.

Common problems and how to fix them

People can still edit the cells. Check whether the rule is set to show a warning rather than restrict editing. Open the protection sidebar and review the rule’s permissions.
A collaborator cannot edit an input cell. Check that the cell is outside the protected range, or included in the sheet’s exception list. Verify the tab name and range addresses too.
The wrong person is blocked. Reopen Set permissions and review which collaborators are allowed to edit. Also check the spreadsheet’s general sharing settings; a person needs suitable file access before range-level permissions can help them edit.
The protected cells are still visible. That is expected. Protection controls editing, not viewing. Adjust sharing access or separate the information if it must not be seen.
There are several rules and their effect is unclear. Open the protection sidebar and review the listed rules, names, and ranges. Use descriptive names and remove outdated rules when the sheet’s layout changes.

When troubleshooting, test with the account and access level that the collaborator actually uses. An owner’s view of a file may not demonstrate what a different editor can change. Avoid sharing a live file more widely just to test a rule; use a copy with sample data if the spreadsheet contains information that should remain private.

Google Sheets protection compared with Excel

Excel also has worksheet protection and allows users to leave selected cells unlocked, but its workflow and terminology differ. In Excel for Microsoft 365 on Windows, a common approach is to unlock the cells intended for input and then use Review > Protect Sheet. Google Sheets instead lets you define protected ranges or protect a sheet and specify exceptions through its protection sidebar. The two products’ settings do not transfer as identical permission rules simply because a spreadsheet is opened or converted between them.

In both programs, worksheet protection is best understood as a control against unwanted editing, not a substitute for file access controls or secure storage. If collaborators need different access to different data, plan the file’s sharing arrangement as well as its cell-level rules. For a team working in Sheets, use the Google Sheets protection settings and test them in the shared environment rather than relying on assumptions from Excel.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell, open Data > Protect sheets and ranges, and create a protected range for that cell. Then set who can edit it.

Can I lock formula cells but leave the rest editable?
Yes. Protect the formula cells as one or more ranges, or protect the sheet and list the intended input cells as exceptions. Choose the method that is easiest to maintain as the sheet changes.

Can I protect cells with a password?
Google Sheets’ protected ranges use collaborator permissions rather than a password that unlocks individual cells. Manage access through the protection settings and the file’s sharing permissions.

Can a protected cell still be viewed or copied?
Protection is intended to restrict editing, not hide the cell’s contents. Do not put information in a shared sheet if its viewers or editors should not be able to see it.

Can I protect cells in the Google Sheets mobile app?
This guide describes the browser workflow, where the full protection sidebar is available. If you do not see the controls in a mobile app, open the spreadsheet in Google Sheets in a desktop browser to manage the protection settings.

Make the protection useful to collaborators

Before applying restrictions, identify which cells are inputs and which are structure, calculations, or reference data. Protect the areas that need to stay stable, choose a restriction rather than a warning when edits should be blocked, and make the allowed areas obvious. Then review the rule when the spreadsheet layout or team membership changes. That combination makes cell protection a practical way to reduce accidental edits while keeping a shared sheet usable.

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.