Protect Sheet in Excel: Allow Editing in Certain Cells

Yes. In Excel for Microsoft 365, you can protect a worksheet while leaving particular cells editable: unlock those cells first, then protect the sheet. The protection prevents changes to the other locked cells while preserving access to the ones you chose.

What sheet protection does

Excel cells are marked as locked or unlocked, but that setting has no effect until you protect the worksheet. In a new worksheet, cells are locked by default. That does not stop anyone from editing them until sheet protection is turned on. This two-part design lets you decide which areas people can change without having to rebuild the sheet or move its contents.

For example, a shared order form might contain product descriptions, prices, and formulas that should stay as they are, alongside blank cells for a customer name, quantity, and delivery date. You can leave the form’s fixed content locked, unlock only the entry cells, and then protect the sheet. Someone filling in the form can enter information in the intended places but cannot accidentally overwrite a price or formula.

Worksheet protection is an editing safeguard, not a way to encrypt a workbook or keep confidential information secret. People may still be able to view or copy data, and sheet protection is not a substitute for file encryption, access controls, or storing sensitive information securely.

Unlock only the cells people may change

In Excel for Microsoft 365 on Windows, select the cells that should remain editable. To select several separate areas, hold Ctrl while selecting each area. Then open Format Cells with Ctrl+1, choose the Protection tab, clear the Locked check box, and select OK. On a Mac, Command+1 opens Format Cells; the dialog and available options can vary slightly by Excel version.

Clearing Locked changes the selected cells’ status; it does not immediately protect the sheet or lock other people out. If you later decide that one of these cells should not be editable, select it, open the Protection tab again, and select Locked. You can also leave the sheet unprotected while building it and apply protection only after the layout and input areas are ready.

Before changing the setting, check that you have selected the intended cells. A whole-column or whole-sheet selection can unlock far more than you mean to. If the workbook already has custom protection settings or a mixture of locked and unlocked cells, inspect the relevant areas rather than assuming every cell has the default status.

Protect the worksheet and choose permissions

When the editable cells are ready, go to Review > Protect Sheet. In the Protect Sheet dialog, you can enter a password if you want Excel to require it to unprotect the sheet. The password is optional. You can also choose what users are allowed to do while the sheet is protected. For a basic form, leave Select unlocked cells enabled so users can move to the input cells and type into them.

Then select OK. If you entered a password, Excel asks you to confirm it. Keep a record of the password somewhere appropriate: if it is forgotten, regaining access to the protected sheet may be difficult. If you did not set a password, protection still blocks the ordinary editing actions that the protection settings disallow, but a user can turn protection off without entering one.

Common options in the dialog include selecting locked cells, formatting cells, inserting rows, and sorting. Choose only the permissions the worksheet’s users need. For example, allowing formatting may let users change the appearance of cells even though they cannot edit the locked cell contents. Allowing a particular action does not necessarily make every related operation possible; some operations can be restricted by the layout or other protection settings.

Use Allow Edit Ranges for a different kind of access

Unlocking cells is the simplest method when everyone using the protected sheet should be able to edit the same input areas. If different people need permission to edit different ranges, Excel for Windows also has an Allow Edit Ranges feature. It lets you define ranges that can be edited on a protected sheet and, depending on the environment and setup, associate a password or user permissions with a range.

In Excel for Microsoft 365 on Windows, open Review > Allow Edit Ranges, create a new range, specify its reference, and set the access method available to you. Apply the range settings, then protect the sheet. This is useful when, for example, separate departments maintain separate sections of a planning worksheet. It is not the same as simply unlocking a cell for every user: range permissions can provide more differentiated access, but their availability and user-permission options depend on the computer and organization’s configuration.

If you do not see Allow Edit Ranges, the command may not be available in your version or current environment. Excel for Mac and Excel for the web do not necessarily offer the same range-permission setup as Excel for Windows. For a workbook that relies on this feature, configure and check it in the Windows desktop app before sharing it.

Test the result before sharing

After protecting the sheet, test it as a regular user would. Try typing in an unlocked input cell, then try changing a locked heading or formula cell. Confirm that the input area remains usable and that protected content cannot be edited. If the sheet is a form, also test common actions such as selecting cells, using a drop-down list, and entering a date.

Protection can allow users to select unlocked cells, locked cells, or both. If users can click locked cells but cannot change them, that may be expected: selection and editing are different permissions. If you want people to move only among the input cells, revisit the Protect Sheet options and consider turning off Select locked cells while leaving Select unlocked cells on.

For shared workbooks, check the protected sheet in the app people will actually use. Excel for the web may present different controls from the Windows desktop app, and some configuration options may be unavailable there. If you need to adjust protection and cannot find the relevant command in a browser, open the workbook in Excel desktop rather than assuming the setting is missing from the file.

Common problems and how to fix them

Users cannot edit a cell that should be open: Unprotect the sheet, select the cell, and check Format Cells > Protection to confirm Locked is cleared. Protect the sheet again after making the change.
Users can edit too much: Unprotect the sheet and check whether entire rows, columns, or extra ranges were unlocked by mistake. Lock those cells again before protecting the worksheet.
Users cannot type even in unlocked cells: Confirm that Select unlocked cells is allowed in the Protect Sheet dialog. Also check that the intended cells are truly unlocked and that the sheet is not protected by a different setting or workflow.
A formula is visible or can be copied: Locking a formula cell prevents ordinary edits when the sheet is protected, but it does not hide the formula by itself. Excel’s Protection tab includes a Hidden option for formulas, which takes effect when the sheet is protected. That is still not a security measure for confidential formulas or data.
The password is rejected or forgotten: Check for typing mistakes and the intended workbook version. Excel passwords are case-sensitive. Avoid relying on sheet protection as the only copy of important work; keep an appropriate backup and store passwords securely.

Sheet protection compared with other controls

Use sheet protection when the main goal is to prevent accidental edits to a worksheet’s structure or fixed content while keeping selected cells available for data entry. It is especially useful for templates, checklists, forms, and calculation sheets that many people fill in but should not redesign.

Workbook-structure protection solves a different problem: it can restrict actions such as adding, deleting, moving, or renaming worksheets. It does not replace protecting cells on an individual sheet. File-level encryption or password-to-open protection is more appropriate when the goal is to restrict access to the workbook itself. In a workplace, sharing permissions and approved storage locations may also matter. Choose the control that matches the risk; worksheet protection alone does not control who can open or read a file.

Another option is to separate input from calculations. For instance, put user-entered values on a clearly labeled input sheet and calculations on a separate protected sheet. That can make a workbook easier to use and maintain, although it does not make the data secure. A well-labeled input area, consistent formatting, and data validation can reduce mistakes alongside protection.

Frequently Asked Questions

Can I protect a sheet but leave only a few cells editable?
Yes. Clear Locked for the cells users may change, then choose Review > Protect Sheet. Leave Select unlocked cells enabled so users can reach those cells.

Why are cells locked if I have not protected the sheet?
Most cells in a new Excel worksheet are marked as locked by default, but the setting does not restrict editing until you protect the worksheet. You can change the Locked setting at any time while the sheet is unprotected.

Can I let different people edit different cells?
Excel for Windows includes Allow Edit Ranges, which can assign access methods to specific ranges before the sheet is protected. The options depend on your version and organization’s environment; ordinary unlocked cells are generally editable by anyone who can edit the workbook.

Does protecting a sheet stop people from seeing its data?
No. Sheet protection is intended to limit worksheet edits, not conceal information or encrypt the file. Do not use it as the sole protection for confidential data.

Can I protect a sheet in Excel for the web?
Protection controls and editing behavior can differ in the browser. If you need to configure detailed options or Allow Edit Ranges and cannot find them online, use Excel for Microsoft 365 on Windows and verify the finished workbook in the app your users will use.

What if I need to change which cells are editable later?
Unprotect the sheet, change the Locked setting for the relevant cells, and protect the sheet again with the desired options. You need the password if one was set.

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.