To unlock Excel, first identify what is blocking you: a protected sheet or workbook needs its password, a read-only file needs its access or file setting fixed, and a Protected View document needs to be trusted before editing. In Microsoft 365 for Windows, start on the Review tab for protection controls; do not try to bypass a password on a file you are not authorized to change.
Excel uses the word “locked” for several different situations. Sheet protection restricts changes to cells, workbook protection restricts structural changes such as adding or moving sheets, and file encryption can prevent the workbook from opening at all. Read-only status, a file being open elsewhere, or Protected View can also prevent editing without being password protection. The right fix depends on which message or control you see.
What You’ll Need
- The workbook saved in an accessible location, and permission from its owner to change it.
- The protection password if a sheet, workbook structure, or file is password-protected. Excel does not provide a supported way to reveal or bypass a forgotten password.
- Microsoft Excel for Microsoft 365 on Windows for the steps below. On a Mac, the Review tab has similar protection commands; Excel for the web has fewer controls, so open the file in the desktop app if a command is missing.
- A separate copy of the workbook if you are about to change protection, file settings, or permissions. Keep the original until you have confirmed the copy works.
Step-by-Step
-
Check what kind of lock you have. If the workbook opens but certain cells cannot be changed and Excel says the sheet is protected, it is likely sheet protection. If you cannot add, delete, rename, move, hide, or unhide sheets, workbook-structure protection may be on. If Excel asks for a password before showing any workbook contents, the file itself is encrypted. A yellow Protected View bar or a Read-Only label points to a different issue, not necessarily a protected sheet.
Read the exact prompt before trying a fix. If you can select cells but cannot type into them, the sheet may be protected with only some cells locked. If you cannot open the file at all, steps for unprotecting a worksheet will not solve the problem; you need the file-opening password or help from the person who created it.
-
Make a working copy when the file opens. Choose File > Save As and save a copy in a location where you have permission to make changes. Use a new name so it is easy to distinguish from the original. A copy is useful in case a later change affects formulas, layout, or shared access. If Save As is unavailable because the file is controlled by an organization, ask its owner or IT administrator before changing access.
-
Unprotect a worksheet with the authorized password. Click the sheet tab that contains the cells you need. Select Review > Unprotect Sheet. If Excel requests a password, enter the password supplied by the workbook owner and confirm. In some workbook layouts, you can also right-click the sheet tab and choose Unprotect Sheet. Once protection is removed, try editing a cell and save the copy.
If you do not know the password, ask the creator or the person who manages the workbook for it, or request an unprotected copy or the specific change you need. Do not use a password-removal tool or instructions that promise to defeat protection. Apart from authorization concerns, such methods can damage the workbook or expose its contents.
-
Remove workbook-structure protection if sheet tabs are restricted. Select Review > Protect Workbook. If structure protection is enabled, Excel prompts for its password; enter the authorized password to turn that protection off. Then try the intended action, such as renaming a sheet. This control is distinct from Unprotect Sheet: removing worksheet protection alone does not necessarily let you add, move, or rename tabs.
Some versions show a highlighted Protect Workbook control when structure protection is active. If the control is unavailable or the command is not visible, check that you have the workbook open in the desktop app and that it is not in a restricted or shared state. Excel for Mac has a similar command on Review, although its ribbon layout can differ slightly.
-
Unlock only the cells that should be editable, if you own the sheet. First use Review > Unprotect Sheet and enter the password. Select the cells that colleagues should be able to change, then press Ctrl+1 on Windows to open Format Cells. On Mac, use Command+1. Open the Protection tab, clear Locked, and select OK. When you turn sheet protection back on from Review > Protect Sheet, those selected cells remain editable while the other locked cells are protected.
By default, Excel marks cells as locked, but that setting does not restrict editing until sheet protection is turned on. This is why simply clearing Locked on a cell may appear to do nothing, or why protecting a sheet can suddenly make many cells unavailable. Test the permissions on the saved copy before sharing it.
-
Handle a password prompt that appears before the workbook opens. This is file-level encryption, not ordinary sheet protection. Enter the correct password from the owner or your organization. If you are the owner and have forgotten it, check your password manager, secure records, or an earlier authorized copy. Microsoft cannot retrieve an encrypted workbook password for you, and there is no supported recovery switch in Excel. Avoid uploading confidential workbooks to unknown recovery services.
-
Resolve Read-Only status or Protected View separately. If the file opens in Protected View with a security notice, choose Enable Editing only when you recognize the file and trust its source. If Excel labels the workbook Read-Only, use File > Save As to create a writable copy if you are allowed to do so. On Windows, you can also close Excel, right-click the file in File Explorer, choose Properties, and clear Read-only under Attributes if it is selected and you have permission. Select Apply, reopen the file, and check whether editing is available.
For a file stored on OneDrive, SharePoint, or a company network, verify that your account has edit permission. A local file attribute cannot override a cloud sharing restriction. Ask the owner to change your access from view to edit if needed.
-
Save, close, and verify the result. Save the copy, close it, and reopen it. Confirm that the intended cells or sheet actions are available and that formulas, formatting, and other sheets remain intact. If you changed which cells are unlocked, test both an allowed cell and a cell that should stay protected. Keep the original file unchanged until the owner or users confirm the new version behaves as intended.
Common Mistakes
Confusing protection types. Unprotect Sheet affects a worksheet; it does not remove a password required to open the file or necessarily unlock workbook structure. Identify the prompt and the blocked action before changing settings.
Assuming every locked cell is protected. Cell formatting can mark a cell as Locked while the sheet itself remains unprotected. The Locked setting only restricts editing after sheet protection is enabled.
Choosing Enable Editing without checking the source. Protected View is a safety measure for files from potentially unsafe locations. Enable editing only for a document you expected and trust; do not treat the button as a general unlock command.
Overwriting the shared original. Removing protection or changing permissions may affect other people’s work. Save a separate copy when appropriate and coordinate with the owner, especially for shared finance, inventory, or reporting workbooks.
Trying random passwords or third-party unlockers. Repeated guesses waste time, and untrusted software can expose sensitive data. Ask the owner or administrator instead. If a password prompt appears before opening, worksheet-unprotect steps cannot remove file encryption.
Tips
- Ask the workbook owner which cells or actions should be available before removing protection. They may be able to provide a version with only the needed range unlocked.
- If you manage the workbook, document the protection password securely and tell authorized editors where to request access. Do not store it in a visible worksheet beside the protected data.
- Use Save As to make a clearly named working copy before changing settings. Keep a record of which version is the approved shared file.
- For repeat editing, consider asking the owner to unlock designated input cells and leave formulas and headings protected. This reduces accidental changes to calculations without blocking routine data entry.
- In Excel for the web, open the workbook and choose Open in Desktop App when protection commands or file settings are unavailable. The desktop app is also a better option for diagnosing a workbook that is read-only or has complex protection settings.
- On a Mac, use the Review tab for sheet and workbook protection, and Command+1 for Format Cells. Ribbon labels and placement can vary by update, but the protection task is the same.
Troubleshooting
Unprotect Sheet is missing or disabled: Make sure the correct worksheet is selected and that the workbook is open in Excel, not just previewed in File Explorer or a browser. If you have view-only access, ask the file owner for edit permission. In Excel for the web, use Open in Desktop App if the needed control is not available.
The password is rejected: Check for accidental spaces, Caps Lock, and whether the password was intended for this particular sheet or workbook. Passwords are case-sensitive. Ask the person who set the protection to confirm the correct password and the protected item. Do not assume a file-opening password is the same as a sheet password.
You can edit some cells but not others: That may be the intended setup. Ask which ranges are designed for input. If you administer the workbook, unprotect the sheet with its password, adjust Locked for the appropriate cells, and protect the sheet again. Test the result before sharing it.
The file says it is locked for editing by another user: Check whether a colleague has it open and ask them to close it, or wait for a cloud sync to finish. Confirm that you are signed into the account with edit access. If the message persists after other editors close the file, save a separate copy if permitted, restart Excel, and contact the owner or IT support rather than deleting temporary or shared files.
Enable Editing is unavailable or the file stays read-only: The file may be blocked by your organization, stored in a location where you have view-only access, or marked read-only by its owner. Check File > Info for notices, try Save As if allowed, and ask the owner or administrator to review the permissions. Do not change security settings to force access.
Excel itself says it is not activated: That is an Office licensing issue, not workbook protection. In Excel, check File > Account and sign in with the Microsoft account or work account that has the Microsoft 365 license. If the account is correct but activation still fails, contact your organization’s administrator or Microsoft support. Unlocking a sheet will not restore editing features in an unlicensed app.
Frequently Asked Questions
Can I unlock an Excel sheet without the password?
Excel has no supported method for bypassing a sheet-protection password. Ask the owner or creator for the password, an authorized unprotected copy, or the change you need. For an encrypted file that will not open, you need its file password.
What is the difference between Unprotect Sheet and Protect Workbook?
Unprotect Sheet removes restrictions on cells and other actions within the selected worksheet. Protect Workbook can restrict changes to workbook structure, such as adding, deleting, moving, or renaming sheets. A password or setting for one does not automatically remove the other.
Why can I select a cell but not type in it?
The worksheet may be protected and that cell may be marked Locked. If you own the workbook, unprotect the sheet with its password, change the cell’s Locked setting through Format Cells, and protect the sheet again if needed.
Will unlocking a worksheet change its formulas?
Removing sheet protection does not itself rewrite formulas, but it lets editors change cells that were previously restricted. Work on a copy and review important formulas after editing, especially in shared or business-critical workbooks.
Can I unlock Excel in a browser?
Some basic workbook editing works in Excel for the web, but protection and file-management controls may be limited or vary by workbook. Choose Open in Desktop App for the Microsoft 365 desktop version when a required control is missing, and make sure you have edit permission.
What should I do if the workbook belongs to my workplace?
Contact the file owner or IT administrator and explain the exact message and the change you need. They can confirm your access, provide the proper password, or supply a version with suitable permissions. Do not try to bypass company security controls.
Related
- How to Show Negative Numbers in Brackets in Excel
- How to Share Excel in Real Time and Co-Edit Safely
- How to Share an Excel Workbook in Windows 11 Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation List From Another Sheet: StepsTo create an Excel data-validation dropdown from another worksheet, put the choices on that sheet, define a workbook-level…
- Excel Hyperlink Shortcut: How to Add a LinkTo add a hyperlink in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+K. Choose…
- Change Your Calendar View in Outlook: A Step-by-Step GuideTo change your calendar view in Outlook, open Calendar and choose Day, Work week, Week, or Month from…
- How to Highlight Past Dates in Excel AutomaticallyTo highlight dates before today in Excel, select your date cells and create a formula-based conditional formatting rule…
- How to Check Double Spacing in WordTo check whether text is double-spaced in Word, place the cursor in a paragraph or select the paragraphs,…
- How to Group Same Names in Excel by Sorting or SummarizingTo group identical names together in Excel, select the entire data range, choose Data > Sort, and sort…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.