Locking Cells in Google Sheets: Protect Specific Ranges

To lock cells in Google Sheets, select the cells, then choose Data > Protect sheets and ranges. In the sidebar, set permissions to restrict who can edit the range; you can also protect a whole sheet or show an edit warning instead of blocking changes.

What locking cells means in Google Sheets

Google Sheets calls this feature protecting a sheet or range. It does not use a password lock on individual cells. Instead, a spreadsheet owner or editor sets rules that stop specified people from changing selected cells. This is useful for reducing accidental edits in a shared file, such as overwriting a formula or changing a carefully prepared reference table.

Protection is separate from the spreadsheet’s general sharing permissions. Someone with Viewer access cannot edit the file at all, while an Editor can normally change cells unless a protection rule applies. A protected range therefore lets a file remain editable in general while limiting changes to particular areas.

By default, cells in a new Google Sheet are not individually locked. Creating a protection rule is the step that puts an edit restriction in place. The sheet owner can still make changes, and protection should be understood as an editing control—not as a way to make data private.

Protect a selected range of cells

These instructions are for Google Sheets in a desktop web browser. First select the cells you want to protect. You can select a continuous block such as B2:D20, or use the range box above the grid to enter a range directly. Then follow these steps:

Choose Data > Protect sheets and ranges. A panel opens on the right.
Select Add a sheet or range if a new rule is not already open.
Check that the range shown in the panel is the one you intend to protect. Add a description if it will help collaborators understand the rule.
Choose Set permissions.
Select Restrict who can edit this range, then choose the permitted editors. Depending on the available options, you can choose Only you or specify people with Custom.
Choose Done to save the rule.

For example, if a shared order tracker has item names in A2:A50 and formulas calculating totals in F2:F50, protect the formula cells in F2:F50 while leaving the entry columns open to the team. Editors who are not permitted for that range will be prevented from changing its contents. If your range is wrong, reopen the protection panel and edit or remove the rule rather than assuming the displayed selection matches your intention.

Protect a sheet but leave some cells editable

When most of a tab should be read-only, protect the entire sheet instead of adding many separate range rules. Open Data > Protect sheets and ranges, choose Add a sheet or range, and select Sheet in the panel. Choose the tab you want to protect, then set the editing permissions.

You can leave designated cells open while protecting the rest. In the sheet protection settings, enable Except certain cells and specify the ranges collaborators should be allowed to edit. For example, protect a monthly report tab but leave B3:B12 open for staff to enter their figures. Check the listed exceptions carefully: a misspelled or incomplete range can leave cells editable when you intended to restrict them.

Use this arrangement when contributors need a small, clearly defined input area but should not alter headings, calculations, or layout. If people need to edit many scattered areas, separate range protections may be easier to understand and maintain than a long exceptions list.

Choose between blocking edits and showing a warning

Not every shared sheet needs a hard restriction. Google Sheets offers a warning option for a protected range. With Show a warning when editing this range, an editor is alerted before changing a cell but can proceed. The warning is a reminder, not a permission barrier, so it is suitable for discouraging casual mistakes rather than enforcing who may edit.

Choose Restrict who can edit this range when collaborators should not be able to make changes there. Choose the warning when edits are sometimes legitimate and you mainly want people to pause and check before proceeding. For a budget template, for example, you might strictly restrict cells containing formulas but use a warning for a shared assumptions section that team members may occasionally need to revise.

Consider what collaborators actually need to do before choosing. A strict rule can interrupt a workflow if the permitted-editor list is too narrow. A warning can be ignored. For important calculations, combine the right restriction with clear instructions about where people should enter data.

Who can edit protected cells?

Protection rules work within the file’s sharing setup. A person generally needs edit access to the spreadsheet before being considered as an editor for a protected range. For a restricted range, the owner can allow only themselves or choose specific permitted editors. Review the list when team membership changes, because a protection rule is not a substitute for updating the file’s overall sharing access.

People who have only viewing or commenting access do not gain editing ability because a range is unprotected. Conversely, protecting a range does not change what a person can see in the spreadsheet. If someone should not see the information at all, do not rely on cell protection; reconsider who has access to the file and whether the information belongs in a separately shared spreadsheet.

In a collaborative file, explain the rule to affected editors. A short note in the sheet or a message can identify the input cells and explain why the remaining cells are restricted. That prevents people from treating a protection notice as a broken link or a problem with their account.

What protection does not do

Protected ranges are primarily meant to prevent edits, including accidental changes. They are not encryption, password protection, or a confidentiality boundary. People who can view the spreadsheet may still be able to see protected content. Depending on their access and the file’s settings, they may also be able to make copies or otherwise reuse visible information. Do not put sensitive information in a shared sheet on the assumption that protecting its cells hides it.

Hiding a tab is not a replacement for restricting access either. A hidden sheet is a display convenience, not a secure container. If data must be confidential, limit access to the file or keep that data in a separate file shared only with the appropriate people. Also remember that the spreadsheet owner can edit protected cells.

Protection does not guarantee that a collaborator will never change the workbook’s structure or use the data elsewhere. It is best treated as one practical safeguard in a cooperative workflow. For critical files, keep suitable backups or use version history so earlier changes can be reviewed or restored if needed.

Common problems and how to fix them

The protected cells are still editable: Check whether the rule uses the warning option rather than Restrict who can edit this range. Also confirm that the correct cells and permitted editors are listed.
A collaborator cannot edit an input cell: The cell may fall inside a protected range, or it may not have been added as an exception on a protected sheet. Review the rule in the protection panel and adjust the range or permissions.
The wrong cells are restricted: Open Data > Protect sheets and ranges and inspect each rule. Edit or delete the incorrect rule, then create the intended range. Pay attention to row and column references when entering a range.
The option is missing or unavailable: Confirm that you are using Google Sheets in a browser and have sufficient editing rights. If the file is still an Excel-format file opened in Sheets, consider making a Google Sheets copy and checking the protection options there; features can differ between formats.
Someone still sees the protected information: That is expected. Protection limits editing, not visibility. Change the file’s sharing access or move the information to a separately restricted file if it should not be visible to that person.

If a protection rule was added by mistake, it can be changed or removed from the Data > Protect sheets and ranges panel. For accidental content edits, File > Version history > See version history can help you inspect earlier versions. Review the version carefully before restoring it, since restoring an older version may also undo other collaborators’ later work.

Good practices for shared spreadsheets

Make the editable areas obvious. Use labels such as Enter data below, a distinct fill color, or brief instructions near the input cells. Keep formulas and reference data in clearly identified sections, and protect those areas with rules that match the people who maintain the sheet.

Before sharing a protected workbook, test the workflow with an editor account if practical. Confirm that the intended inputs can be changed and that protected formulas cannot. This catches common issues such as an exception that is one row too short or a collaborator who needs permission to update a range.

Keep the rule set understandable. Use descriptions for protections, remove obsolete rules, and revisit custom editor lists when responsibilities change. For a sheet with many contributors, assigning a small number of owners for formulas and layout often works better than granting edit rights to every protected area.

How Google Sheets protection differs from Excel

The everyday idea is similar in Google Sheets and Excel: keep some parts of a workbook from being edited. The implementation differs. Google Sheets uses explicit protected-sheet and protected-range rules configured through Data > Protect sheets and ranges. Excel for Microsoft 365 on Windows has worksheet protection and cell formatting options, including a Locked setting that is applied when sheet protection is enabled. Do not assume that instructions or protection settings transfer exactly between the two programs.

If you download a Google Sheet as an Excel file or work with an Excel-format file in Sheets, verify the resulting permissions and behavior in the program where the file will be used. For a team that edits in both applications, agree on one format and test a copy before relying on protection rules in a live workbook.

Frequently Asked Questions

Can I lock just one cell in Google Sheets?
Yes. Select that cell and create a protected range for it through Data > Protect sheets and ranges. You can restrict who edits it or choose a warning that editors can bypass.

Can I protect cells with a password?
No. Google Sheets protection uses the file owner and editor permissions rather than a password assigned to a cell or range. Control access through sharing settings, and do not treat protection as a way to conceal data.

Can I protect a sheet but let people edit certain cells?
Yes. Add a sheet protection rule and use Except certain cells to identify the editable ranges. Check the exceptions after saving so the intended input cells—and only those cells—remain open.

Can people see protected cells?
Yes. Protection controls editing, not visibility. A viewer or editor may still see the content they have access to in the spreadsheet.

Why can someone still change a protected cell?
The range may be set to show a warning rather than restrict editing, or that person may be permitted to edit it. Check the rule, selected range, and editor list in the protection panel.

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.