Protect Sheet in Excel: Allow Editing Specific Cells

Yes. In Excel for Microsoft 365 on Windows, select the cells people should be able to change, clear their Locked setting, and then choose Review > Protect Sheet. Sheet protection then blocks edits to the remaining locked cells while leaving the unlocked cells editable; locking a cell by itself does nothing until you protect the sheet.

What sheet protection does

Excel cells have a Locked property, and cells are usually marked as locked by default. That setting is only enforced after sheet protection is switched on. The usual workflow is therefore to unlock the intended input cells first, then protect the sheet. Formulas, labels, and other content can remain locked so they are less likely to be overwritten by accident.

For example, a budget worksheet might have formulas in column D and blank input cells in column C. Unlock the cells in C where people enter amounts, leave the formula cells in D locked, and protect the sheet. A user can fill in the permitted amounts but cannot accidentally replace the calculations. This is an editing control, not a way to make a cell inherently read-only under every circumstance.

Protection is applied to an individual worksheet. A workbook with several sheets may need protection configured separately on each one. Also, sheet protection is different from protecting the workbook structure, which can prevent actions such as adding, deleting, moving, or renaming sheets.

Unlock cells before protecting the sheet

In desktop Excel for Microsoft 365 on Windows, prepare the editable cells before applying protection:

Select the cells that should remain editable. To select multiple separate areas, hold Ctrl while selecting each range.
Open the Format Cells dialog with Ctrl+1. You can also use Home > Format > Format Cells.
Choose the Protection tab and clear the Locked checkbox, then select OK. This changes the selected cells’ property; it does not yet protect the sheet.
Open Review > Protect Sheet.
In the dialog, leave Protect worksheet and contents of locked cells selected. Choose which actions users may perform, and enter a password if you want to require one to remove protection.
Select OK. If you entered a password, Excel asks you to confirm it.

After protection is enabled, try typing in both an unlocked input cell and a locked formula cell. The first should accept an entry; the second should reject editing. Testing with a sample entry is a useful way to confirm that you selected the correct ranges and permissions.

Choose what users can do

The Protect Sheet dialog includes permissions in addition to editing unlocked cells. The exact list can vary by Excel version, but common options include selecting locked or unlocked cells, formatting cells, rows, or columns, inserting or deleting rows and columns, sorting, using AutoFilter, and using PivotTable reports. Select only the actions the worksheet needs. For instance, allowing users to select unlocked cells while disallowing selection of locked cells can make a form easier to use, but it is optional.

Permissions do not automatically make locked content editable. If users need to sort a protected list, for example, you may need to allow sorting and ensure the relevant range and protection setup support that action. Some operations can still be restricted by locked cells or by the shape of the data. Test the specific task users need to perform rather than assuming that checking one permission enables every related operation.

A password is optional. If you set one, people generally need it to remove sheet protection and change the protection setup. Keep it somewhere appropriate: if it is lost, recovering access may be difficult. A password on a protected sheet should not be treated as a substitute for encrypting a confidential workbook.

Allow editing in a particular range

For a simple form, unlocking input cells is usually the clearest solution. If different areas need different access rules, desktop Excel also has an Allow Edit Ranges feature. On Windows, look for Review > Allow Edit Ranges. It can define ranges that may be edited under specified conditions, including password-based access for a range. Availability and the exact authentication options can depend on the Excel edition and the environment, so check the dialog in the version being used.

This is useful when a worksheet is shared among people who should edit different sections, such as separate department input blocks. It is more involved than leaving a group of cells unlocked, and it should be tested with the actual users and account setup. A range password is not the same as a unique identity-based permission system, and a shared password can be passed on.

For a collaborative workbook where individuals need different access, consider whether workbook sharing or a system designed for role-based permissions is more suitable. Sheet protection is intended mainly to prevent unintended changes to worksheet content, not to manage sensitive access at a granular security level.

Practical example: a protected request form

Suppose a request sheet has fixed headings, a formula that calculates a total, and blank cells for a requester’s name, date, and requested amount. Select only the three input areas and clear Locked in Format Cells. Leave the headings and total formula locked, then protect the sheet. Depending on how the form is laid out, allow users to select unlocked cells and leave other permissions off.

Before distributing the file, test the normal workflow: enter a name and amount, confirm the total updates, and try to overwrite the formula. If users must also add rows, filter a table, or format their entries, test those actions while protection is enabled and allow only the required operations. If a form is copied to make new sheets, verify protection and cell settings on each copy; do not assume every sheet has the same configuration.

Change the setup or remove protection

To change which cells are editable, you generally need to unprotect the worksheet first. Choose Review > Unprotect Sheet and enter the password if prompted. Then adjust the Locked setting for the desired cells and protect the sheet again with the intended options. If a sheet is already protected and you do not know its password, Excel will not let you use this normal workflow to alter its protection.

Remember that formatting a cell and changing its Locked property are separate operations. You can set a cell’s font, color, or number format without changing whether it is locked. Conversely, clearing Locked does not visibly mark the cell as editable unless you add a cue such as a fill color or an instruction. A clear visual distinction between input cells and calculated cells can reduce user mistakes.

Common problems and misconceptions

Users still cannot edit an input cell: Check that the cell was actually unlocked before protection, and confirm that the sheet is protected with the expected options. A cell may be part of a different range than the one selected.
Users can still edit everything: The sheet may not be protected, or the cells may all be unlocked. The Locked property is not enforced until protection is active.
A formula can be seen even though it cannot be changed: Locking prevents ordinary editing while the sheet is protected; it does not necessarily hide the formula. If hiding formulas is appropriate, inspect the Hidden option in the Protection tab and then protect the sheet.
Protection is being mistaken for security: Worksheet protection is designed to limit editing, not to encrypt the file or guarantee confidentiality. Do not use it as the only safeguard for sensitive information.
A permitted action still fails: Check the relevant permission and test whether other worksheet restrictions affect that action. The Protect Sheet options are not a promise that every operation will work in every layout.

Excel for Mac and Excel for the web

On Excel for Mac, the same basic principle applies: unlock the intended cells, then protect the worksheet. The Format Cells dialog can be opened with Command+1 rather than Windows Ctrl+1; ribbon labels and dialog layouts may differ slightly by release. Review the available Protect Sheet options on that device and test the resulting workbook.

Excel for the web supports worksheet protection, but its controls and capabilities may differ from desktop Excel. If you need the full desktop range of protection settings or need to configure a more complex Allow Edit Ranges setup, use the Excel desktop app where the relevant commands are available. A workbook protected in desktop Excel may still be opened and edited in the web app according to its protection settings, but verify the precise user workflow in the version your audience uses.

Frequently Asked Questions

Can I protect a sheet but leave some cells editable?
Yes. Select those cells, clear Locked in Format Cells, and then protect the worksheet. Locked cells remain restricted while unlocked cells can accept edits.

Do I need a password to protect a sheet?
No. You can protect a worksheet without setting a password. A password is needed if you want to require one to remove protection, but it should be stored safely.

Can users edit unlocked cells without unprotecting the sheet?
Yes. That is the purpose of unlocking selected cells before protection. Users can enter or change values in those cells while the rest of the protected sheet remains restricted according to the selected options.

Does Protect Sheet hide formulas?
No. Protection can prevent changes to locked formula cells, but hiding a formula is a separate setting. In Format Cells > Protection, select Hidden for the relevant cells and then protect the sheet if you do not want formulas displayed in the formula bar.

Is a protected worksheet secure from copying or viewing?
No. Sheet protection is primarily an editing safeguard, not file encryption or access control for confidential data. Use workbook encryption and appropriate sharing permissions when confidentiality matters.

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.