Unlock Cells in Google Sheets: Edit Protected Ranges

To unlock a protected cell in Google Sheets, open the spreadsheet in a browser and choose Data > Protect sheets and ranges. Select the protection in the side panel and click the trash-can icon to remove it, if you have permission to change that protection. Removing protection makes the cells editable; it does not erase their contents.

What it means to unlock a cell in Google Sheets

Google Sheets does not use the same locked and unlocked cell setting found in Excel. In a new Sheet, cells are generally available for editing to people who have edit access to the spreadsheet. To prevent changes, someone adds protection to a whole sheet or a selected range. So when people ask how to unlock a cell, they usually mean removing that protection or changing its editing permissions.

Protection is useful when a spreadsheet is shared and only some areas should be changed. For example, a team budget might let contributors enter amounts in cells B2:B20 while protecting formulas in column C. A protected range can restrict editing to particular people, or it can show a warning before someone edits it. A protected sheet can also have exceptions: selected cells that remain editable even though the rest of the sheet is protected.

Protection does not hide information or encrypt the spreadsheet. People who can view the file can generally see protected cells, and protection is not a substitute for carefully controlling who can access the file. It is an editing safeguard within a shared sheet.

Remove protection from a range or sheet

If you are authorized to manage a protection, use Google Sheets in a desktop web browser and follow these steps:

Open the spreadsheet and select Data > Protect sheets and ranges.
In the side panel, review the listed protected sheets and ranges. Select the entry that covers the cells you want to unlock.
Check its range or sheet details so you do not remove the wrong protection. A range may be shown with a sheet name and cell references, such as Sheet1!B2:B20.
Click the trash-can icon to delete that protection. Confirm if Sheets asks you to.
Close the panel and try editing one of the affected cells.

Deleting a protection removes the editing restriction, not the cell values, formulas, formatting, or the sheet itself. It also does not change the spreadsheet’s sharing access. If a person has only viewer access to the file, removing a range protection will not let that person edit; the file owner or someone with sharing privileges must change the person’s general access separately.

Be precise when choosing the entry to delete. If a whole sheet and a particular range are both protected, removing just the range protection may not be enough to make a cell editable. Check the side panel for every applicable protection rather than assuming one entry controls all restrictions.

Keep the sheet protected but make certain cells editable

Often, you do not want to remove protection completely. Instead, you want to allow edits in a small input area while keeping formulas or headings protected. If the entire sheet is protected, add exceptions for the cells that should remain editable:

Choose Data > Protect sheets and ranges.
Select the protected sheet in the side panel, or create a sheet protection if one has not been set up.
Use the option labeled Except certain cells, then enter or select the cell range that should be editable.
Review the sheet protection and its editing permissions, then save or confirm the settings shown in the panel.

For example, a teacher could protect a worksheet containing instructions and answer keys but leave D2:D30 open for student responses. In a project tracker, the owner might protect formulas and status summaries while leaving the task owner and due-date columns available for team updates. Use the narrowest practical exceptions: leaving a whole column open when only a few input cells are needed can expose more of the sheet to accidental edits.

You can also protect only the formulas or other cells that should not change, leaving the rest of the sheet editable by default. This approach can be simpler when most cells are intended for data entry. After setting it up, test the file with an appropriate account or ask a collaborator to verify that the intended cells can be edited and the protected ones cannot.

Change who can edit a protected range

You may not need to unlock the cells for everyone. To give a particular collaborator access, open Data > Protect sheets and ranges, select the relevant protection, and choose its permissions or Set permissions option. The panel lets the protection’s manager choose whether editing is restricted to specified people or whether Sheets should display a warning when someone edits the range. The exact options available can depend on the protection selected and your access to the file.

A warning is not the same as a lock. It alerts someone that the range is protected but allows the edit to proceed after the warning. A restriction is intended to prevent unauthorized collaborators from changing the protected cells. If a collaborator needs access, adding them to the allowed editors for the protection can be more suitable than removing the protection for everyone.

File sharing and range protection are separate controls. Sharing determines who can view, comment on, or edit the spreadsheet overall. A protected range narrows editing within a spreadsheet for people who otherwise have access. Check both settings when someone says they cannot edit: they may have view-only file access, or they may be an editor blocked by a specific range protection.

When you cannot unlock the cells

If the trash-can icon or permission controls are unavailable, or Sheets will not let you change the protection, you may not have the necessary authority. Ask the spreadsheet owner or the person who manages the protected range to remove it, add you as an allowed editor, or make the required exception. If you only have viewer or commenter access to the file, request editor access through the owner rather than trying to change the cell protection.

Other common causes of a failed edit include:

The wrong range was changed: Confirm the sheet tab and cell references in the protection panel, including whether a whole sheet is protected.
Another restriction still applies: A cell can be covered by a sheet-level protection as well as a separate range rule. Review the listed protections.
You are in the wrong Google account: Shared files may grant access to one account but not another. Check the account shown in the browser.
The file is view-only: Range settings cannot grant editing rights to someone who lacks edit access to the spreadsheet itself.
You are looking at a different copy: Check the file name and location, especially if someone sent a downloaded or duplicated version.

Some organizations manage access through shared drives or administrative policies. If the owner cannot resolve the issue, ask the organization’s Google Workspace administrator or the person responsible for the file. Avoid making a copy as a workaround unless that is acceptable: a copy may not retain the original sharing setup or collaborative workflow, and it does not change permissions on the original.

How to find which cells are protected

When you do not know why a cell is unavailable, open Data > Protect sheets and ranges and inspect the entries in the side panel. Selecting a protection shows the sheet or cell range it covers and, where you have access, its permission settings. This is a more reliable first check than changing formatting or repeatedly trying to type into the cell.

Protection can be hard to spot because it does not necessarily make a cell look different. A locked formula cell may look just like an editable input cell. Spreadsheet owners can make the layout clearer with labels such as Enter data here, a legend, or distinct formatting for input areas, but color alone does not enforce protection. The protection settings determine whether an edit is allowed.

Google Sheets protection compared with Excel

Excel has a cell-format setting that marks cells as locked or unlocked, typically used together with worksheet protection. Google Sheets works differently: editing restrictions are managed through protected sheets and ranges, and editable exceptions can be specified within a protected sheet. Instructions that say to open Excel’s Format Cells dialog and clear a Locked checkbox do not describe Google Sheets.

In either program, worksheet protection is mainly intended to prevent unintended changes, not to keep confidential data secret. In Google Sheets, manage file sharing separately and do not rely on range protection to conceal sensitive information. If you need a collaborator to work freely in certain cells, configure those cells or ranges explicitly and check the result before sharing the sheet more widely.

Frequently Asked Questions

Can I unlock one cell without unlocking the whole sheet?
Yes, if the sheet’s protection settings allow exceptions. Select the protected sheet under Data > Protect sheets and ranges, then use Except certain cells to specify the cell or range that should remain editable. If a separate range protection also covers that cell, review that rule too.

Can I unlock a cell if I am not the owner?
It depends on your access to the file and that protection. If you cannot change the protection or its permissions, ask the owner or protection manager to grant access or remove the restriction. Being able to view a cell does not mean you have authority to change its protection.

Does removing protection delete the data?
No. Removing a protected-range or protected-sheet rule changes who can edit the cells; it does not delete their contents. Still, check which rule you selected before confirming, because deleting the wrong protection can leave more of the sheet editable than intended.

Why can I still not edit after removing a range protection?
You may have removed a different rule, be covered by another sheet or range protection, or lack editor access to the spreadsheet itself. Check the protection panel, confirm the correct Google account, and ask the owner to review the file’s sharing settings if the problem continues.

Can protected cells be hidden from other editors?
Protection controls editing, not visibility. It is not a confidentiality feature. If someone should not see particular information, do not rely on protecting its cells; manage access to the file or keep that information in a separate file with appropriate sharing permissions.

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.