Lock Cells Together in Google Sheets: Step-by-Step

To lock cells together in Google Sheets, select the range, choose Data > Protect sheets and ranges, and set who is allowed to edit it. This protects the selected cells as one range from changes by other editors; it does not merge the cells or prevent people from viewing or copying their contents. You need edit access to set up protection, and the spreadsheet must be open in Google Sheets in a web browser.

What You’ll Need

A Google account with edit access to the spreadsheet. View-only or comment-only access is not enough to create or change protected ranges.
The Google Sheets file open in a desktop web browser. The steps below use the browser menu paths.
A clear idea of which cells should be protected and who should still be able to edit them. For example, you might protect a formula column while leaving input cells editable.

Step-by-Step

Open the spreadsheet and identify the range. Open the file in Google Sheets and note the cells you want to protect. A range such as B2:D20 is a rectangular block: it includes every cell from B2 through D20. Protection applies to the whole selected range, including any blank cells inside it. If you only want to protect formulas, check that the chosen range does not also include cells where collaborators need to enter data.
Select the cells you want to lock together. Click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. You can also use the name box to the left of the formula bar: click it, type a range such as B2:D20, and press Enter. The range should be highlighted before you continue. If your intended cells are in separate, non-adjacent areas, plan to create a separate protected range for each area rather than selecting one large block that includes unwanted cells.
Open the protection panel. With the target cells selected, choose Data > Protect sheets and ranges from the menu. The protected sheets and ranges panel opens on the right. If the panel is already open, you can create a protection from there instead. The selected range is usually filled in automatically; confirm that the range shown is correct before setting permissions.
Give the protection a useful name. In the side panel, click Add a sheet or range if you are creating a new rule. In the range option, verify or enter the cell address, then enter a description such as Locked formulas – Q1 totals. A clear label helps you find the rule later, especially when a file has several protected areas. The description is for organizing protections; it does not change which cells are protected.
Choose who can edit the range. Click Set permissions. Choose Restrict who can edit this range if you want to block edits by some collaborators. The default may be Only you, or you may be able to select a custom list of people who can edit. Pick the option that fits your workflow, review the people listed, then confirm with Done. Only grant editing permission to people who should be able to change those cells.
Check the result with an editor account if appropriate. Return to the sheet and try to change a protected cell. An editor who is not allowed to edit should see a warning or be blocked from making the change, depending on the protection setting. Do not test by changing important live data; use a copy or a harmless test cell. Owners and people who have permission to edit the protected range can still make changes.
Protect other separate areas one at a time. If you need to protect A1:A10 and C1:C10 but leave column B open, create a protection for each range. Use Data > Protect sheets and ranges, then Add a sheet or range for the next area. This makes the boundaries and permissions easier to check than protecting a larger range that also covers B.
Consider protecting a whole sheet with exceptions. If most of a tab should be read-only but a few cells should accept input, open Data > Protect sheets and ranges, choose Sheet, and select the sheet. If the option is available for that selection, enable Except certain cells and enter the cells that should remain editable. Set permissions for the sheet protection and save. Review the exceptions carefully: they are the openings in the protection, not additional locked cells.
Revisit the rule when the sheet changes. If rows or columns are added, check the protected range and its permissions in the side panel. Click an existing rule to inspect or update it. To remove a protection, select its entry in the panel and use the trash or remove control. Removing protection does not delete the cell contents; it allows editing according to the spreadsheet’s normal sharing permissions.

In Google Sheets, protection is a permission rule, not a permanent lock icon on each cell. Excel handles this differently: in desktop Excel, cells are typically marked as locked or unlocked and then the sheet is protected from the Review tab. Do not expect Excel’s cell-format locking workflow to map one-for-one to Google Sheets.

Common Mistakes

Choosing a warning instead of restricting edits. Google Sheets can display a warning when someone edits a range. A warning is not a lock: a person can acknowledge it and continue. Choose Restrict who can edit this range when the goal is to prevent unauthorized edits.
Protecting the wrong range. A mistaken address can leave important cells editable or block data entry. Check the range in the panel before confirming. For example, B2:D20 protects a three-column rectangle, not just the cells that currently contain values.
Assuming protection hides confidential information. Protected cells can still be visible to people who can view the sheet. Protection is intended to control editing, not provide privacy, encryption, or a secure way to store passwords or sensitive records.
Using one oversized range for scattered cells. Protecting A1:D20 just to cover A1:A20 and D1:D20 also restricts columns B and C. Create separate rules for separate blocks unless the entire rectangle should be protected.
Forgetting that a protected sheet may still have exceptions. If collaborators can edit some cells on a protected sheet, inspect the Except certain cells list. Those cells may have been deliberately left open.
Thinking every collaborator will be blocked, including the owner. Editors who are allowed by the rule can still edit, and spreadsheet owners retain control of the file. Protection is not a way to stop the owner from changing their own sheet.

Tips

Separate inputs from formulas. Put user-entered values in clearly marked cells and formulas in their own rows or columns. Protect the formula ranges while leaving the input ranges available to the intended editors.
Use descriptive protection names. Labels such as Do not edit – lookup formulas or Manager entry cells make it easier to audit a busy sheet than labels like Range 1.
Keep a simple map of protected areas. For a complex workbook, add a short note on an instructions tab listing protected ranges and who may edit them. Update the note when you change the protections.
Use the minimum necessary access. If only a few people need to edit a protected range, choose a custom permission list where available instead of allowing every editor. Check the selected names before saving.
Make a copy before changing protections on a critical workflow. A copy lets you check how the rules behave without disrupting a live process. Remember that copying a file may also require you to review sharing and protection settings in the new copy.
Explain the restriction to collaborators. A short note near the cells, such as Enter values in the yellow cells only, can prevent confusion. Cell color is only a visual cue; it does not apply or replace protection.

Troubleshooting

I cannot find Protect sheets and ranges. Confirm that the file is open in Google Sheets rather than a preview or another spreadsheet app. Check that you have edit access. If you only have viewer or commenter access, ask the owner or an editor with the required access to set up the protection.

The cells are still editable after I set them up. Reopen Data > Protect sheets and ranges and select the rule. Check whether it says Show a warning when editing this range; if so, change it to a restricted-editors setting. Also verify the exact range and confirm that the person testing is not included in the permitted editors. Owners and permitted editors can still edit.

A collaborator cannot edit cells that should be open. Look for a sheet-level protection that covers those cells, then inspect its Except certain cells list. Add the intended input cells as exceptions if the workflow calls for it, or adjust the range protection that overlaps them. Confirm the collaborator also has edit access to the spreadsheet itself; a protected-range exception does not upgrade a viewer to an editor.

I made a protection but cannot change the range. Select the protection in the side panel and inspect its range field and permissions. You may need edit access or ownership to modify that rule. If you do not have the necessary access, contact the file owner rather than trying to work around the restriction.

Protection stopped working as expected after I added rows. Reopen the protection panel and verify whether the new rows fall inside the saved range or sheet rule. Update the range if necessary, then test with an account that is not allowed to edit. Do not assume that a rule will automatically cover every new area added to a sheet.

Frequently Asked Questions

Can I lock several cells together as one range?
Yes. Select a contiguous block, such as B2:D20, and create one protected range. For separate blocks with gaps between them, create separate protections so the cells between them are not accidentally included.

Can I lock only some cells and leave the rest of the sheet editable?
Yes. Protect only the specific ranges that should not be changed. Alternatively, protect a whole sheet and use the exception option for cells that should remain editable. Check for overlapping rules if the result is not what you expect.

Can I protect cells with a password?
Google Sheets protected ranges use Google account permissions; they do not use a password to unlock a cell range. Share the file only with appropriate people, and do not treat range protection as a way to secure confidential information from viewers.

Can people still copy or see protected cells?
Yes. Range protection controls editing, not visibility. People who can access the sheet may still be able to view or copy data, subject to their file access and Google account permissions.

Why can I still edit a cell I protected?
You may be the owner, an editor allowed by the rule, or the setting may only show a warning. Open the protection panel, check the permission mode and allowed editors, and verify that the selected range includes that cell.

Does protection work the same way in Excel?
No. Google Sheets uses protected ranges and sheets with editor permissions. Excel’s desktop workflow generally uses locked and unlocked cell formatting together with sheet protection, so the steps and behavior differ.

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.