How to Lock Specific Cells in Google Sheets for Editing

To lock specific cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, add a range protection, and choose who is allowed to edit it. This restricts editing, not viewing: people who can see the spreadsheet may still be able to copy its contents.

What You’ll Need

A Google account with editor access to the spreadsheet. Viewers cannot add or change protected ranges.
The spreadsheet open in Google Sheets in a web browser. The instructions below use the browser menus.
The cell or range you want to protect, and a decision about which collaborators should remain able to edit it.

Before changing protection, check that the sheet is shared with the right people. Range protection controls editing within the file; it does not replace the sharing settings or make sensitive information private.

Step-by-Step

Open the spreadsheet and identify the cells. Open the file in Google Sheets. Decide whether you are protecting one cell, a continuous block, or several separate ranges. For example, you might protect the formula cells in D2:D50 while leaving the input cells in B2:C50 open for a team to fill in. Knowing the intended boundaries first helps prevent protecting the wrong area.
Select the cells to protect. Click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. To protect an entire column or row, click its letter or number header. You can also type a range such as D2:D50 in the name box above the grid and press Enter, then verify the highlighted selection. Be precise: selecting a whole column when you only mean to protect a few formula cells can interfere with later data entry.
Open the protection panel. In the top menu, choose Data > Protect sheets and ranges. A panel opens on the right. If it is already open, you can continue there. The panel is where you create and manage both protected ranges and protected sheets; you do not need to use a separate lock icon or a password.
Add a range rule. In the panel, click Add a sheet or range. Choose the Range tab if it is not already selected. Check the range shown in the box. If it is wrong, enter the correct cell reference, such as D2:D50, or use the grid selector to select cells. Add a description if useful, such as Protect calculation formulas. Descriptions are especially helpful when a spreadsheet has several protections.
Choose whether to restrict editing or show a warning. Click Set permissions. For an actual restriction, choose the option to restrict who can edit the range. If the panel offers Show a warning when editing this range, note that this only displays a warning; it does not stop the edit. Use the warning option when you want to remind collaborators to be careful but do not need to block them.
Specify who can edit the protected cells. For a firm editing restriction, select Only you to limit editing to your account, or choose Custom and select the collaborators who should be allowed to edit. The available choices depend on your role and the file’s sharing setup. Review the selected names before saving. If a teammate needs to maintain formulas, include that person rather than assuming that all spreadsheet editors will keep access.
Save the rule. Confirm the permission choice using the button shown in the panel, such as Done. The protected range should now appear in the protection panel. If you created the rule but it does not appear, check whether the panel is still showing an unfinished setup or whether the save button is waiting for confirmation.
Test it with care. Click a protected cell and try to make a harmless change. Google Sheets should block the change for an unauthorized editor or display the warning you selected. Do not test by overwriting an important formula. If possible, ask a collaborator who is not on the allowed-editors list to test the behavior, or use a nonessential test cell and remove it afterward.
Protect additional ranges separately when needed. Repeat the process for each distinct area that needs a different permission rule. For example, you could allow a manager to edit D2:D50 but restrict a separate summary formula in F1. A single rule is easier to manage when all cells share the same access list; separate rules are more suitable when different people need different access.

To revise or remove a rule later, return to Data > Protect sheets and ranges and select the relevant protection in the side panel. Update its range or permissions, or use the remove option in the rule’s controls if you no longer need it. Removing protection does not delete the cell contents or formulas; it changes who can edit them.

Common Mistakes

Choosing the warning instead of a restriction. A warning asks a person to confirm before editing, but does not enforce a lock. If edits must be prevented, choose the restrict-editing permission.
Protecting the wrong cells. A mistaken drag can include input cells or omit the last formula row. Check the range reference in the panel before saving. For a long sheet, use a clear reference such as D2:D50 rather than relying on a quick visual selection.
Assuming protection hides information. Protected cells remain visible to people who have access to the spreadsheet. Protection is not encryption, a password, or a way to conceal confidential values. Adjust the file’s sharing access or keep private data in a separate, appropriately restricted file.
Thinking the owner is locked out. A protection rule is not a guarantee that the spreadsheet owner can never change the cells. Owners and people with sufficient control over the file may be able to change or remove protections. Do not treat this feature as an immutable audit control.
Protecting an entire sheet by mistake. If you select the Sheet option when you intend to lock only a few cells, collaborators may lose the ability to edit much more than planned. Check that the rule is a range protection and that its boundaries are correct.

Tips

Protect formulas while leaving entry cells open. A common setup is to protect calculation and summary cells, then leave clearly marked input cells editable. For instance, lock the total column but leave the quantity and price columns open. This lowers the chance that someone will replace a formula while still allowing normal updates.
Use descriptions that explain the reason. Names such as Do not overwrite monthly totals tell future editors what a protection is for. Descriptive rules make the side panel easier to review than a list of unnamed ranges, particularly in shared workbooks.
Use sheet protection with exceptions for broad areas. If almost all of a sheet should be restricted, create a sheet protection and use its option to exclude particular cells, when available. Leave designated input cells out of the protected area. This can be simpler than making many separate range rules, but check the exceptions carefully.
Keep a simple map of editable areas. A note at the top of the sheet or a short instruction tab can show collaborators where to enter data and which cells contain formulas. The note does not enforce permissions, but it can reduce confusion and requests for access.
Review rules after changing the layout. Inserting rows, adding a new formula column, or copying a tab can make the existing protections less suited to the new design. Reopen the protection panel after significant edits and verify the ranges and allowed editors.
Use sharing settings for access to the whole file. If someone should not see the spreadsheet at all, remove or change that person’s file access through the sharing controls. Locking a range only affects editing in the specified area; it does not remove a collaborator’s ability to view other content.

Troubleshooting

The protection menu or panel is unavailable. Confirm that the file is open in Google Sheets and that you have editor access rather than viewer or commenter access. If the spreadsheet is opened in a preview or another application, open it in Sheets. In a work or school account, an administrator’s policies may also affect sharing and permissions.
A collaborator can still edit the cells. Check whether the rule is set to show a warning rather than restrict editing. Then verify the cell is actually inside the protected range and that the collaborator is not listed as an allowed editor. Remember that an owner or a user able to manage the protection may be able to alter the rule.
The wrong cells are blocked. Open the protection panel, select the rule, and inspect its range reference. Edit the reference or remove the incorrect rule and create a new one. If you protected a whole sheet, check whether you meant to create a range rule or to add exceptions for editable cells.
A teammate who should edit is blocked. Select the protection in the panel and update its permissions to include that person’s account. Confirm you added the correct Google account; people sometimes use a personal address in one browser and a work address in another. Have the collaborator reload the sheet and try again.
You cannot find or change a protection someone else made. Open Data > Protect sheets and ranges and review the listed rules. The ability to manage a protection can depend on your access to the file and the rule. Ask the file owner or the person who manages the sheet to update it if you cannot change its permissions.
The cells are still editable after you selected protection. Reopen the panel and confirm the rule was saved, not just configured. Make sure you chose the restrict-editing option and not the warning option. If the browser still shows stale behavior, reload the spreadsheet and test again with an account that is not permitted to edit.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select the cell, such as D5, then create a range protection for it through Data > Protect sheets and ranges. Choose the people who can edit that cell.

Can I lock cells but let people edit the rest of the sheet?
Yes. Protect only the cells or ranges that need restrictions. Other cells remain editable according to the spreadsheet’s general sharing permissions, unless they are covered by another protection.

Can I protect several separate ranges at once?
Each protection rule applies to a specified range or sheet. Create separate rules for distinct areas, especially if they need different editors. Keep the rules labeled so collaborators can tell why each one exists.

Does locking a cell stop people from seeing or copying it?
No. Protected ranges control editing, not visibility. A person who can view the spreadsheet may still see the values and may be able to copy or otherwise make a copy of accessible information. Change file access if the data should not be visible.

Can I use a password to unlock protected cells?
Google Sheets range protection uses account permissions, not a cell password. Choose which Google accounts can edit the range. Do not share a password as a substitute for setting file and range permissions.

Can I lock cells in the Google Sheets mobile app?
The steps here are for Sheets in a web browser, where the full protection panel is available. If you cannot find the protection controls in the mobile app, open the spreadsheet in a desktop browser 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.