Excel Sheet Password Remover: Safe Ways to Unlock It

How-to basics · Updated November 21, 2026

If you know the worksheet password, open the sheet in Excel for Microsoft 365 on Windows and choose Review > Unprotect Sheet, then enter the password. If you have forgotten it, Excel has no supported password-removal button or universal recovery method; look for the password, ask the workbook owner, or restore an authorized earlier copy rather than trusting an unknown remover.

What Excel sheet protection does

Protect Sheet is a worksheet-level control. It can prevent changes to locked cells and limit actions such as formatting cells, inserting rows, or sorting, depending on the options selected when the sheet was protected. It is commonly used to reduce accidental edits to a template, calculation sheet, or shared report. It is not the same as encrypting a file so that nobody can open or read it.

By default, cells in a worksheet are marked as locked, but that setting has no effect until sheet protection is turned on. A workbook creator can unlock input cells first and then protect the sheet, allowing people to enter values in designated places while keeping formulas or layout safer from casual edits. Protection is useful for workflow and error prevention, but it should not be treated as a strong confidentiality boundary.

Three controls are often confused:

  • Worksheet protection restricts selected actions on one sheet. A workbook may have several protected sheets, each with its own password or protection settings.
  • Workbook-structure protection restricts structural changes, such as adding, deleting, moving, hiding, or renaming sheets. It is controlled separately from protecting a sheet.
  • Password to open encrypts the workbook file. Excel asks for this password before opening the contents. This is fundamentally different from a worksheet protection prompt.

Knowing which control is in effect matters: unprotecting a sheet will not remove a password required to open the file, and opening a workbook does not necessarily grant permission to edit every sheet.

Remove protection when you know the password

In the Windows desktop version of Excel for Microsoft 365, select the protected worksheet and go to Review > Unprotect Sheet. If prompted, type the password and confirm. Depending on the workbook and Excel window size, the command may be visible in the Protect group on the Review tab. You can also right-click the sheet tab and look for Unprotect Sheet in the context menu.

After protection is removed, make the changes you need. To leave the sheet unprotected, save the workbook. To protect it again, use Review > Protect Sheet, choose which actions users may perform, and enter a new password if appropriate. If you are changing the password, unprotect the sheet with the old one first, then protect it again with the new one. Keep the replacement in an approved password manager or another secure place; Excel will not show you a forgotten password later.

On Excel for Mac, select the sheet and use Review > Unprotect Sheet; the wording and arrangement can vary slightly by release. In Excel for the web, protection controls are available from the Review tab, but available options can differ from desktop Excel. If the web interface asks for the password and you do not have it, switching to the desktop app does not reveal the password or automatically remove the protection.

Unprotection applies to the selected sheet only. If three sheets are protected, repeat the process for each one for which you have authorization and the correct password. Removing worksheet protection also does not necessarily remove workbook-structure protection, so check that separately if commands for managing sheet tabs remain unavailable.

If you forgot the password

Excel does not provide a supported way to display or reset a forgotten worksheet password. Microsoft Support cannot look up a password stored in a workbook, and repeatedly trying guesses may waste time or trigger restrictions in managed work environments. The practical recovery route is to find an authorized copy or obtain the password from the person or team responsible for the file.

Try these sources before installing software or changing the workbook:

  • Ask the workbook creator, current owner, or organization’s IT or records team. They may have documented the password or be able to provide an editable copy.
  • Check your approved password manager, handover notes, project documentation, or other secure team records. Avoid sending a password through an insecure channel.
  • Look for a backup or earlier version in OneDrive, SharePoint, or your organization’s backup system. Version history may let you restore a copy from before protection was applied, but it may also restore older data, so compare versions before replacing anything.
  • Check whether the sender can share an unlocked copy or make the specific change on your behalf. This is often safer than attempting to alter a file whose origin or permissions are unclear.

Version history is not a password-recovery feature: it only helps if a usable earlier version exists and you are permitted to access it. Save or download a separate copy before restoring an older version, and verify that important recent entries are not lost. AutoRecover may help after a crash, but it is not a reliable archive of prior protection settings.

How to tell which password you are dealing with

Notice when Excel asks for a password. If the prompt appears before workbook contents open, it is an opening password and the file is encrypted. If the workbook opens but a particular worksheet will not allow edits, it is likely worksheet protection. If you can edit cells but cannot rename, move, add, delete, hide, or unhide sheets, workbook-structure protection may be enabled.

There are other reasons editing can be blocked. A file may be read-only, opened in Protected View, locked for editing by another user, or governed by organizational permissions. These situations do not necessarily involve a sheet password. Check the title bar and any yellow security banner, confirm that you have an editable copy, and ask the file owner or administrator if access is controlled by a work account.

A useful example: suppose a budget workbook opens normally, but the formula cells on the Summary sheet cannot be changed. That points toward worksheet protection. If Excel instead asks for a password before showing any sheets, it is an opening-password issue. If the numbers are visible but the sheet tabs cannot be rearranged, investigate workbook-structure protection. Identifying the prompt prevents using the wrong recovery approach.

What password-remover tools can and cannot promise

Search results for an Excel password remover may advertise instant unlocking, password recovery, or a free online service. Treat those claims cautiously. Some products attempt to guess a password, which can take an impractical amount of time if the password is long or complex. Other tools may target particular older file formats or protection mechanisms. Compatibility, reliability, and privacy practices vary, and no third-party tool can be assumed to recover every password.

Do not upload a sensitive workbook to an online service unless your organization has approved that service and you understand how it handles files. A workbook may contain customer data, employee details, financial records, or confidential formulas. Installing an unknown program also creates malware and data-leak risks. A tool asking you to disable security software, provide unrelated account credentials, or pay before revealing basic terms deserves particular skepticism.

Worksheet protection is designed mainly to prevent accidental or casual edits, not to encrypt worksheet contents. That fact does not make bypassing an owner’s restrictions appropriate, nor does it make a remover safe. If you do not own the file or have permission to change it, ask the owner for access. For a business-critical workbook, use your organization’s approved recovery and data-handling process.

Safe practices before changing a workbook

Before removing protection or trying a recovery option, preserve the original. Use File > Save As to create a separate working copy when you can open the workbook, or duplicate the file in its approved storage location. Give the copy a clear name and keep it in a location with the same access controls as the original. This makes it easier to compare changes and reduces the chance of overwriting the only usable version.

Confirm that you have permission to make the change and know what the protection is intended to safeguard. A protected sheet may contain formulas that feed a report, validation rules that control data entry, or cells deliberately hidden from ordinary editing. After authorized changes, check key formulas, input areas, print layout, and any dependent sheets. If the workbook is used by a team, tell its owner what changed and whether protection was restored.

When protecting a sheet again, use a unique password and document it securely. Do not assume that a password used to open an encrypted workbook behaves like a sheet password: they protect different things. If the contents must remain confidential, use appropriate file encryption and access permissions rather than relying on worksheet protection alone.

Common problems and practical alternatives

If Unprotect Sheet is unavailable or the command does not seem to work, first make sure you selected the intended worksheet. Check whether the workbook is in a mode that limits editing, such as Protected View, or whether an organization’s permission controls are involved. Close and reopen a working copy if the file appears to be read-only, but do not discard unsaved changes. If the prompt rejects a password, check capitalization and any documented formatting conventions; passwords are case-sensitive.

For a protected sheet you are allowed to use but cannot edit, ask the owner to unlock only the cells you need or to provide an input version. This can be better than removing all protection, especially in shared templates. If the owner is unavailable and you only need to read the data, ask whether they can provide a PDF or values-only export. Copying visible data into a new workbook may be possible when selection is allowed, but it can omit formulas, formatting, validation, hidden content, or other workbook features, so it is not a faithful recovery method.

Macros and online instructions that claim to remove protection by altering workbook internals are not a Microsoft-supported password-recovery process. They may depend on file format or Excel version, can damage a workbook, and may conflict with the file owner’s permissions. Avoid running code from an untrusted source, especially on a production workbook. If the file matters, retain an untouched copy and consult the owner or your IT team rather than experimenting on the original.

Frequently Asked Questions

Can I remove Excel sheet protection without the password?
Excel has no supported universal method to remove a forgotten worksheet password. Ask the owner for the password or an unlocked copy, or check authorized backups and version history. Do not assume a third-party remover will work or is safe.

Does Protect Sheet encrypt the worksheet?
No. Worksheet protection restricts editing actions; it is not the same as encrypting a workbook with a password required to open it. Do not use sheet protection to keep confidential information secret from someone who can access the file.

Will removing a sheet password remove the password to open the file?
No. These are separate protections. Unprotect Sheet concerns editing a worksheet after the workbook is open. An opening password must be handled separately, and Excel does not provide a way to reveal a forgotten one.

Can I unlock every protected sheet at once?
There is no standard one-click command that removes protection from all sheets with unknown passwords. With the correct password and permission, unprotect each sheet individually. Workbook-structure protection is a separate control.

Is a free Excel password remover safe?
Not automatically. Tools vary in what they support and how they handle files, and an online service may expose sensitive workbook contents. Use only tools approved by your organization, and prefer the owner, a trusted backup, or a documented recovery process.

Related

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.