How to View Protected Ranges in Google Sheets

To view protected ranges in Google Sheets, open the spreadsheet in a web browser, choose Data > Protect sheets and ranges, then select a protection in the side panel. You can inspect which cells or sheet are protected and, if you have suitable access, review the editing rule. Protected ranges control editing; they do not hide the cell contents.

What You’ll Need

A web browser and access to the Google Sheets file. The steps below are for the desktop web version; the menus may differ in the mobile app.
Ideally, Editor access. You can usually view the spreadsheet’s contents with other roles, but people with Viewer or Commenter access may not be able to open or inspect protection settings. If the file is shared with you by an organization, its sharing policies may also limit what you can do.
The correct spreadsheet. Protections apply to a particular file, so make sure you have opened the intended copy rather than a downloaded Excel file or duplicate.

Step-by-Step

Open the spreadsheet in Google Sheets. Go to sheets.google.com or open the file from Google Drive, and sign in to the Google account that has access. If the workbook is open in a preview or in Excel, open it in Google Sheets instead; Google Sheets protection settings are not managed through Excel’s menus.
Open the protection panel. From the menu bar, choose Data > Protect sheets and ranges. A panel called Protected sheets & ranges should open on the right. You do not need to select a cell first. If the panel is already open, use it to review the protections currently listed for the spreadsheet.
Choose an existing protection. Select an entry in the panel’s list to see its details. The entry may identify a cell range, such as B2:D20, or a whole sheet. The selected item’s details show the sheet name and range or sheet-level scope. If there are several entries, inspect them one at a time; each entry is a separate protection rule.
Read the scope carefully. A range protection applies to the cells named in its range field, while a sheet protection applies to a sheet tab. Check both the tab name and the cell references. For example, a rule for Sheet1!B2:D20 does not apply to the same cells on another tab. A protected sheet can also have exceptions: cells that remain editable even though the rest of that sheet is protected.
Check any sheet exceptions. If the selected item protects a sheet, look for an option indicating that certain cells are excepted from the protection. When exceptions are configured, review the listed ranges as well as the main sheet setting. This matters when a team says a sheet is protected but particular input cells are still editable. A range protection by itself does not mean that the rest of the sheet is protected.
Review the editing rule, if available. Protection settings can either show a warning when someone edits the area or restrict who can edit it. If the panel offers a permissions control, open it only to inspect the choice and the listed people or groups. Do not change the selection or confirm changes if your goal is only to view the rule. The available details and controls depend on your access and on the current Sheets interface.
Inspect other entries and close the panel. Select each protection you need to check, noting its scope and any exceptions. When finished, close the panel with its close control. If you are checking a particular cell, compare its sheet tab and address with the rules you reviewed. Remember that more than one protection may affect different portions of the same sheet.

Google Sheets does not provide a single permanent on-screen overlay that marks every protected cell. The protection panel is the main place to inspect existing rules. If you need to identify a specific cell, compare its address against the ranges in the panel and check sheet-level rules and exceptions too.

Common Mistakes

Looking in the wrong menu. Protection settings are under Data > Protect sheets and ranges, not under the Format menu. Format contains options such as conditional formatting, which can change how cells look but does not prevent editing.
Confusing protection with hidden content. A protected range does not conceal its values or make them private. People who can view the spreadsheet may still see the cells. Do not use sheet protection to store passwords, confidential records, or information that should not be shared.
Assuming a protected sheet has no editable cells. Sheet protection can allow exceptions, and a separate range rule may cover only a portion of a sheet. Check the full set of listed rules and exceptions before concluding that a cell should be locked.
Reading the range without its sheet name. Cell references such as A1:C10 are meaningful only on the relevant tab. Confirm the sheet name as well as the address, especially when different tabs use similar layouts.
Changing settings while trying to inspect them. Opening a permissions control can lead to editable settings. If you only need to view, avoid changing the protection type, range, exception cells, or authorized editors, and do not apply or confirm an edit.

Tips

Use a small checklist. For each rule, record the sheet tab, the range or whole-sheet scope, whether exceptions exist, and whether the rule warns or restricts editing. This makes it easier to compare the setup with a colleague’s report.
Check both sides of an unexpected edit problem. If someone can edit a cell, verify whether the cell falls within a protected range, whether its sheet is protected, and whether it is listed as an exception. Then check whether the rule merely displays a warning instead of blocking edits.
Ask the owner for clarification when access is limited. If the panel is missing or permission details are unavailable, ask the file owner or an editor with appropriate access to confirm the rule. You may be able to view the sheet’s contents without being allowed to manage its protections.
Keep a note of the exact address. In a large sheet, a cell address and tab name are more useful than a description such as “the totals area.” If you are reporting a problem, include both, along with what you expected to be protected.
Know the Excel difference. Excel uses its own worksheet protection controls, commonly found on the Review tab, and those settings are not the same as Google Sheets’ protection panel. A file opened or converted between programs may need its protection rules checked in the program where it will be edited.

Troubleshooting

The menu item is missing or unavailable. Confirm that you opened the file in Google Sheets, not a preview or another spreadsheet app. If it still is not available, your account may have Viewer or Commenter access, or an organization policy may limit access. Ask the owner to check the protections or provide the access level you need.
The panel opens but shows no protections. Verify that you are in the correct file and account, then refresh the browser tab and open the panel again. Make sure you are not looking at a different copy of the spreadsheet. If the file was recently edited or shared, ask an editor whether the rules were removed or whether you have opened a version that does not include them.
You cannot tell which rule covers a cell. Note the cell’s sheet tab and address, then compare both with each listed range. Also inspect any whole-sheet protection and its exceptions. A range that looks similar may belong to another tab, and a cell excluded from sheet protection may still be covered by a separate range rule.
The person can still edit a protected area. Check whether the rule is set to show a warning rather than restrict editing. If it is a restriction, confirm that the person is not included among the editors allowed by the rule and that the cell is not an exception. Changes should be made only by someone authorized to manage the spreadsheet; ask the owner if you only have viewing access.
You are asked to request access. Use Google’s access request option or contact the file owner directly. Explain whether you need to inspect protection settings or edit the sheet, since those are different needs. Do not try to work around a restriction by copying data to another file unless you have permission to do so.

Frequently Asked Questions

Can I view protected ranges without editing the spreadsheet?
It depends on your sharing role and the file’s settings. Viewers can see content but may not be able to open the protection panel or inspect permissions. Ask an editor or owner to confirm a rule if the panel is unavailable.

Can I see protected cells highlighted on the sheet?
Google Sheets does not generally show every protected cell as a persistent colored overlay. Use Data > Protect sheets and ranges and compare each listed range with the cell addresses you want to check.

Does a protected range hide its contents from viewers?
No. Protection controls who can edit, not who can see the data. Use sharing permissions to control who can open the file, and do not put sensitive information in a sheet shared with people who should not see it.

Can I see who is allowed to edit a protected range?
If you have enough access, select the protection and inspect its permission settings. The rule may restrict editing to particular people or show a warning instead. You may need the owner or an authorized editor to confirm the details.

What if the protection panel lists a sheet but not the cell I am checking?
Check the sheet’s exceptions and review any separate range protections. Confirm that you have selected the same sheet tab as the cell. A whole-sheet rule may also have editable exceptions, so the main sheet entry alone may not explain the cell’s behavior.

Is viewing a protected range different in Excel?
Yes. Excel has separate worksheet and workbook protection features, usually accessed from the Review tab. Google Sheets’ Data menu and protection panel apply to Sheets; inspect the file in the app where the protection is being used.

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.