Unprotect an Excel sheet or workbook you own
Excel can protect a worksheet's cells, a workbook's structure, or the entire file at opening. Those controls are different. If you can see the spreadsheet but cannot edit a cell, do not assume the file is encrypted. If Excel asks for a password before showing anything, the worksheet commands cannot solve that prompt.
Use these instructions for a workbook you own or are authorized to edit. The Office file guide covers broader file-password situations. This page focuses on worksheet and workbook protection so that a visible spreadsheet does not lead you toward irrelevant account resets or file-unlocking services.
1. Identify which Excel protection is active
Microsoft's Excel protection overview distinguishes file encryption, workbook structure, and worksheet restrictions. Note exactly when the prompt appears. Opening the file, renaming a sheet, and editing a protected cell point to different controls.
If the workbook is shared by a colleague, ask what changes you are authorized to make. Some cells may intentionally remain editable while formulas and headings are protected. The fact that you can view the workbook does not mean you should remove every restriction.
Keep an unchanged copy before making an authorized protection change. This preserves formulas and layout if you later discover that the restriction prevented accidental edits. Label the working copy clearly so you do not overwrite the source while still diagnosing the problem.
2. Unprotect a worksheet using its password
Microsoft's worksheet instructions describe the Review tab and Unprotect Sheet command in supported desktop versions. Select the relevant sheet, choose the unprotect command, and supply its password if prompted. Follow the instructions for your Excel version when the interface differs.
If no password was applied, the command may remove protection without one. If a password is required, obtain it from the person who protected the sheet or your own secure record. A Microsoft account password is not automatically the password chosen for the worksheet.
Afterward, make the intended edits and check formulas, validation, and any locked areas you meant to preserve. You can reapply appropriate protection when finished. Removing all protection permanently is not necessary just because one authorized change was needed.
3. Treat workbook structure separately
Microsoft's protection overview explains that workbook protection can restrict actions such as adding, moving, hiding, or renaming sheets. If those actions are the problem, inspect the workbook-structure protection rather than repeatedly unprotecting an individual worksheet.
Use the workbook protection control described by Microsoft and enter the correct password where required. A workbook and its sheets can use different passwords. Keep those records labeled by file and purpose so a later editor knows which one applies.
If you can edit cells but cannot rearrange sheets, that is useful diagnostic information to give the file owner. Ask for the specific authorized change or an editable copy. There is no need to send the entire workbook to an unknown website merely to identify the protection type.
4. When the protection password is forgotten
Microsoft's Excel security guidance says Microsoft cannot retrieve forgotten passwords. Look for the person who set the restriction, an earlier authorized version, or the underlying data source. If the workbook came from an organization, ask its document owner or IT team about maintained copies.
Check version history or backups you are entitled to access, keeping the current original intact. Compare dates and formulas before adopting an older copy; an editable workbook is not necessarily the most accurate one. You may be able to rebuild the permitted work from source data without recovering the original password.
Microsoft says worksheet protection is intended to control editing rather than provide strong security for sensitive data. That distinction does not grant permission to bypass it. An encrypted file-open password has a different, potentially permanent recovery limit.
Avoid changing the file just to make the warning disappear
Do not follow instructions to alter internal file parts without understanding the authorization and integrity consequences. A workbook can contain formulas, links, and business rules that matter more than the visible grid. This guide uses supported controls and legitimate replacement sources rather than bypass procedures.
If a website asks you to upload a confidential spreadsheet to remove protection, consider what the file contains. Names, internal calculations, and hidden sheets can be included even when the visible page looks harmless. Keep recovery with the owner or organization that can authorize access.
After you regain editing access
Validate the edited workbook against the original and save a clear version. Record the protection purpose and owner, store any required password securely, and maintain a recoverable source copy. For sensitive material, choose the appropriate access controls rather than relying on locked cells to provide confidentiality.
If Excel instead asks for a password before opening the file, return to the Office password guide. Identifying the right layer keeps an ordinary sheet-editing problem from turning into a destructive or misleading attempt to reset unrelated account credentials.
Instructions checked against vendor guidance on 24 September 2026.