Protect an Excel Sheet Without Locking Cells: How It Works

Yes. In Excel for Microsoft 365 on Windows, unlock the cells people should be able to edit, then select Review > Protect Sheet; protection restricts locked cells and other actions according to the options you choose. If every cell is unlocked, the sheet can still have some actions restricted, but its cell contents remain editable.

What sheet protection does

Excel distinguishes between a cell’s Locked setting and whether the worksheet is protected. By default, cells are marked as locked, but that setting has no practical effect until you turn on worksheet protection. Once protection is active, Excel uses the locked settings to decide which cells users can change. Cells marked unlocked remain editable.

This is why “protect a sheet without locking cells” can mean two different things. You can protect a sheet while leaving selected input cells unlocked, which is the usual arrangement. Or you can unlock every cell and then protect the sheet. In the second case, users can still change all cell contents; protection may only restrict other actions, such as formatting or inserting rows, depending on the permissions selected.

Worksheet protection is useful for preventing accidental changes to formulas, labels, or layout. It is not a way to make all data read-only if every cell is unlocked, and it is not a security barrier for confidential information.

Unlock selected cells, then protect the sheet

For a form or shared worksheet, leave the cells that should not change locked and unlock only the entry cells. In Excel for Microsoft 365 on Windows:

Select the cells people should be able to edit. To select separate ranges, hold Ctrl while selecting each range.
Press Ctrl+1 to open Format Cells. You can also right-click the selection and choose Format Cells.
Open the Protection tab, clear the Locked checkbox, and choose OK.
Go to Review > Protect Sheet.
In the dialog, choose the actions users are allowed to take. You can set a password, but it is optional.
Choose OK. If you entered a password, Excel asks you to confirm it.

After protection is on, try editing both an unlocked cell and a locked cell. The unlocked cell should accept changes; Excel should block changes to a locked cell. This quick check catches a common mistake: changing the Locked setting but forgetting to protect the worksheet afterward.

On a Mac, select the cells and press Command+1 to open Format Cells, then use the Protection tab to clear Locked. Turn on protection from Review > Protect Sheet. Names and dialog layouts can vary slightly by Excel release, but the underlying cell setting works the same way.

Allow editing throughout the entire sheet

If you genuinely want every cell’s contents to remain editable while restricting other worksheet actions, unlock all cells before protecting the sheet. In Windows desktop Excel, click the Select All button at the upper-left corner of the grid, where the row and column headings meet. Press Ctrl+1, open Protection, clear Locked, and select OK. Then choose Review > Protect Sheet and select the permissions you want to restrict.

The Select All button selects the whole worksheet, not just the visible part of the grid. As a result, new cells in the sheet will also have the unlocked setting. That can be appropriate for a sheet where users need complete freedom to enter or revise content but should not change its formatting or insert objects. It is not appropriate if you need to preserve formulas or fixed instructions: those cells will be editable too.

There is an important limitation. Protection does not create a general “read-only sheet but editable cells” mode. If a cell is unlocked, users can change its value or formula while the sheet is protected. If your aim is to let people enter data without changing the rest of the worksheet, unlock only the input cells instead of unlocking everything.

Choose the permissions that fit the task

The Protect Sheet dialog lets you choose what users may do while protection is active. The available options depend on the workbook and Excel version. Common choices include selecting locked or unlocked cells, formatting cells, inserting or deleting rows, sorting, and using AutoFilter. Selecting an option grants permission for that action; it does not unlock cells or make their contents editable by itself.

For a simple data-entry sheet, you might allow users to select unlocked cells and leave formatting, row deletion, and other structural changes restricted. If users need to filter a table, allow the relevant filtering action as well. Test the finished sheet using the same tasks your audience needs to perform: a protection setting that blocks accidental changes can also get in the way of ordinary work if permissions are too strict.

Input form: Unlock answer cells, keep labels and formulas locked, and allow users to select unlocked cells.
Review worksheet: Unlock the cells reviewers must amend, and decide whether they also need sorting or filtering.
Open-entry grid: Unlock all cells only if every value and formula can be changed; restrict formatting or structural actions only if those restrictions are useful.

Use passwords carefully

A password for Protect Sheet is optional. It helps prevent someone from casually turning off worksheet protection or changing its settings, but it does not encrypt the workbook’s contents. Microsoft describes worksheet protection as a way to prevent changes to locked cells, not as a security feature for sensitive data. Someone who can open the file may still be able to view information, copy accessible content, or make a separate copy.

If you set a password, store it somewhere appropriate and make sure the people responsible for maintaining the workbook can retrieve it. Losing the password can make changing the protection settings difficult; do not assume that Excel can restore it for you. If the goal is to keep private information from unauthorized readers, use access controls and file encryption appropriate to your organization rather than relying on Protect Sheet. In Microsoft 365 for Windows, workbook encryption is available through File > Info > Protect Workbook > Encrypt with Password; access to that password should also be managed carefully.

Worksheet protection versus related Excel features

Protect Sheet applies to one worksheet. It is different from protecting the workbook’s structure, which can restrict actions such as adding, deleting, moving, or renaming sheets. In Windows Excel, workbook-structure controls are available under Review > Protect Workbook. Protecting the workbook structure does not replace setting cell permissions on individual sheets.

It is also different from marking a file read-only or controlling who can open it. Those approaches affect the file or its access, whereas worksheet protection governs permitted actions on a particular sheet. A file-level read-only state may discourage edits, but it does not give you the same cell-by-cell arrangement as unlocking input ranges and protecting a worksheet.

For a template, another option is to prepare the cells and formatting, then save the workbook as an Excel template. A template helps users start with a fresh copy, but it does not itself stop someone from changing the copy they create. Use protection as well if the copied worksheet needs locked formulas or fixed layout.

Common problems and how to fix them

Users still cannot edit an intended input cell: Check that the cell’s Locked box is cleared, then check that the correct worksheet is protected. If the cell belongs to a merged range, test the merged area as a whole.
Users can edit formulas that should be preserved: Select those formula cells, mark them Locked in Format Cells > Protection, and protect the worksheet again. Locking a cell alone does nothing while sheet protection is off.
Users can change every value: This is expected if every cell was unlocked. Lock the cells that must be protected, leave only intended inputs unlocked, and turn on protection.
Filtering or sorting no longer works: Review the permissions selected in Protect Sheet. Allow the needed action, then test it on the protected sheet. Some actions can still be limited by the worksheet layout or the range involved.
The protection option seems unavailable or behaves differently: Confirm that you are working with the intended worksheet and that the workbook is not in a state that restricts editing. Excel for the web and desktop Excel may expose different controls; use desktop Excel for the full Format Cells workflow when you need to set cell-level Locked properties precisely.

When changing a protected worksheet, you may need to choose Review > Unprotect Sheet first and provide its password if one was set. After making changes to the Locked settings, turn protection back on and verify both permitted and blocked actions.

Frequently Asked Questions

Can I protect a sheet but let users edit specific cells?
Yes. Clear Locked for the cells users may edit, leave other cells locked, and then choose Review > Protect Sheet. Protection must be enabled for the locked settings to restrict editing.

Can I protect a sheet if all cells are unlocked?
Yes, but users can still edit the contents of every cell. Protection may restrict selected actions such as formatting or inserting rows, depending on the permissions you choose.

Does Protect Sheet stop people from viewing or copying data?
No. It is intended to limit worksheet changes, not to hide or secure information. Do not use it as a substitute for file encryption or appropriate access controls.

Why is a locked cell still editable?
The worksheet may not be protected. The Locked setting takes effect only after you turn on Protect Sheet. Also check that you are editing the cell you intended to lock.

Can I protect just one range with a password?
Excel’s standard Protect Sheet workflow protects a worksheet and lets you unlock cells for editing. If you need different users to edit different ranges with separate permissions, look for the worksheet’s range-editing permissions available in your Excel edition, or consider a managed sharing solution; these controls are not the same as simply leaving cells unlocked.

Best setup for a shared workbook

Start by deciding exactly what users should be able to change. Unlock only those input cells, keep formulas and instructions locked, choose the minimum extra permissions the workflow requires, and protect the worksheet. Then test the sheet from a user’s point of view, including data entry, filtering, and any other allowed task. This gives users room to work without making the whole worksheet unnecessarily editable, while keeping clear in mind that sheet protection is a convenience and error-prevention measure rather than strong data security.

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.