How to Lock Cells in Google Sheets and Protect Ranges

To lock cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set who is allowed to edit them. To protect a whole sheet while leaving some cells open, protect the sheet and add those cells as exceptions.

What locking cells means in Google Sheets

Google Sheets calls this feature protected sheets and ranges. It controls who can edit specified cells; it does not make them invisible or encrypt their contents. A protected range is useful when a shared spreadsheet contains formulas, reference data, or a carefully formatted template that collaborators should not accidentally change.

Protection is separate from the spreadsheet’s general sharing permissions. Sharing determines who can open the file and whether they can view, comment, or edit it. A protected range adds an editing restriction inside a file that someone can otherwise edit. For example, a team member might be able to update a project-status column but not change the formulas that calculate totals.

It is also different from freezing rows or columns. Freezing keeps headings visible while you scroll; it does not stop anyone from editing those cells. Cell protection is the relevant feature when the goal is to restrict changes.

Protect a cell or range step by step

Open the spreadsheet in Google Sheets in a web browser and select the cell or range you want to protect. You can drag across cells, or click a cell and use the range box above the grid to enter a range such as B2:D20.
Choose Data > Protect sheets and ranges. A panel opens on the right. Select Add a sheet or range if a new protection rule is not already being created.
Check the range shown in the panel. If necessary, enter the correct range in the range field. Add a description if it will help you or another spreadsheet editor understand why the range is protected.
Choose Set permissions. Select the option to restrict who can edit the range, then choose the permitted editors. Depending on your access and the current interface, you can limit editing to yourself or specify permitted people.
Confirm the permissions. Try editing a cell in the protected range to check that the restriction behaves as intended.

Range references use the usual spreadsheet notation. For example, A:A refers to column A, 5:5 refers to row 5, and A2:A10 refers to ten cells in column A. To protect separate areas, create separate protection rules rather than assuming that selecting one area will cover distant cells too.

Protect a whole sheet but leave input cells editable

This setup is often the best choice for a reusable form, tracker, or calculation sheet. It keeps the layout and formulas protected while leaving designated input fields open to collaborators.

Choose Data > Protect sheets and ranges, then select Add a sheet or range.
In the panel, choose the sheet option and select the sheet you want to protect.
Use the option labeled Except certain cells to specify the cells that should remain editable. Enter or select each input range, such as C2:C30 for a column of status entries.
Choose Set permissions and decide who may edit the protected sheet. Confirm the rule and test both a permitted input cell and a cell that should be locked.

Imagine a monthly expense sheet with employee names in column A, amounts in column B, and formulas in column C. You could protect the sheet and leave B2:B30 open for entries. The formulas and labels would be protected, while the intended input cells remain available. If people also need to add new rows, test that workflow before sharing: a tightly protected layout may not allow the edits or structural changes your process expects.

Choose between a protected range and a protected sheet

Use a protected range when only a few areas need safeguards and most of the sheet should remain editable. This is a natural fit for locking formula columns, headings, or a lookup table while letting collaborators update other cells.

Protect the whole sheet when the layout itself should stay fixed. Add exceptions for every area where users are expected to type. This makes the rule easier to reason about in a template, although you should review the exception ranges carefully: a missing or overly broad exception can produce the opposite of what you intended.

Formula cells: Protect the cells that contain calculations, while leaving source-data cells editable if users need to maintain them.
Shared data-entry form: Protect the sheet and leave clearly marked answer fields open.
Reference or instructions tab: Protect the entire sheet if collaborators should read it but not revise its contents.
Mixed-use worksheet: Protect only particular ranges if different sections have different editors.

Think about who needs to make changes, not just which cells look important. A sheet may contain formulas that only one person maintains and input cells used by a group. Setting the permissions around those roles can prevent routine accidents without blocking the everyday work the spreadsheet is meant to support.

Warnings, permissions, and collaboration

When setting permissions, Google Sheets may offer a choice to show a warning when someone edits the range instead of restricting who can edit it. A warning is a reminder, not a lock: a user can proceed after seeing it. Choose a restriction when edits should actually be limited; choose a warning when you want to discourage accidental changes but do not want to block collaborators.

Protected ranges work within the spreadsheet’s sharing model. A person who can only view the file cannot edit ordinary cells either. For a collaborator with edit access, the protection rule determines whether that person can change the protected area. Select permitted editors deliberately, and remember that the file owner retains control of the spreadsheet.

For a team workflow, label protected areas and tell collaborators where they should enter information. A short note such as “Enter dates in column B; formulas are protected” can prevent confusion. If someone needs to edit a protected cell for a legitimate reason, the owner or an appropriately authorized editor can update the rule rather than asking people to work around it.

Edit or remove a protection rule

To review existing rules, open Data > Protect sheets and ranges. The side panel lists the protections for the spreadsheet. Select a rule to inspect its range, description, and permissions. From there, you can adjust the range, change who may edit it, or remove the protection if it is no longer needed.

Before changing a rule in a busy shared file, check whether another person relies on it. Removing a rule can expose formulas or template cells to accidental edits. If a cell unexpectedly refuses a change, reviewing the protection panel is usually more useful than repeatedly trying to edit it. Also check whether a whole-sheet rule has exceptions that affect the cell in question.

What cell protection does not do

Protection is an editing safeguard, not a confidentiality or security boundary. It does not hide protected values from people who can view the sheet, and it should not be used to store information that collaborators are not authorized to see. Use the file’s sharing settings to control access to the spreadsheet, and avoid putting sensitive data in a file shared with people who should not see it.

Protected ranges are also not password-locked cells in the way some spreadsheet users expect. Google Sheets manages editing through account permissions rather than a password that a recipient types to unlock a range. This differs from the familiar worksheet-protection controls in Excel. Neither a cell protection rule nor a warning can prevent someone from making a separate copy of information they are already allowed to view.

For important work, keep an appropriate version history and make sure the file is shared only with the intended people. Protection reduces accidental edits; it does not replace access management, backups, or a review process.

Common problems and how to fix them

The cells are still editable: Reopen the protection panel and check whether the rule is set to show a warning rather than restrict editors. Confirm that the selected range includes the cells you meant to protect.
A collaborator can change a locked cell: Review the permitted-editor list and check whether the cell is actually within an exception range. Make sure the collaborator is opening the intended spreadsheet, not a separate copy.
Users cannot enter data anywhere: If you protected the entire sheet, confirm that the intended input cells were added under Except certain cells. Check the exact range boundaries for off-by-one errors.
The rule applies to the wrong cells: Select the protection rule and inspect its range. A range such as C2:C20 does not include row 21, and a single-cell reference does not protect the rest of its column.
You cannot change the rule: Check your access to the file and whether you are signed in to the account that has the necessary permissions. Ask the owner or an authorized editor to review the protection if you cannot manage it.

When testing a new setup, use a harmless sample cell or coordinate the test with a collaborator. That helps confirm both sides of the workflow: protected cells reject unauthorized edits, and open cells still accept the entries the spreadsheet requires.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell, open Data > Protect sheets and ranges, and set editing permissions for that cell. A range containing just one cell is valid.

Can I lock cells but let people edit the rest of the sheet?
Yes. Protect the specific cells or range and leave the other cells outside the protection rule. If you protect the entire sheet instead, add the editable areas as exceptions.

Can I hide locked cells from other editors?
No. Protection restricts editing; it does not hide cell contents. Use sharing permissions to control who can view the file, and do not treat a protected range as a way to keep data secret.

Can I protect cells with a password?
Google Sheets protection uses editor permissions, not a password for unlocking an individual range. Set who can edit the file and who can edit the protected area instead.

Why can someone still edit a protected range?
The rule may be warning-only, the person may be an allowed editor, or the cell may fall outside the protected range or inside an exception. Review the rule in the protection panel and verify its exact boundaries.

Does locking cells stop people from copying them?
No. It is an editing control, not a way to conceal or secure visible information. People who can view the spreadsheet can see protected cell contents, so use sharing settings for access control.

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.