Protect Range Not Showing in Google Sheets? Try These Fixes

If Protect sheets and ranges is missing in Google Sheets, first check that you have editor access and that the file is a native Google Sheets spreadsheet, not an Excel file being edited in Office compatibility mode. In a desktop browser, open the spreadsheet and look under Data > Protect sheets and ranges; if that option is unavailable, the checks below explain why and what to do next.

Where the protection command appears

Google Sheets puts range and sheet protection in the Data menu. In a browser on a computer, open the spreadsheet, select Data > Protect sheets and ranges, and use the sidebar that opens on the right. Depending on the interface and what you are protecting, the sidebar may offer an option to add a sheet or range, or you can select cells first and then open the command.

To protect a particular block of cells, select it before opening the protection sidebar. For example, selecting B2:B20 and then adding a range protection should identify that range in the sidebar. You can also enter or revise a range reference there. To protect a whole tab, choose the sheet option instead. The sidebar is where you name the rule, review its scope, and set who may edit it.

If you are following instructions written for a different version of the interface, look for the menu path rather than a toolbar button. Protection is not normally a separate padlock button in the standard Sheets toolbar. The menu is also distinct from Data validation: validation can limit which values people enter, but it does not prevent an editor from changing or deleting cells.

Check your access to the spreadsheet

A missing command often means your sharing role does not permit you to change the spreadsheet’s structure or protection rules. Viewers and commenters can look at or comment on a file, but they cannot create or manage protected ranges. Ask the owner to check your role in the Share dialog. If you need to set protections yourself, you generally need editor access, subject to any organization or file restrictions.

Having edit access to some cells does not necessarily mean you can change the protection setup. An existing rule may prevent you from editing a cell, while the overall file-sharing role controls whether you can manage the rule. If you are an editor but cannot change a particular protected area, open the protection sidebar and review the rule’s permissions. The owner may have restricted editing to specific people or groups.

For a work or school account, an administrator’s policies or shared-drive settings can also affect what you can do with a file. If the menu is absent despite confirmed editor access and a native Sheets file, ask the owner or your Workspace administrator whether the file’s location or organization settings are limiting changes. Avoid making a copy as a first fix if the original’s owner needs the protection to remain in place; a copy has its own sharing and protection settings.

Make sure the file is really a Google Sheets file

Google Sheets can open Microsoft Excel files, including .xlsx files, in Office editing mode. Those files can look much like ordinary Sheets documents, but some Sheets-only features may not be available until you convert the file. If the filename or File menu indicates that you are editing an Excel file, use File > Save as Google Sheets to create a Google Sheets version, then check Data > Protect sheets and ranges in the converted file.

Conversion creates a Sheets copy; it does not simply change the original Excel file in place. Review the converted document before relying on it, particularly if it contains complex formatting, macros, or features specific to Excel. If you must keep working in Excel format, use Excel’s own worksheet or workbook protection features in Excel rather than assuming that Sheets protection rules will carry over as expected.

This distinction is easy to miss because the document may open from Google Drive and be displayed in the Sheets interface. The file extension and the available commands are useful clues. If the protection command is missing, verify the file type before spending time changing browser settings or reinstalling anything.

Set up a protected range once the menu appears

When you have editor access and a native Sheets file, use the sidebar to define the protection deliberately. A typical range setup looks like this:

Select the cells to protect, such as C2:C50, or choose the sheet option if the whole tab needs protection.
Open Data > Protect sheets and ranges. Check that the range or sheet shown in the sidebar is the area you intended.
Give the protection a clear description, such as Formula cells or Approved inputs. A useful name makes it easier to identify the rule later.
Choose Set permissions and decide whether the rule should show a warning or restrict who can edit.
If you restrict editing, select the permitted editors and confirm the setting. Reopen the sidebar afterward to verify that the protection is listed as expected.

For example, a shared budget might leave the expense-entry cells in B2:B30 editable while protecting formula totals in C2:C30. Protecting the formulas can reduce accidental changes, but it does not make the budget confidential. Collaborators who can access the file may still be able to view its contents, and protection is not a substitute for careful sharing permissions.

Warning-only rules and restricted editing are different

Google Sheets offers two practical approaches that are easy to confuse. A warning-only protection displays a warning when someone tries to edit the range, but it does not block an editor who chooses to continue. It is useful when you want to discourage casual changes without stopping collaborators from working.

A restricted protection limits which users can edit the selected range or sheet. This is more useful for preserving formulas or a template layout. However, it is not a password lock or a confidentiality control. People who can view the spreadsheet can see the protected data, and editors with sufficient rights may be able to change protection settings. Use the Share dialog to control who can access the file at all.

Protection also does not automatically protect every nearby cell. If a formula is in C2 and the rule covers only C3:C20, C2 is not protected by that rule. Check the selected range carefully, especially when rows are inserted, formulas are copied, or the sheet is reorganized. A named description helps, but the actual range and permission settings determine what the rule does.

Common troubleshooting checks

If the command still does not appear, work through the problem in a sensible order instead of assuming the browser is broken:

Confirm the role: Check that you are an editor, not a viewer or commenter. If the owner manages the file, ask them to verify your access.
Check the file format: Look for an Excel file being edited in compatibility mode. Convert it with File > Save as Google Sheets if a native Sheets copy is appropriate.
Use a desktop browser: The full protection workflow is easiest to find and manage in Google Sheets on a computer. If you are using a phone or tablet, open the file in a desktop browser to check the menu and sidebar.
Open the right menu: Look under Data, not Format, and make sure you are in the spreadsheet rather than viewing a downloaded or exported copy.
Refresh and retry: Reload the page, confirm you are signed in to the account that has access, and reopen the file from Drive. If possible, try a current supported browser or a private window to rule out a stale page or extension interference.
Ask about shared-drive or organization rules: If the file is managed by an employer or school, ask its owner or administrator whether restrictions apply.

If the menu opens but a cell remains editable, inspect the specific rule in the sidebar. Make sure the selected range includes that cell, the rule is set to restrict editing rather than merely show a warning, and the user testing it is not on the allowed-editor list. Also confirm that the cell is not outside the protected area because of a mistaken range reference.

Google Sheets protection compared with Excel protection

Both Google Sheets and Excel can protect sheets or selected cells to reduce unwanted edits, but their controls and file behavior are not interchangeable. In Sheets, the relevant interface is Data > Protect sheets and ranges, with permissions managed through the sidebar. In Excel for Microsoft 365 on Windows, sheet protection is managed through the Review tab and Protect Sheet; the exact options differ from Google Sheets.

If a workbook moves between the two programs, do not assume that every protection rule will transfer with identical behavior. Excel has its own workbook and worksheet protection options, while Sheets uses its own sharing roles and protected-range controls. If collaborators use both applications, agree on which file is authoritative and test the workflow on a copy before relying on protection in a live shared document.

Alternatives and sensible limits

If you cannot obtain permission to manage protections, ask the owner to set the rule, or ask them to make you an editor if that is appropriate. For a simple reminder, a note in the sheet or a warning-only rule may be enough. If the goal is to stop people from seeing information, do not rely on hiding a tab or protecting cells: restrict access to the file itself, or keep sensitive data in a separate file shared only with the intended people.

For a form-like workflow, Google Forms can collect responses without giving respondents direct editing access to the spreadsheet that stores them. For collaborators who need to enter data into a shared sheet, consider clearly labeling input cells and protecting calculation areas. These approaches reduce accidental edits while matching the level of control to the actual task.

Frequently Asked Questions

Why can I see the spreadsheet but not Protect sheets and ranges?

You may have viewer or commenter access, or you may be opening an Excel file in Office editing mode. Confirm your role with the owner and check whether the file is a native Google Sheets document.

Can I protect a range in the Google Sheets mobile app?

The full setup and permission workflow is clearest in Sheets on a computer. If you cannot find or manage the protection controls on a phone or tablet, open the spreadsheet in a desktop browser and use Data > Protect sheets and ranges.

Does protected range mean nobody can change the cells?

Not necessarily. A warning-only rule allows a user to continue after seeing a warning. A restricted rule limits editing to permitted people, but it is not a security barrier for confidential information or a replacement for file-sharing controls.

Why is a cell still editable after I protected the sheet?

Check whether the rule covers that cell, whether you chose restricted editing rather than a warning, and whether the person testing the rule is allowed to edit. Review the range and permissions in the protection sidebar.

Will a protected range work in an Excel file?

Sheets protection is intended for Google Sheets documents. If the file is an Excel workbook, convert it using File > Save as Google Sheets to use Sheets controls, or manage worksheet protection in Excel if the file must remain an Excel workbook.

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.