To remove a cell lock in Excel, select the cell, press Ctrl+1, open the Protection tab, clear Locked, and click OK. If the sheet is protected, first choose Review > Unprotect Sheet; you will need the sheet password if one was set.
What “locked” means in Excel
In Excel, the Locked setting is a property of a cell, not a restriction that operates all the time. By default, cells are marked as locked, but that setting has no effect until you protect the worksheet. Once protection is on, Excel prevents editing in locked cells while allowing edits in unlocked cells.
This explains a common puzzle: a cell can show Locked as selected in Format Cells, yet you can still type into it. The sheet probably is not protected. Conversely, if you cannot edit a cell, the sheet may be protected and that cell may be locked. Protection can be applied to a whole sheet while leaving particular input cells unlocked.
Cell locking is useful for keeping formulas, headings, or carefully formatted areas from being changed by mistake while letting someone fill in designated fields. It is an editing safeguard, not a way to hide cell contents or provide strong protection for confidential information. Worksheet protection does not encrypt the workbook.
Unlock cells when the sheet is not protected
In Excel for Microsoft 365 on Windows, use these steps to change a cell’s Locked setting:
- Select the cell or range you want people to be able to edit. To select the entire worksheet, click the Select All button at the intersection of the row and column headings.
- Press Ctrl+1 to open Format Cells. On the Mac, press Command+1.
- Choose the Protection tab, clear the Locked check box, and click OK.
The cells are now marked as unlocked, but this change only has a practical effect when the worksheet is protected. If you want to preserve the restriction on other cells, turn sheet protection on using Review > Protect Sheet. In the dialog, choose which actions users may perform; you can also enter a password, though it is optional. Click OK and confirm the password if Excel asks.
For example, imagine a budget sheet with formulas in column D and blank input cells in column B. Select the intended input range in column B and clear Locked. Leave the formula cells locked, then protect the sheet. Users can enter figures in the input range, while attempts to overwrite protected formulas are blocked. Select only the cells that should be editable; unlocking the whole sheet would defeat that arrangement.
Remove protection from a worksheet
If Excel will not let you change a cell because the worksheet is protected, remove that protection before changing the Locked setting. In the Windows desktop app, select the sheet, go to Review > Unprotect Sheet, and enter the password if prompted. You can also find the unprotect command by right-clicking a sheet tab in some desktop layouts, but the Review tab is the clearest route.
After unprotecting, select the cells you want to change and clear Locked through Format Cells. If the sheet should remain protected, apply protection again after setting up the editable ranges. Unprotecting a sheet makes all cells editable until protection is reapplied, so remember to restore protection if other cells or formulas need that safeguard.
Excel may show a warning such as “The cell or chart you’re trying to change is on a protected sheet.” That message points to sheet protection, not necessarily a problem with the cell’s format. If the Review tab offers Unprotect Sheet, protection is active. If the command instead offers Protect Sheet, the worksheet is not currently protected, and the Locked setting alone is not preventing edits.
What to do if Excel asks for a password
A password prompt means the sheet’s protection was set with a password. If you know it, enter it to unprotect the sheet, adjust the cells, and optionally protect it again with the intended settings. If the file belongs to a colleague or organization, ask its owner or administrator for the password or for an editable copy. They may be able to provide a version with the desired cells unlocked.
If you have forgotten a password you set yourself, check your password manager, documentation, or an earlier copy of the workbook. Version history or a backup may contain an accessible version, depending on where the file is stored and how it was saved. Excel does not provide a normal command that reveals a forgotten worksheet-protection password. Avoid treating online “unlocker” tools or macros as a safe recovery method: they can expose sensitive data, damage a file, or violate workplace rules.
There is an important distinction between removing worksheet protection and opening a password-encrypted file. A password required before the workbook opens is file encryption, not a cell lock. Worksheet protection is removed from the Review tab after the workbook opens; file encryption is managed through File > Info > Protect Workbook > Encrypt with Password. Losing an encryption password can prevent access to the file, so use the owner’s recovery process or a valid backup rather than assuming Unprotect Sheet will help.
Cell, sheet, and workbook protection are different
Excel has several controls that sound similar but protect different things. Identifying which one is active helps you choose the right fix instead of changing unrelated settings:
- Cell locking: The Locked check box in Format Cells marks cells that will be restricted when their worksheet is protected. It does not lock a cell by itself.
- Worksheet protection: Review > Protect Sheet restricts actions on one worksheet. It can permit selected actions, such as selecting unlocked cells, while blocking edits to locked cells.
- Workbook structure protection: Review > Protect Workbook can prevent changes to workbook structure, such as adding, deleting, moving, or renaming sheets. It does not unlock cells on a protected worksheet.
- File encryption: The password used to encrypt a workbook controls whether the file can be opened. It is separate from worksheet and workbook-structure protection.
There is also a separate Hidden option in the Format Cells Protection tab. It can hide a cell’s formula from the formula bar when the sheet is protected; it does not hide the cell’s displayed value. If a formula is still visible, check whether Hidden is selected and whether sheet protection is active. Simply clearing Locked is not the same as making a formula visible.
Common problems and practical checks
If a cell still seems locked after you change its setting, check the situation in this order:
- Confirm the right sheet is active. Protection is applied per worksheet, and a workbook may contain several sheets with different settings.
- Check whether the sheet is protected. If it is, unprotect it before changing Locked. A protected sheet may also prevent you from opening or changing cell formatting.
- Verify the selected range. When multiple cells are selected, their settings may differ. In that case, the Locked box can show a mixed or indeterminate state. Select a smaller range to inspect or set it consistently.
- Check for other restrictions. A read-only file, permissions set by an organization, or a file opened in a restricted state can prevent editing for reasons unrelated to cell locking.
- Consider merged cells or a selection rule. A protected sheet may be configured to let users select unlocked cells only. You may be clicking a neighboring locked cell or a merged area that includes locked cells.
Conditional formatting, data validation, and a formula that returns a value do not themselves set the Locked property. They can affect what a user sees or enters, but they are different features. Likewise, marking a cell as unlocked does not guarantee that someone can edit it if another control, such as file permissions, is restricting the workbook.
Excel for Mac and Excel for the web
In Excel for Mac, the main workflow is similar: select the cells, open Format Cells with Command+1, and clear Locked on the Protection tab. Sheet protection and unprotection are available from the Review tab, though the dialog layout and ribbon presentation can differ from Windows. On Windows, Ctrl+1 is the Format Cells shortcut; use Command+1 on Mac rather than assuming Windows shortcuts will work.
Excel for the web has its own Review and protection controls, and the available options can differ from the desktop app. If you can unprotect the sheet in the web version but cannot find the cell-formatting control you need, open the workbook in the desktop app and use Format Cells. If the web app asks for a protection password, you still need the password; switching apps does not remove it. In all versions, make sure you are editing the intended workbook rather than a read-only or shared preview.
Choose a safe setup for a shared workbook
For a form or template, unlock only the cells intended for input, keep formulas and labels locked, and then protect the worksheet. In the Protect Sheet dialog, allow only the actions users actually need. For instance, a simple expense form may need users to select unlocked cells and enter values, but not format cells or delete rows. Test the setup by trying an input cell and a formula cell before sharing the file.
Keep an unprotected working copy in a secure location if you own the workbook and expect to revise its structure later. Use a memorable, securely stored password if you choose to set one, and share it through an appropriate channel with people who need it. For confidential information, use access controls and encryption appropriate to the data rather than relying on worksheet protection alone. Protection is most useful for preventing ordinary accidental edits, not for controlling access to sensitive information.
Frequently Asked Questions
How do I unlock a cell in Excel without a password?
If the worksheet is not protected, select the cell, press Ctrl+1, clear Locked on the Protection tab, and click OK. If the worksheet is protected and requests a password, you need the password or an authorized unprotected copy to change its protection.
Why can I type in a cell marked Locked?
Locked is only enforced while the worksheet is protected. If the sheet is unprotected, Excel lets you edit the cell even though its Locked box remains selected.
Can I unlock just one cell on a protected sheet?
First unprotect the sheet, unlock the desired cell through Format Cells > Protection, and protect the sheet again. You cannot change the Locked setting while normal worksheet protection is active.
Does unlocking a cell remove the password from the workbook?
No. Cell locking, worksheet protection, workbook-structure protection, and file encryption are separate controls. Changing one does not automatically remove the others.
Does protecting a sheet keep people from viewing its data?
No. Worksheet protection is intended to limit editing, not to secure confidential contents. Use file encryption and suitable access permissions when you need to restrict who can open or view a workbook.
Related
- Remove Duplicates in Power Query: A Practical Guide
- Power Query Basics: Import, Clean, and Transform Data
- Append Queries in Power Query: How to Combine Tables
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcut to Insert a Column in a SheetIn Excel for Microsoft 365 on Windows, select the column where the new one should go with Ctrl+Space,…
- Excel Row Groups: Grouping, Labels, and Naming LimitsYes—you can group rows in Excel with Data > Group, then expand or collapse the group using the…
- How to Create an Email Signature in Outlook on the WebTo create an email signature in Outlook on the web, open Settings (the gear icon), go to Accounts…
- How to Flip Numbers Upside Down in Excel: Two MethodsTo turn numbers visually upside down in Excel, put them in a text box and rotate the box…
- Outlook Signature Setup in Older Versions: Step by StepTo create a signature in classic Outlook for Windows, open File > Options > Mail > Signatures, select…
- Excel Merge Across vs. Merge Cells: Key DifferencesMerge Across makes a separate merged cell for each row in your selection, while Merge Cells combines the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.