excelavon

Lock Cells in Excel and Google Sheets: Step-by-Step

How-to basics · Updated November 3, 2026

Lock Cells in Excel and Google Sheets: Step-by-Step

To lock cells, first decide which cells people should still be able to edit, then protect the sheet or range. In Excel, mark editable cells as unlocked before turning on sheet protection; in Google Sheets, use Data > Protect sheets and ranges to restrict editing. These controls help prevent accidental changes, but they are not a substitute for file security.

What You’ll Need

  • An Excel workbook opened in Microsoft Excel for Microsoft 365 on Windows, or a Google spreadsheet opened in a web browser.
  • Edit permission for the file. In Excel, you also need permission to change sheet protection; in Google Sheets, you need editor access to set protections.
  • A clear idea of which cells should be editable and which should be protected. For a shared form or template, identify entry cells separately from formulas, labels, and reference data.
  • If you use Excel sheet protection, keep any password somewhere safe. A forgotten protection password can be difficult to recover. Google Sheets uses sharing permissions rather than a protection password.

Step-by-Step

  1. Choose the spreadsheet and identify the cells

    Make a copy of an important workbook or spreadsheet before changing protection. Then mark the cells that people are meant to fill in, such as an order quantity column or a form’s response fields. Also identify the cells you want to protect, such as formulas, headings, or lookup values. This small planning step helps avoid locking the whole sheet when collaborators need to enter data.

    The platforms handle locking differently. Excel stores a Locked setting on cells, but it only takes effect after you protect the worksheet. Google Sheets lets you protect a selected range or an entire sheet and then choose who can edit it.

  2. In Excel, unlock the cells that should remain editable

    Open the worksheet in Excel for Microsoft 365 on Windows and select the input cells. To choose more than one separate range, hold Ctrl while selecting each range. Press Ctrl+1 to open Format Cells, select the Protection tab, clear the Locked checkbox, and select OK. The Locked box is usually checked by default, even though the cells are not yet protected from editing.

    Leave formula cells and other cells you want protected marked as Locked. If you want to protect just one range while leaving every other cell editable, first select the whole worksheet, open Format Cells with Ctrl+1, clear Locked, and select OK. Then select the specific range to protect, open the Protection tab again, check Locked, and select OK. When you protect the sheet in a later step, the selected range will be locked while the other cells remain unlocked.

    Use this extra whole-sheet procedure only when that is your goal. For the common template setup—formulas protected and designated input cells available—simply unlock the input cells and leave the rest alone. On a Mac, use Command+1 to open Format Cells; the Protection tab and Locked checkbox serve the same purpose.

  3. Protect the worksheet in Excel

    Go to Review > Protect Sheet. In the dialog, optionally enter a password, then choose what users are allowed to do. For a typical data-entry sheet, allow users to select unlocked cells. You may also allow selection of locked cells so people can copy or inspect them, but selecting a locked cell does not let them change it while protection is active. Select other actions, such as sorting or formatting, only if collaborators need them.

    Select OK and, if you entered a password, confirm it when prompted. Try editing one unlocked input cell and one locked formula cell. The first should accept a change; Excel should block edits to the second. In Excel for Mac, use the Review tab’s Protect Sheet command; dialog labels and layout can vary slightly. In Excel for the web, protection options depend on the available interface and workbook permissions; look under Review for Manage Protection. If you do not see that command, use the desktop app.

  4. In Google Sheets, protect a particular range

    Open the spreadsheet in a browser and select the cells you want to protect. Choose Data > Protect sheets and ranges. A panel opens on the right. Confirm that the Range field shows the intended cells, and add a description if it will help other editors understand why the range is protected. Select Set permissions.

    Choose Restrict who can edit this range, then select the appropriate option, such as Only you or Custom, and follow the prompts to choose editors. Use Custom when specific collaborators should be able to change the range. Select Done to apply the setting. If the panel offers a warning-only choice, remember that a warning does not prevent an edit; it only asks the editor to confirm before proceeding.

    To leave the rest of the sheet editable, protect only the target range rather than the whole sheet. For example, select a formula column and restrict that range, while leaving response columns unprotected. Check the protected range’s boundaries carefully, especially if the sheet has a header row or if new rows will be added later.

  5. In Google Sheets, protect a whole sheet but allow exceptions

    Choose Data > Protect sheets and ranges, then use Add a sheet or range in the side panel. Select Sheet and choose the tab you want to protect. If the sheet should be protected except for input cells, use the option to exclude certain cells, enter the editable ranges, and then select Set permissions.

    Choose who can edit the protected sheet and finish with Done. This is useful for a template where most cells should stay unchanged but a few fields need responses. Confirm that the exceptions are exactly right: a typo in a range can leave a formula exposed or prevent someone from entering data where expected. Google Sheets may label protected content differently as its interface changes, but the core workflow remains in Data > Protect sheets and ranges.

  6. Check the protection from a collaborator’s point of view

    Test the result before sharing the link or asking others to use the file. In Excel, try editing a locked cell and an unlocked cell. In Google Sheets, test a protected cell and an unprotected one using an account with the intended collaborator’s access level, if possible. The file owner may have broader rights than another editor, so testing only as the owner can give a misleading impression.

    If entry cells are blocked, correct the unlocked settings in Excel or the range permissions in Sheets. If protected cells can still be edited, check that Excel sheet protection is active or that Google Sheets is set to restrict editing rather than merely show a warning. Save the file after making changes.

Common Mistakes

  • Assuming Excel’s Locked checkbox protects a cell by itself. It does not. The setting only takes effect after you use Review > Protect Sheet. If the sheet is unprotected, users can still edit locked cells.
  • Protecting an Excel sheet before unlocking its input cells. Because cells are generally marked Locked by default, this can block all data entry. Unprotect the sheet, unlock the intended input cells, and protect it again.
  • Choosing warning-only protection in Google Sheets. A warning gives editors the option to continue. Use restricted editing permissions when the goal is to prevent ordinary editors from changing the range.
  • Confusing sheet protection with file security. Excel worksheet protection is meant to limit changes, not encrypt a workbook or keep determined users from accessing its contents. Google Sheets protections likewise do not hide or encrypt data from people who can view the file.
  • Using a password as the only plan for collaboration. Excel protection passwords can be forgotten, and Google Sheets does not offer a password for each protected range. Keep a safe record of Excel passwords and use Google sharing roles to control access to the file itself.

Tips

  • Use descriptive labels such as Enter date here or Formula—do not edit near input cells. Clear instructions reduce accidental overwrites even when protection is enabled.
  • In Excel, choose permissions sparingly. Allowing formatting or row insertion may be convenient, but it also permits changes beyond entering values. Test sorting and filtering if collaborators need those actions.
  • In Google Sheets, give each protected range a useful description. When a spreadsheet has several protected areas, descriptions make the side panel easier to maintain.
  • Keep a separate, unprotected working copy if collaborators need to restructure a template. Protection settings can make routine layout changes harder for authorized editors.
  • Use file sharing settings as a second layer: give people view access when they do not need to edit anything, and limit editor access to people who need it. Cell protection does not replace choosing the right sharing role.

Troubleshooting

I can still edit a cell in Excel. Check Review > Protect Sheet. If the command is Protect Sheet rather than Unprotect Sheet, protection may not be active. If it is active, check whether the cell was accidentally unlocked through Format Cells > Protection. Remove protection, correct the Locked setting, and protect the sheet again.

I cannot type in an Excel input cell. The cell may still be marked Locked, or the sheet may have been protected before you unlocked it. Use Review > Unprotect Sheet, enter the password if requested, select the input cell, and clear Locked in Format Cells > Protection. Then protect the sheet again. If you do not know the password, ask the workbook owner; do not assume that changing the cell’s formatting will bypass protection.

A Google Sheets collaborator can still edit a protected range. Reopen Data > Protect sheets and ranges, select the relevant protection, and inspect its permissions. Make sure it is restricted to the intended people rather than set to show a warning. Also verify that the collaborator is not the file owner or otherwise included among permitted editors. Protection controls are not a way to restrict the owner.

A Google Sheets collaborator cannot edit an allowed cell. Check whether the whole sheet is protected and whether the cell is listed as an exception. Confirm the collaborator has Editor access to the file, then check for another protected range overlapping that cell. Remove or adjust the conflicting protection and test again.

The protection option is missing or unavailable. You may have view-only access, be using a different account, or be working in an Excel web interface that does not expose the same controls. Confirm the account and permissions, then ask the owner for edit access or open the Excel workbook in the desktop app. In Google Sheets, use a browser and check that the file is a Google spreadsheet rather than a read-only preview of another file type.

Frequently Asked Questions

Can I lock only certain cells in Excel?
Yes. Unlock cells that should remain editable, leave the target cells marked Locked, and protect the worksheet. If only one range should be locked while all other cells remain editable, unlock the whole worksheet first, then mark the target range Locked before protecting the sheet.

Can I lock cells in Google Sheets without protecting the whole sheet?
Yes. Select the range, choose Data > Protect sheets and ranges, and set permissions for that range. Other cells can remain editable unless they are covered by another protection.

Can I protect cells without a password?
Yes. Excel sheet protection can be turned on without entering a password, though anyone with sufficient access may then be able to remove it. Google Sheets uses editor permissions for protected areas rather than a range password.

Does locking cells stop people from seeing the data?
No. Cell protection is about editing, not hiding or encrypting information. If someone should not see the data, do not share the file or sheet with that person; use the platform’s access controls instead.

Can people copy cells that are locked?
Often they can still select or copy protected content, depending on the platform and settings. Excel’s Protect Sheet options include whether users may select locked cells. Do not rely on cell protection to prevent copying or disclosure.

Will protection automatically cover new rows?
Do not assume that it will. Check the protected range after adding rows or changing the sheet layout, especially in Google Sheets where a range is defined by its selected boundaries. In Excel, review the relevant cells’ Locked settings and keep sheet protection enabled.

Related

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.