Excel Protect Sheet with Some Cells Editable: How It Works

To protect an Excel sheet while leaving certain fields editable, unlock those cells first, then choose Review > Protect Sheet. Excel locks cells by default, but that setting only prevents changes after you turn on sheet protection.

How cell locking and sheet protection work

Excel separates a cell’s Locked property from the act of protecting a worksheet. Most cells start with Locked turned on, but that property has no practical effect while the sheet is unprotected. Once you protect the sheet, Excel blocks edits to locked cells and permits edits to unlocked cells, subject to the options you allow.

This two-part design is useful for forms and templates. You can protect headings, calculations, and instructions while leaving designated entry cells available. For example, a budget worksheet might let someone enter department names and monthly amounts without letting them replace the total formulas or change the layout.

Protection applies to a worksheet, not automatically to every sheet in the workbook. You can configure each sheet separately. Cell protection settings also travel with the cells when they are copied within a workbook, so review the settings if you reuse or move a form.

Unlock the fields people should edit

In Excel for Microsoft 365 on Windows, use this order. If the sheet is already protected, first choose Review > Unprotect Sheet; enter its password if Excel asks. Then:

Select the cells that users should be able to change. To select separate areas, hold Ctrl while selecting each range.
Open the Format Cells dialog. Press Ctrl+1, or right-click the selection and choose Format Cells.
Choose the Protection tab and clear the Locked checkbox. Select OK.
Choose Review > Protect Sheet.
Choose whether to set a password and review the actions permitted in the dialog. At minimum, keep Select unlocked cells enabled so users can move to the input fields.
Select OK. If you entered a password, Excel asks you to confirm it.

On a Mac, the same basic process applies: select the cells, open Format Cells, clear Locked on the Protection tab, and use Review > Protect Sheet. The dialog arrangement and available options can vary slightly by Excel version. Excel for the web has sheet-protection controls too, but its interface and available settings may differ from the Windows desktop steps.

If you want to make the whole sheet locked before choosing the input areas, select the worksheet using the Select All button at the top-left corner of the grid, open Format Cells, and make sure Locked is selected. Then unlock only the intended input cells and protect the sheet. This reset can help when a workbook has been edited by several people and cell settings are inconsistent.

Choose the right protection options

The Protect Sheet dialog lets you decide what people can do while protection is on. The options are permissions for that worksheet; they do not change which cells are unlocked. For a simple form, allow selection of unlocked cells and consider clearing Select locked cells so users do not land on protected content as they tab or click through the form.

Other options may allow actions such as formatting cells, inserting rows, sorting, or using AutoFilter. Enable only what the workflow needs. For instance, if people must filter a protected list, allow Use AutoFilter. If they must sort, allow Sort, but remember that sorting a range containing locked and unlocked cells can be restricted by Excel’s protection rules. Try the actual workflow on a copy before distributing the file.

Protection can make routine tasks inconvenient if permissions are too restrictive. A user who needs to change column widths, add rows, or edit a table may encounter a warning even when the data-entry cells are unlocked. Decide whether those layout changes belong to the workbook owner or the everyday user, and set the allowed actions accordingly.

Example: a protected expense form

Imagine a sheet with labels in column A, employee-entered amounts in B2:B12, and a calculated total in B13. Leave B2:B12 unlocked, keep B13 and the labels locked, and protect the worksheet. Users can enter expenses while the formula and labels remain protected from ordinary edits.

Before sharing the form, test it as a recipient would: enter a value in B2, try changing the total in B13, and see whether the allowed navigation and formatting behavior make sense. If the input area is not obvious, use a heading, a light fill color, or a border to identify it. Visual cues improve usability, but they are not a substitute for the Locked setting.

You can add data validation to input cells to guide entries, such as restricting a field to whole numbers or a list of categories. Data validation and sheet protection serve different purposes: validation helps control or explain the values entered, while protection limits edits to locked cells and selected worksheet actions. Neither should be treated as a guarantee that a user cannot deliberately alter a workbook.

Common problems and how to fix them

Input cells still cannot be edited: Check that the cells were actually unlocked before protecting the sheet. Unprotect the sheet, select the input range, open Format Cells > Protection, and clear Locked. Protect it again afterward.
Formula cells can still be changed: Confirm that those cells have Locked selected and that sheet protection is on. A cell being locked by itself does not block editing on an unprotected sheet.
Users cannot select the input cells: Reopen the protection settings and enable Select unlocked cells. If Select locked cells is also enabled, users may be able to click protected cells, but that does not make those cells editable.
Some cells behave differently from others: Cells can have different formatting and protection properties. Unprotect the sheet, inspect the relevant ranges, and apply the intended Locked setting consistently.
A user cannot insert rows or change formatting: These are separate permissions in the Protect Sheet dialog. Unlocking a cell does not automatically allow structural changes or formatting of the worksheet.
The password is missing: Excel will ask for the password to unprotect a password-protected sheet. Keep passwords in an appropriate password manager or another secure record; do not assume that a forgotten password can be recovered through the normal interface.

Merged cells, tables, and complex layouts can complicate a protected form. A merged area is treated as one cell for editing, so it cannot be partly unlocked. Some table operations or changes that affect the worksheet structure may also be unavailable under protection. If a form needs frequent row additions or major layout changes, consider having an owner maintain the structure while users fill in the designated fields.

Sheet protection is not file security

Worksheet protection is intended to prevent accidental changes and guide normal editing. It is not a robust way to keep confidential information secret or to defend a workbook against a determined person. A protected worksheet may still expose its contents, and protection does not encrypt the workbook file.

Use the appropriate control for the risk. If you need to restrict who can open a workbook, use Excel’s file-level encryption option, found under File > Info > Protect Workbook > Encrypt with Password in the Windows desktop app. Keep that password safe: losing it can prevent access to the file. If you only need to prevent users from renaming, moving, or deleting sheets, workbook structure protection is a different setting from protecting an individual sheet.

You can also hide formulas by selecting formula cells, opening Format Cells > Protection, and selecting Hidden before protecting the sheet. This hides formulas from the formula bar while protection is active; it does not conceal the underlying results as a security measure. Consider whether users need to inspect or audit the calculations before hiding them.

Alternatives and practical safeguards

For a small shared form, unlocked input cells and sheet protection are often sufficient to prevent accidental edits. For a process requiring stronger control, consider collecting responses through a dedicated form or business application and keeping the workbook as an output or analysis tool. In a shared workbook, use appropriate file permissions as well as sheet protection, and retain an unprotected master copy so the owner can update the template.

Before distributing a protected sheet, check these details:

Unlock only cells that users genuinely need to edit, and protect formula and instruction areas.
Choose permissions based on real tasks, such as filtering or formatting, rather than enabling every option by default.
Test data entry, navigation, printing, and any sorting or filtering on a separate copy.
Document who maintains the sheet and where the protection password is stored.
Use file-level access controls when confidentiality or controlled access matters.

Frequently Asked Questions

Can I protect a sheet but leave only a few cells editable?
Yes. Select the cells users may change, clear Locked in Format Cells > Protection, and then choose Review > Protect Sheet. Other locked cells will be protected while the worksheet remains protected.

Why are locked cells still editable before I protect the sheet?
Locked is a cell property, not an active restriction on its own. It takes effect only after you turn on sheet protection. This lets you set up which cells are editable before applying protection to the worksheet.

Can I let users edit cells without a password?
Yes. A password is optional when you protect a sheet. Protection without a password can still prevent routine edits to locked cells, but anyone who can change protection settings may be able to remove it. Use file permissions or encryption when stronger access control is needed.

Can I protect formulas while allowing input cells?
Yes. Keep formula cells locked, unlock the input cells, and protect the sheet. You can also select Hidden for formula cells before protection if you do not want formulas displayed in the formula bar, but that is not a confidentiality safeguard.

How do I make a protected sheet editable again?
Choose Review > Unprotect Sheet and enter the password if prompted. You can then change cell settings or edit the worksheet. If you need to change the unlocked ranges, protect the sheet again after making those changes.

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.