How to See Protected Ranges in Google Sheets Online

To see protected ranges in Google Sheets, open the spreadsheet in a web browser and choose Data > Protect sheets and ranges. The side panel lists the sheet and range protections you can inspect. Select an entry to check its location, description, and editing permissions. You generally need edit access to view protection settings; viewers may be able to see a cell but not the rule that protects it.

What You’ll Need

A Google account with access to the spreadsheet. To inspect the protection settings, you will generally need permission to edit the file.
A desktop web browser, such as Chrome, with the spreadsheet open in Google Sheets. The steps below use the browser interface, not the mobile app.
If the file is shared with you, the correct account and, if applicable, access through your work or school organization.

You do not need to change any protections just to view them. If your goal is only to find out why a cell will not accept edits, the protection panel can show whether a range or entire sheet has restrictions. Avoid changing permissions while investigating unless you are authorized to do so.

Step-by-Step

Open the correct spreadsheet. Go to Google Sheets in your browser and open the file where you want to check protections. If you have several tabs or similarly named copies open, confirm the file name at the top before proceeding. A protection rule applies to the specific spreadsheet you opened, not automatically to other copies of it.
Open the protection panel. In the menu bar, select Data > Protect sheets and ranges. A panel opens on the right side of the screen. If the panel is narrow, you can widen the browser window or zoom out slightly so the list and settings are easier to read. This menu is the place to inspect protections; named ranges, filters, and conditional formatting are separate features.
Review the list of protections. Look through the entries in the side panel. Each entry represents a protected sheet or a protected range, and may include a description chosen by the person who created it. A sheet-level rule protects a whole tab, while a range-level rule applies to selected cells. Do not assume that a short or blank description identifies the cells; use the entry’s range details to confirm its scope.
Select an entry to inspect it. Click a protection in the list to display its settings. For a range, check the address shown in the panel, such as B2:D12 or Sheet2!A:A. For a sheet protection, check the sheet name and whether exceptions are listed. Selecting an entry may also take you to or outline its location in the grid, depending on the current interface and the size of the sheet. Treat the address in the panel as the more reliable reference.
Check whether the protection is a range or a whole sheet. A protected range covers only the specified cells. A protected sheet applies to a tab but may allow particular cells to remain editable as exceptions. If you are looking for one locked cell, inspect both the range entries and sheet-level entries; a sheet rule with exceptions can explain why some cells in the same tab behave differently.
Read the editor permissions without changing them. Look for the controls that specify who can edit the protected area. Depending on the rule, editing may be limited to particular people, or the protection may be configured to show a warning rather than block edits. You can inspect these settings without saving a change. Do not click a control such as Change permissions or confirm an edit unless you intend and are allowed to modify the rule.
Close the panel when you are done. Use the panel’s close button or select another part of the spreadsheet. Closing it does not remove a protection. If you need to report the rule to the owner, note the tab name, cell address, description, and the message you saw when trying to edit. Sharing those details is more useful than saying only that the sheet is locked.

For example, if a teammate cannot edit cell C7, open the panel and look for a range that includes C7, such as C5:C10, as well as a sheet-level protection on that tab. If an entry protects the whole sheet but lists C7 as an exception, that exception is likely relevant. If no listed rule covers C7, the cause may instead be that the file is view-only, the wrong account is signed in, or the cell is being affected by another feature.

These instructions are for Google Sheets in a web browser. Excel has separate sheet-protection controls and does not use Google Sheets’ Protect sheets and ranges side panel, so its menus and permissions will not match these steps.

Common Mistakes

Looking in the wrong menu. Protection settings are under Data > Protect sheets and ranges, not under Format, Share, or the tab’s right-click menu. Sharing controls govern access to the file; protection rules govern editing of selected cells or a sheet within it.
Assuming a protected cell is hidden. Protection is an editing restriction, not a way to conceal data. A person who can view the spreadsheet may still be able to see protected cell contents. Do not use protection as a substitute for restricting file access or removing sensitive information.
Confusing a warning with a lock. Some protection rules warn users before they edit rather than prevent editing. A warning dialog does not necessarily mean the range is restricted to other people. Read the rule’s permissions and the message on screen before concluding that a user is blocked.
Checking only the cell’s range. A whole-sheet rule can affect a cell even when the cell is not shown as a separate range entry. Conversely, a protected sheet can have exceptions that are editable. Inspect both kinds of entry if the behavior seems inconsistent.
Mixing up protection and visibility. A hidden tab, a filter view, or a collapsed group is not the same as a protected range. A tab can be hidden without being protected, and a protected tab can remain visible. Check the exact feature that matches what you see.
Trying to inspect a copy instead of the shared original. Downloaded files, exported copies, and spreadsheets made with File > Make a copy may not reflect the current rules in the source document. Confirm that you are examining the live file where the editing problem occurs.

Tips

Search by address, not by description alone. Descriptions are optional and may be vague. Compare the address in each range entry with the cell you are investigating. For a column-wide rule, check whether the address uses a full-column reference such as A:A.
Check the tab name carefully. A range address can belong to a different sheet tab than the one you are currently viewing. If you find a relevant entry, confirm its sheet name before deciding that it explains the issue.
Keep a record before asking for help. Note the exact tab, cell or range, protection description, and whether the rule names specific editors. You can also tell the owner whether you see a warning or an access-denied message. This helps them review the right rule without granting broader access unnecessarily.
Use the panel as an inventory, not as a security audit. It helps identify editing restrictions in the current spreadsheet, but it does not prove that confidential data is hidden. Share the file only with appropriate people, and ask the owner or administrator about access if the data itself should not be visible.
Do not remove a rule just to test it. Changing a protection can affect collaborators and may allow edits that were intentionally restricted. If you are not the owner or responsible editor, ask the person who manages the sheet to confirm the rule or make an authorized change.

Troubleshooting

The menu item is missing or unavailable. Confirm that the spreadsheet is open in Google Sheets in a browser and that you are signed in to the account that was granted access. If you have view-only or comment-only access, you may not be able to open or inspect protection settings. Ask the owner for edit access if appropriate, or ask them to check the protection panel and share the relevant details. A work or school account may also be subject to organization policies.

The panel opens, but you do not see an entry for the cell. Check for a whole-sheet protection, including any exceptions, and verify that you are looking at the correct tab. Then confirm that you are in the original shared spreadsheet. If no protection covers the cell, the problem may be a file-level role (for example, viewer access), a formula or data-validation rule, or an issue with the account you are using. The protection panel only lists protections; it does not diagnose every reason a cell might not be editable.

You can see the list but cannot change a rule. Viewing a rule and having authority to edit it are not the same thing. The file owner or another authorized editor may control the protection, and a protected range can limit which collaborators are allowed to edit its cells. Ask the owner to make the change or grant the appropriate permission. Do not try to work around the rule by copying data into another file unless you have permission to do so.

The panel seems to point to a different place. Read the full range address, including the sheet name, and compare it with the selected tab. A range such as A2:A20 does not identify a unique location by itself if the entry belongs to another sheet. If the grid does not visibly mark the area, use the address shown in the panel to locate the cells, or ask an editor to confirm the range. Large or off-screen ranges may not be obvious at the current zoom level.

You are using a phone or tablet. The Google Sheets mobile app may have a different interface and may not expose all protection-management controls. Open the spreadsheet in a desktop browser and use the menu path above. If you cannot access a computer, ask an authorized editor to inspect the rule and send you the range and permission details.

Frequently Asked Questions

Can I see protected ranges if I only have view access?
Usually, the protection-management panel requires edit access. A viewer can still see cells that are visible in the spreadsheet, but may not be able to inspect the rule or its editor list. Ask the owner to check the settings if you need to know why editing is restricted.

Does seeing a protected range mean I can edit it?
No. Seeing a rule in the panel does not grant permission to change the cells or the rule. The protection may allow edits only by selected people, or the spreadsheet itself may be view-only for you.

Can protected ranges hide information from other collaborators?
No. Google Sheets range protection is intended to limit edits, not to conceal cell contents. Use file-sharing permissions to control who can view a spreadsheet, and do not put information in it if people with access to the file should not see it.

Why can I edit a cell on a protected sheet?
The sheet may have exceptions that leave particular cells or ranges editable. The rule may also be set to warn rather than block edits, or you may have permission as an allowed editor. Inspect the sheet entry and its exceptions and permission settings.

Can I see who created a protection?
The protection panel may show its description and who is allowed to edit, but it may not provide a clear creator field for every rule. If you need to identify who set it up, ask the spreadsheet owner or check your organization’s available document history and administration tools.

Is a protected range the same as a named range?
No. A named range gives a set of cells a label for easier reference; it does not, by itself, stop people from editing those cells. Use Data > Protect sheets and ranges to inspect editing protections.

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.