Yes. In Excel for Microsoft 365 on Windows, select the cells people should be able to edit, open Format Cells with Ctrl+1, and clear Locked on the Protection tab; then choose Review > Protect Sheet. Cells marked Locked become protected from editing only after you protect the worksheet.
This lets you keep formulas, labels, or approved values intact while leaving designated input cells available. The setting is useful for preventing accidental changes, but it is not a substitute for file encryption or access controls when information is confidential.
What locking cells in Excel actually means
Excel separates a cell’s Locked setting from the act of protecting a worksheet. In a new worksheet, cells are generally marked as locked by default, but that setting has no practical effect while the sheet is unprotected. Anyone who can edit the workbook can still change those cells. Protecting the sheet turns the setting into a restriction: users can edit unlocked cells, while locked cells are protected according to the permissions chosen in the protection dialog.
This distinction explains a common surprise: clicking Protect Sheet immediately may appear to lock everything. Usually, that is because all the cells were already marked Locked. The usual workflow is to unlock the areas intended for input first, then protect the sheet. You can also reverse the logic by unlocking the whole sheet and locking only a few sensitive cells, but that takes more care if new cells or ranges are added later.
Worksheet protection applies to a sheet, not automatically to every sheet in the workbook. A workbook with several tabs may need separate protection settings on each one. It also does not prevent someone from opening the file, copying information, or making a separate copy and changing that copy.
How to lock selected cells and leave others editable
For a typical form or calculation sheet, leave formula cells locked and unlock only the places where people should type. In Excel for Microsoft 365 on Windows:
- Select the cells users are allowed to change. To select a range, drag across it or enter its address in the Name Box, such as B4:B12.
- Press Ctrl+1 to open Format Cells. Select the Protection tab and clear the Locked checkbox, then select OK. This changes the cell setting; it does not yet protect the sheet.
- Open the Review tab and choose Protect Sheet.
- In the dialog, leave Protect worksheet and contents of locked cells selected. Choose which actions users may perform while protection is on, such as selecting unlocked cells. Add a password if appropriate, then select OK.
- If you set a password, enter it again when Excel asks you to confirm it. Test the result by trying an unlocked input cell and a locked formula cell.
When you protect the sheet, the cells you unlocked remain editable; the other locked cells are restricted. If a user needs to change the design later, return to Review > Unprotect Sheet. Excel will ask for the password if one was set. After making changes, protect the sheet again.
On a Mac, the same basic process applies: use Command+1 to open Format Cells, change Locked on the Protection tab, and use the Review tab’s Protect Sheet command. Ribbon labels or dialog layout can vary slightly by Excel version. In Excel for the web, protection controls are on the Review tab, though the command may appear as Protect Sheet or within Manage Protection depending on the current interface. Some desktop protection options may not be available in the web interface.
Choose which cells should be editable
Before protecting a sheet, decide what each user needs to do. A budget template, for example, might contain formulas in column D that calculate totals, while users enter quantities in column B and prices in column C. Unlock the intended input ranges in B and C, keep the calculation cells locked, and protect the sheet. A clearly shaded input area and a short instruction such as Enter values in the blue cells can reduce confusion, but color alone does not enforce protection.
To make almost the entire sheet editable except for a small set of cells, use the select-all button at the upper-left intersection of the row and column headings, open Format Cells, and clear Locked. Then select the cells that must be protected, open Format Cells again, and check Locked. Protect the sheet after both settings are in place. This approach can be convenient for a mostly open worksheet, but check any cells added later: their formatting and protection settings may not match your intended pattern.
To inspect or change a cell’s status, select it and open Format Cells > Protection. The Locked checkbox tells you whether it will be restricted when sheet protection is active. Excel also offers a Hidden checkbox on that tab. If you select it and protect the sheet, the formula bar will not display the formula for that cell. Hidden does not hide the cell’s displayed result, and it is not a confidentiality measure.
What sheet protection can and cannot control
Protect Sheet can restrict editing of locked cells and, depending on the options selected, allow or block actions such as selecting locked cells, formatting cells, inserting or deleting rows, sorting, and using AutoFilter. Choose permissions based on the work people actually need to do. For example, a sheet that users must filter may need the relevant filter permission enabled before protection is turned on. If a permitted action still cannot be performed, check whether the required feature was already in place and whether the corresponding protection option was selected.
Protection is not all-or-nothing: users can often select locked cells even if they cannot change them. In the Protect Sheet dialog, you can allow selection of unlocked cells and disallow selection of locked cells, which can make a data-entry form easier to navigate. This affects selection behavior, not whether the content is encrypted.
Sheet protection is different from protecting a workbook’s structure. To restrict actions such as renaming, moving, deleting, hiding, or adding sheets, use Review > Protect Workbook and choose the structure option where available. That does not replace protecting individual sheets’ cell contents. A workbook can need both controls, depending on what users should be able to change.
Examples for formulas, forms, and shared templates
For a simple order form, suppose customers or colleagues should enter a product name, quantity, and unit price, while a total column calculates quantity multiplied by price. Unlock only the entry cells, keep the total formulas locked, and protect the sheet. If someone types over a total by mistake, protection prevents that edit. The person can still enter new values in the designated cells, and Excel will recalculate the formulas as usual.
For a monthly reporting template, you might lock headings and formulas but allow edits in a block for actual results. If users also need to add rows, sort records, or apply filters, consider those needs before protecting the sheet. Protection options can limit these operations, and a layout that relies on frequent structural changes may be better managed by a workbook owner who unprotects the sheet, makes the changes, and protects it again.
For a workbook containing formulas you do not want casually overwritten, marking formula cells Locked and Hidden before protecting the sheet can discourage accidental edits and hide the formulas from the formula bar. It does not prevent a determined recipient from examining or copying workbook contents. Use it as a usability and error-prevention feature, not as a way to conceal valuable logic.
Common problems and how to fix them
- Everything is locked: The sheet was protected before input cells were unlocked, or the wrong range was selected. Unprotect the sheet, select the intended input cells, clear Locked in Format Cells, and protect it again.
- A locked cell is still editable: The worksheet may not actually be protected. Check the Review tab; if the command offered is Protect Sheet rather than Unprotect Sheet, protection is off. Also confirm that the cell itself is marked Locked.
- The password is not accepted: Passwords are case-sensitive, so check capitalization and keyboard layout. If a password is forgotten, there is no normal password-recovery prompt that restores access. Keep passwords in an approved, secure place and retain an unprotected backup if appropriate.
- Users cannot sort, filter, or format: Protection may be blocking the action. Unprotect the sheet, review the allowed actions in Protect Sheet, enable only what users need, and protect it again.
- Some cells behave differently from nearby cells: Check the Locked setting for the selected cells, including cells in merged ranges or copied sections. Formatting copied from another area can bring along protection settings as well as appearance.
When updating a protected template, test with a normal user workflow rather than only checking the dialog. Enter a value in each input area, confirm formulas still calculate, and verify that the actions users need are allowed. Keep an editable master copy so a mistaken protection setting does not disrupt the working version.
Protection, passwords, and safer alternatives
A worksheet password is mainly a barrier against ordinary edits, not strong security for sensitive data. Excel worksheet protection is not the same as encrypting the workbook. If you need to restrict who can open a file, use file-level encryption or the organization’s approved storage and sharing controls. In Microsoft 365 for Windows, workbook encryption is available through File > Info > Protect Workbook > Encrypt with Password. Availability and organizational policy can vary, and a forgotten encryption password can make a file inaccessible.
Use a password only if it serves a real purpose, and store it somewhere authorized users can retrieve it. A password-protected sheet can still be viewed by people who can open the workbook; protection mainly helps prevent edits to locked cells. It is also possible to make a separate copy of an unprotected workbook and edit that copy, so sheet protection does not guarantee that every distributed version remains unchanged.
If the main goal is to reduce mistakes, other approaches may help alongside protection. Data Validation can limit what users enter in a cell, such as requiring a whole number within a range. Clear input formatting and instructions can make editable areas obvious. For multi-user work, file permissions and version history in a managed OneDrive or SharePoint location can help control access and recover prior versions, subject to the organization’s settings. These tools address different problems; none makes cell locking a substitute for sound file-sharing practices.
Frequently Asked Questions
Are Excel cells locked by default?
In a new worksheet, cells are generally marked Locked by default. The setting only restricts edits after you protect the worksheet, so an unprotected sheet remains editable.
Can I lock only certain cells in Excel?
Yes. Unlock the cells that should remain editable, leave the others locked, and then protect the worksheet. You can also unlock the whole sheet first and lock only selected ranges.
Can people still use formulas in a protected sheet?
Yes. Existing formulas continue to calculate when users change allowed input cells. Users cannot edit locked formula cells while sheet protection is active, unless you unprotect the sheet or change the cell settings.
Does protecting cells stop someone from viewing the data?
No. Worksheet protection is intended to limit changes, not hide or encrypt the workbook’s contents. Use appropriate file encryption and sharing permissions for confidential information.
How do I remove cell protection?
Choose Review > Unprotect Sheet. If protection uses a password, enter it when prompted. Then change the Locked setting or edit the cells as needed.
Related
- Excel Named Ranges: How They Work and When to Use Them
- Excel Named Range Table: How They Work and When to Use
- Excel Named Range for a Table Column: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Responding: Causes, Checks, and Practical FixesWhen Excel says “Not Responding,” first give it a few minutes if it may be calculating or opening…
- Add a New Page in Word Without a Header: Step-by-StepTo add a page in the middle of a Word document without a header on that page, isolate…
- Schedule a Follow-Up Email in Outlook: Steps & TipsTo schedule a follow-up email in Outlook, write the message, open the arrow beside Send, choose Schedule send,…
- How to Make a Bifold Brochure in Word, Step by StepTo make a bifold brochure in Microsoft Word, create a two-page landscape document, divide each page into two…
- How to Freeze Selected Columns in Excel Without ScrollingTo keep columns visible while you scroll across a worksheet, select the cell immediately to the right of…
- Clear Outlook Desktop Cache: Safe Steps for Windows & MacTo clear the cache in classic Outlook for Windows, first identify what is causing the problem: use File…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.