Protect Sheet in Excel: Allow Editing Specific Cells

Yes. In Excel for Microsoft 365 on Windows, you can protect a worksheet and still allow editing in selected cells: unlock those cells before turning on protection, or define specific editable ranges. The rest of the sheet can remain protected from changes, which is useful for forms, templates, and shared data-entry sheets.

What worksheet protection does

Excel worksheet protection controls which actions people can take on a particular sheet. When protection is on, users may be prevented from changing locked cells, inserting or deleting rows, formatting cells, or performing other actions, depending on the options selected. Protection is applied to one worksheet at a time; a workbook with several sheets needs its protection settings managed separately for each one.

Cells are marked as locked by default, but that setting does not prevent editing until you protect the sheet. This two-part design is what makes selective editing possible: leave cells that should be controlled as locked, unlock cells intended for data entry, and then protect the sheet. A blank template may therefore have every cell marked locked, yet remain fully editable until sheet protection is enabled.

Protection is not the same as making a file read-only or encrypting it. It is mainly a way to limit changes to a worksheet and reduce accidental edits. It should not be treated as a strong barrier for confidential information or as a substitute for file permissions and encryption.

Unlock cells people should be able to edit

For a straightforward template, unlock the intended input cells before protecting the sheet. These instructions use Excel for Microsoft 365 on Windows:

Select the cells users should be able to change. To select separate groups, hold Ctrl while selecting each range.
Open Home > Format > Format Cells, or press Ctrl+1.
In the Format Cells dialog, select the Protection tab and clear Locked. Select OK.
Open Review > Protect Sheet.
Optionally enter a password, choose which actions users may perform, and select OK. If you entered a password, confirm it when prompted.

Now the unlocked cells can be edited while locked cells are protected. For example, in a request form, you might unlock the cells beside Employee, Date, and Requested item, while leaving the instructions, headings, and calculation cells locked. Users can fill in the form without changing its layout or formulas.

On a Mac, the Format Cells shortcut is usually Command+1 rather than Ctrl+1. The relevant controls are also available through the Format Cells dialog and the Review tab, though labels and placement can vary by Excel version. In Excel for the web, the ribbon and available protection controls may differ; use desktop Excel if you need the full set of worksheet protection options.

Allow editing in a specific range

Excel for Windows also has an Allow Edit Ranges feature. It is useful when a protected sheet contains one or more defined areas that should remain editable, especially if you want a password for a particular range. It is different from simply unlocking cells: you create the permitted range first, then protect the sheet.

On the Review tab, select Allow Edit Ranges.
Select New, give the range a recognizable title, and specify the cells in the Refers to cells box.
If appropriate, enter a password for that range. A range password controls access to that range; it is separate from the password used to protect the worksheet.
Select OK, then use Review > Protect Sheet to protect the worksheet.

For instance, a worksheet might have a separate range for each department. A range password can allow a department to edit its own area while the sheet is protected. Keep in mind that password-based range access is not the same thing as identifying a person through a secure account. The feature and its advanced permission options can depend on the Excel edition and environment, so check what is available in your organization before relying on it.

When a range has a password, Excel may ask for it when someone tries to edit that area on a protected sheet. If the cells are also unlocked, users may be able to edit them without that range-password prompt. Set up the range and cell locking deliberately, then test the sheet using the access pattern you intend to provide.

Choose the right protection options

The Protect Sheet dialog includes a list of actions users may be allowed to perform. The best choices depend on how the sheet is meant to be used. Leaving an action unchecked restricts it while protection is on; allowing an action does not necessarily make every related task possible if other cells or workbook features impose restrictions.

Select locked cells: Lets users select cells marked as locked. Turn this off if users should be able to move only among editable inputs.
Select unlocked cells: Lets users select the cells intended for data entry. This is commonly left enabled.
Format cells, columns, or rows: Allows corresponding formatting changes. Leave these disabled if preserving the sheet’s layout matters.
Insert or delete rows and columns: Allows structural changes that may disrupt a carefully designed template.
Sort and use AutoFilter: Can be useful for a protected list, but the required cells and existing filter setup matter. Test the exact workflow before distributing the sheet.
Use PivotTable reports or edit objects: Allow these only when users need those specific actions.

Consider the task from the user’s point of view. If they need to enter values and nothing else, unlock the input cells and allow selection of unlocked cells, but keep formatting and structural actions restricted. If they need to filter a table, enable the relevant option and test filtering while protection is on. Protection settings are not a substitute for testing the actual workbook.

Plan the sheet before protecting it

It is easier to set up protection in a deliberate order than to diagnose unexpected restrictions later. A useful preparation checklist is:

Identify all cells users must change, including any repeated input areas.
Check which cells contain formulas or fixed labels that should not be overwritten.
Unlock intended inputs and, if needed, define editable ranges.
Decide whether users must sort, filter, select locked cells, or format anything.
Protect the sheet, then test both an allowed edit and a change that should be blocked.

For a simple inventory-entry sheet, for example, you could unlock the cells in the Quantity and Notes columns, keep the Item ID and formula columns locked, and enable filtering if staff need to find particular items. Try entering a quantity, changing a formula, and filtering the list before sharing the workbook. This catches problems such as an accidentally unlocked formula cell or a filter option that was not enabled.

Keep an unprotected backup or a separate master copy while designing the sheet. If a password is used, store it somewhere appropriate and make sure the people who need to maintain the workbook can access it. Losing a protection password can make routine edits harder, even though worksheet protection is not equivalent to file encryption.

What protection does not secure

Microsoft describes worksheet protection as a way to prevent modification of locked cells, not as a security feature. It can help prevent accidental edits, but it should not be used to hide sensitive data from someone who can access the workbook. Do not put confidential information on a sheet merely because the sheet is protected or a password prompt appears.

For stronger access control, consider who can access the workbook itself. File-level encryption and storage or sharing permissions address different problems from worksheet protection. For example, worksheet protection can keep a user from overwriting a formula while they fill in a form; file permissions can determine who can open or edit the workbook. Choose the control that matches the information and risk involved.

Workbook structure protection is another separate setting. It can restrict actions such as adding, deleting, moving, or renaming sheets, but it does not replace protection of the cells on an individual sheet. If you need both controls, configure each deliberately and test them separately.

Common problems and fixes

Users still cannot edit an input cell. Check that the intended cell was unlocked before protecting the sheet. Select it, open Format Cells, and inspect the Protection tab. Also check whether the sheet is protected with settings that prevent selecting unlocked cells.

A formula or heading can be changed. The cell may have been unlocked by mistake, or sheet protection may have been turned off. Review the cell’s Locked setting and confirm protection is active. Remember that locked status by itself does not stop edits on an unprotected sheet.

Filtering or sorting is unavailable. Check the corresponding choices in the Protect Sheet dialog. Some actions also depend on how the data and filter were set up before protection. If the task still fails, test it on a copy and adjust the setup rather than assuming that enabling one option will override every restriction.

The password does not work. Distinguish the worksheet password from any password assigned to an editable range, and check for typing or keyboard-layout differences. Excel does not provide a simple recovery mechanism for a forgotten worksheet-protection password. Avoid setting passwords casually, and retain a secure record if the sheet needs ongoing maintenance.

The options differ on Mac or in a browser. Excel’s protection features are not identical across Windows, Mac, and the web. If you cannot find Allow Edit Ranges or a particular permission, open the workbook in Excel for Microsoft 365 on Windows and check the Review tab. A workbook may also need to be saved in a compatible format for the intended users.

When to use another approach

Selective sheet protection is a good fit for templates where users need a small number of editable cells and should not alter the rest. It is less suitable when many people need different permissions, when the workbook is used as a sensitive record system, or when users need broad collaborative editing and audit controls.

For collaboration, a shared workbook stored in OneDrive or SharePoint can support coauthoring, but sharing permissions determine who can access or edit the file; they do not automatically provide cell-by-cell security. For controlled data collection, a form or database may be a better fit than asking people to edit a complex workbook. For confidential content, use appropriate file and storage protections rather than relying on locked cells.

There is no need to protect every sheet in every workbook. If the goal is only to reduce accidental changes, clear instructions, data validation, or a separate input sheet may be easier for users. If formulas must be preserved, selective protection is often a practical safeguard, provided users understand which cells are intended for entry.

Frequently Asked Questions

Can I protect a sheet but leave some cells editable?
Yes. Unlock the input cells before selecting Review > Protect Sheet, or use Review > Allow Edit Ranges to define permitted areas. The remaining locked cells are protected when sheet protection is on.

Do I have to use a password to protect a sheet?
No. In the Protect Sheet dialog, you can protect a worksheet without entering a password. A password can prevent other users from turning protection off through normal Excel controls, but sheet protection is not strong security for sensitive data.

Why can I edit locked cells before I protect the sheet?
Locked is a cell-format setting, not an active restriction by itself. It takes effect when worksheet protection is enabled. This is why users can normally edit a new worksheet even though its cells are marked locked.

Can I allow editing in one range with a password?
In supported Windows desktop versions, use Review > Allow Edit Ranges to define the cells and optionally assign a range password, then protect the sheet. The range password and sheet-protection password serve different purposes.

Does protecting a worksheet hide its data?
No. Worksheet protection is meant to limit changes, not conceal information. Use file-level encryption and appropriate sharing permissions when access to the contents themselves must be restricted.

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.