How to Lock Selected Cells in Google Sheets Easily

To lock selected cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, add a range, and restrict who can edit it. Choose the cells carefully, then set the permission to limit editing; protection prevents changes by specified users but does not hide the cells or secure sensitive information.

What You’ll Need

A Google account with editor access to the spreadsheet. If you can only view or comment, you cannot change protection settings.
The spreadsheet open in Google Sheets in a web browser. These steps describe the desktop browser interface.
The cell range you want to protect, such as B2:D10. If the file is shared, know which collaborators should still be able to edit that range.

Step-by-Step

Open the spreadsheet and identify the target cells. Go to Google Sheets and open the file. Find the cells that should stay unchanged, and note their addresses. For example, a formula summary in E2:E20 might be protected while users continue entering information in columns A through D. Protect only cells that need it; this makes the rest of the sheet easier to use.
Select the range. Click the first cell and drag across the other cells, or click the first cell, hold Shift, and click the last cell in a rectangular range. You can also click the name box to the left of the formula bar, type a range such as B2:D10, and press Enter. Check the selection outline before continuing so you do not protect an entire row or column by mistake.
Open the protection controls. In the menu bar, click Data > Protect sheets and ranges. Google Sheets opens a protection sidebar on the right. If the sidebar is already open with an existing rule displayed, use Add a sheet or range to start a new protection rule rather than editing the wrong one.
Confirm that the rule applies to a range. In the sidebar, choose the Range tab or range option if it is not already selected. Check the range field. It should contain the cells you selected, often written in a format like Sheet1!B2:D10. If the tab name or cell addresses are wrong, edit the field directly or return to the sheet and select the intended cells again.
Add a clear description if useful. You can give the rule a short name, such as “Protect totals” or “Formula cells.” A description does not change who can edit the cells, but it helps you recognize the rule later, especially in a shared workbook with several protected ranges. Avoid putting confidential information in the description.
Choose the editing restriction. Click Set permissions. Select Restrict who can edit this range to stop unauthorized edits. Depending on the options available, choose Only you or select Custom and specify the collaborators who are allowed to edit. Review the names carefully: anyone omitted from the allowed list will be blocked from editing that protected range.
Save the permission choice. Confirm the setting in the dialog, using its save or done control if shown. The rule should then appear in the protection sidebar. To check it, close the sidebar, click a protected cell, and try entering a small test change. If your account is allowed to edit the range, the test may succeed; use a collaborator account without permission to verify that the restriction is working. Undo any test change afterward.
Protect additional areas separately if needed. To protect a second, non-adjacent range, repeat the process and create another range rule. For example, protect B2:B10 and D2:D10 as separate rules if the cells between them should remain editable. Keeping separate rules is easier to review and adjust than applying a broad protection that catches cells people need to update.
Check how the rest of the sheet behaves. Click an unprotected cell and confirm that an authorized editor can still change it. Protection applies only to the range in its rule; it does not automatically lock neighboring cells. If the goal is to protect most of a sheet while leaving a few input cells open, protect the sheet and specify the cells that should be exempt instead of creating a large collection of cell-level rules.

In Google Sheets, “lock” is commonly used to describe this protection setting. The feature is named Protect sheets and ranges, rather than a cell-lock button. When a user without permission tries to edit a protected range, Sheets displays a warning or blocks the change according to the rule. Protection governs editing, not viewing: collaborators who can access the spreadsheet may still be able to see protected cell contents.

Common Mistakes

Choosing warning-only instead of a restriction: Google Sheets can show a warning when someone edits a range without preventing the edit. If you need a firm edit restriction, choose Restrict who can edit this range, not the warning option.
Protecting too much or too little: A range such as B:B covers the whole column, while B2:B20 covers only those rows. Recheck the range reference in the sidebar, particularly if rows or columns were selected by clicking their headers.
Assuming protected means hidden: Protected cells remain visible to people who have spreadsheet access. Do not use range protection as a way to conceal passwords, personal details, or other confidential data.
Expecting a password prompt: Google Sheets protection is based on account permissions, not a password that people enter to unlock individual cells. Sharing settings and range permissions determine who can edit.
Blocking ordinary data entry: If you protect a range that contains input cells, collaborators may not be able to complete the sheet. Keep formulas or fixed labels in the protected range and leave intended entry cells outside it, or explicitly allow the people who need to edit it.
Forgetting that a rule can be changed: A protection rule is not a permanent lock. Someone with suitable access to the spreadsheet may be able to change or remove protections. Review collaborators and sharing access as well as the range rules.

Tips

Use a consistent naming pattern. Descriptions like “Lock – formulas – Summary” make it easier to identify a rule than a vague label such as “Range 2.” Use sheet names or purposes, not sensitive details.
Keep editable cells visually distinct. A light fill color or a short note can help collaborators tell input cells from calculated cells. Formatting is only a visual cue; it does not create or replace a protection rule.
Use a protected sheet with exceptions for mostly fixed layouts. If only a few cells should remain editable, select the sheet option in the protection sidebar and specify the cells that are exempt. Test the exceptions afterward, since a mistaken range reference can lock out normal entry.
Review protections after reorganizing the sheet. Inserting, deleting, or moving rows and columns can change what a range covers. Open Data > Protect sheets and ranges and check the listed rules after a major layout change.
Remember the difference from Excel. Excel has its own worksheet-protection workflow, usually through Review > Protect Sheet in Microsoft 365 for Windows. Its controls and behavior are not the same as Google Sheets’ range-permission sidebar, so follow the instructions for the program you are using.

Troubleshooting

The protection menu or sidebar is unavailable. Confirm that you opened the file in Google Sheets and have editor access. A viewer or commenter cannot create a protection rule. If the file is an Excel workbook being edited in Office compatibility mode, some Google Sheets features may not be available in the same way; make a Google Sheets copy if appropriate, or work in the original application.

The wrong cells are protected. Open Data > Protect sheets and ranges, select the relevant rule in the sidebar, and read its range field. Correct the address or remove the incorrect rule and create a new one from the intended selection. If you see a sheet name in the reference, make sure it is the tab you meant to protect.

A collaborator can still edit the cells. Open the rule and make sure it is set to restrict editors, not merely show a warning. Check the custom allowed-editor list and confirm that the collaborator is not included. Also verify that the person is editing the same file and the same cells; a duplicate copy or a different tab may have different protections. If the collaborator is the spreadsheet owner, remember that ownership and access to protection settings can affect what they can change.

A collaborator cannot edit cells that should be open. Check whether a sheet-level protection covers those cells, or whether another overlapping range rule applies. Review the protected sheet’s exception ranges and the allowed-editor list. Remove or adjust only the rule that is causing the restriction, then ask the collaborator to refresh the spreadsheet and try again.

You cannot edit a range yourself. Check whether your account is permitted by the rule and whether you are signed in to the intended Google account. If you are not the owner or an authorized editor, ask the owner to add you to the allowed editors or change the protection. Do not assume that selecting the cell or requesting access from a warning dialog changes its permissions automatically.

The rule seems to have disappeared. Reopen the protection sidebar and inspect its list of rules; it may be collapsed, attached to a different sheet, or named with a description you do not recognize. Confirm that the spreadsheet has finished saving and that you are not working in an offline or stale browser tab. Reload only after checking for unsaved edits.

Frequently Asked Questions

Can I lock cells for everyone except myself?
Yes. Create a range protection rule, choose Restrict who can edit this range, and select Only you if that option is available. If the sheet is shared, verify the rule with an account that should not be able to edit.

Can I protect several separate cell ranges at once?
Create a protection rule for each separate range. For example, if B2:B10 and D2:D10 should be protected but column C should stay open, add a rule for each protected range and check both entries in the sidebar.

Can I lock cells but let people edit the rest of the sheet?
Yes. Protect only the specific ranges that should not be changed. Cells outside those ranges remain editable according to the collaborator’s general spreadsheet access, unless a separate sheet-level or range rule restricts them.

Does protecting a range hide its contents?
No. Protection controls editing, not visibility. People who can view the spreadsheet may still see protected cells, so use sharing controls or remove sensitive content if it should not be accessible.

Can I add a password to a protected range?
No. Google Sheets uses account-based permissions for protected ranges rather than a separate cell password. Choose permitted editors in the protection settings and manage who can access the spreadsheet through its sharing controls.

Can I protect cells in the Google Sheets mobile app?
The steps here use the desktop browser interface, where the full range-protection sidebar is available. If the option is missing or difficult to manage on mobile, 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.