To lock cells in Google Sheets, select the cells, then choose Data > Protect sheets and ranges. In the side panel, add the range, click Set permissions, and choose who may edit it. This restricts changes to the selected cells; it does not make the spreadsheet private or prevent people from viewing it.
What locking cells means in Google Sheets
Google Sheets calls this feature protecting a range or sheet. A protected range is an editing restriction: people who can otherwise edit the spreadsheet may be blocked from changing that area, depending on the permissions you set. You can use it to safeguard formulas, headings, reference data, or a finished section while leaving other cells open for input.
Protection is not the same as changing a person’s access to the entire file. Someone with Viewer access cannot edit the spreadsheet at all, while an Editor can normally change unprotected cells. A protected range adds a narrower restriction for particular cells. It also is not a password lock: Google Sheets does not offer a password that conceals a protected range from people who can open the file.
How to protect a selected range
- Open the spreadsheet in Google Sheets in a web browser. Select the cells you want to restrict, such as B2:D20. You can select a whole column or row as well.
- Choose Data > Protect sheets and ranges. A panel opens on the right.
- Click Add a sheet or range. If the selected cells did not populate the range field, enter the range using sheet-and-cell notation, such as Responses!B2:D20.
- Check the range shown in the panel. You can enter a description to help identify why the area is protected, then click Set permissions.
- Choose Restrict who can edit this range. Select Only you or choose a custom list of permitted editors, then save the setting.
Afterward, an editor who is not permitted to change the range should be prevented from editing it. They may see a notification that the cell is protected. If you choose the warning option instead of restricting editors, people can still proceed with an edit after seeing the warning; that option is a reminder, not a lock.
Protect a whole sheet but leave some cells open
If most of a tab should be read-only but a few cells are meant for data entry, protect the sheet and specify exceptions. This is useful for a form-like layout: you might protect a quotation worksheet while leaving the quantity and customer-name fields editable.
- Open Data > Protect sheets and ranges, then click Add a sheet or range.
- Choose the Sheet option in the side panel and select the tab you want to protect.
- Use Except certain cells to identify cells that should remain editable, if that option is shown for the selected sheet.
- Click Set permissions and choose who can edit the protected sheet.
Check the exceptions carefully before saving. An exception is deliberately left outside the protection, so editors may be able to change it. If the goal is instead to lock just a few cells and leave the rest of the tab editable, protect those specific cells as a range rather than protecting the whole sheet.
Choose who can edit the protected cells
The permission setting determines whether protection is a real restriction or only a prompt. For a firm editing boundary, choose Restrict who can edit this range, then allow only the people who need to maintain it. The exact choices depend on the account and file permissions; Google Sheets may let you select yourself or specify particular editors. The spreadsheet owner retains control of the file and its protections.
- Only you: Use this for a small area that only you should maintain, such as a calculation formula or a master list.
- Custom editors: Use this when a manager or teammate also needs to update the protected content. Confirm that the intended people are included.
- Show a warning when editing this range: Use this when changes should be discouraged but not blocked. Editors can dismiss the warning and continue.
Protection does not grant someone file access. If a person needs to work in the spreadsheet but cannot open it, adjust the file’s sharing access separately. Conversely, if you need to stop someone from editing any part of the file, changing that person’s general access from Editor to Viewer or Commenter is more appropriate than protecting every range.
Practical examples for a shared spreadsheet
Consider a project tracker where teammates enter status updates in columns C and D, while column E contains a formula that calculates days remaining. You could protect the formula cells in E2:E100 and allow the team to edit the status fields. If the sheet has headers in row 1, protect that row too so the labels do not get overwritten.
For a budget template, you might protect cells containing formulas and assumptions, then leave clearly marked input cells open. For a shared inventory list, you might protect product IDs while allowing staff to update quantities. In each case, select only the cells that need protection and test the result with an appropriate collaborator account if the workflow is important. A protection rule can be correct technically but still inconvenient if it covers cells people need for routine work.
Use a descriptive name for each protected area, such as “Calculation formulas” or “Do not edit: item codes.” Descriptions make it easier to understand the purpose of a rule later, especially when a sheet has several protected ranges. Keep a simple note of which roles are allowed to edit each important area if the spreadsheet is maintained by a team.
Common problems and how to fix them
- The cells are still editable: Reopen the protection panel and check whether the rule is set to restrict editing or merely show a warning. Also confirm that you protected the intended range and did not leave those cells in the exceptions.
- The wrong cells are blocked: Review the range notation in the side panel. For example, B2:D20 covers columns B through D and rows 2 through 20; it does not include the header row.
- A collaborator can still make changes: Check whether that person is allowed to edit the protected range, or has ownership or other authority over the spreadsheet. Also confirm they are editing the same tab and file where the rule was created.
- You cannot find the protection menu: Make sure the file is open as a Google Sheets spreadsheet and that your account has sufficient editing access. If you have only Viewer or Commenter access, ask the owner to add or change the protection.
- The protection panel has several rules: Select each rule and inspect its range and permissions. Overlapping protections can make a sheet confusing to administer, so remove obsolete rules only after checking that they are no longer needed.
If the menus look different, verify that you are using Google Sheets in a browser and not viewing an Excel file in another application. Google may adjust interface labels over time, but the protection feature is found under Data > Protect sheets and ranges in Sheets.
What protection does not do
Protected ranges are intended to prevent accidental or unauthorized edits within a shared spreadsheet, not to secure confidential information. They do not hide the protected cells, encrypt their contents for selected collaborators, or stop an editor from seeing formulas and values. People who can access the file may also be able to copy information or make another copy, depending on their access and the file’s settings.
If data must not be visible to a person, do not rely on hiding a tab or protecting its cells. Limit access to the file itself, or keep sensitive information in a separate spreadsheet shared only with the people who should see it. Hiding a sheet is a convenience for organizing a workbook, not a substitute for access control.
Protection is also not a substitute for a backup or change-management process. For important business records, keep appropriate copies and use Google Sheets’ version history to review or restore earlier changes when needed. A protected formula can reduce accidental edits, but it cannot prevent every kind of data loss or guarantee that a shared workflow is error-free.
When to use file sharing or another approach
Choose the simplest control that matches the task. Use range protection when people should edit the spreadsheet but not particular cells. Use sheet protection when an entire tab should be protected except for designated input areas. Change the file’s sharing role when someone should not be able to edit the spreadsheet at all. Keep private information in a separate file with restricted sharing when collaborators should not see it.
Google Sheets protections are configured inside Sheets and are not identical to Excel’s worksheet-protection features. If you download or convert a spreadsheet to another format, check how its protections and sharing behavior are represented rather than assuming the same restrictions carry over unchanged. For a workflow that moves between applications, test a copy of the file and verify both what collaborators can edit and what they can view.
Frequently Asked Questions
Can I lock only certain cells in Google Sheets?
Yes. Select the cells, open Data > Protect sheets and ranges, add the range, and set its permissions. Other cells remain available to editors unless you protect the whole sheet too.
Can I lock a sheet but let people edit a few cells?
Yes. Add a sheet protection rule, choose the sheet, and use Except certain cells to identify the areas that should remain editable. Set permissions for the rest of the sheet.
Can I protect cells with a password?
No. Google Sheets range and sheet protection uses account-based editing permissions rather than a password. It does not hide protected content from people who can view the file.
Why can someone still edit a protected cell?
The rule may be set to show a warning rather than restrict editing, the person may be permitted to edit that range, or the cell may be outside the protected area or included as an exception. Review the protection rule and its range.
Can I prevent someone from seeing a protected range?
No. Protection restricts editing; it does not conceal the range. To keep information private, restrict access to the file or store the sensitive data in a separate file with limited sharing.