If you forgot an Excel worksheet password, Microsoft Excel has no built-in way to reveal or reset it: ask the person who set it, or recover an earlier unprotected copy from a backup or version history. If the file is yours, first confirm that it is sheet protection—not a password required to open the workbook—because those are different protections with different recovery options.
What to try first
On Excel for Microsoft 365 for Windows, open the workbook and select Review > Unprotect Sheet. Enter the password if you know it. If Excel accepts it, the sheet is editable again. You can also ask the workbook owner or creator whether they have the password or an unprotected master copy. There is no “forgot password” link for worksheet protection, and Microsoft support cannot retrieve a lost sheet password.
If you do not know the password, pause before trying tools or changing the file. Make a separate copy of the workbook and preserve the original. Then check for a legitimate earlier copy, such as a previous version in OneDrive or SharePoint, a backup, an email attachment, or a file saved by a colleague. These routes are usually safer than attempting to alter the workbook itself.
- Ask the owner: A colleague, template author, or department administrator may have set the password and know the intended edit process.
- Look for an earlier file: Search for a dated copy or an unprotected source template.
- Check what you need to change: If you only need a value or report, you may be able to read or copy permitted content without unprotecting the sheet.
What worksheet protection does
Worksheet protection is mainly a way to prevent accidental or unauthorized changes to selected parts of a sheet. A workbook creator can lock cells containing formulas, leave input cells unlocked, and choose which actions other users may perform. For example, a budget template might allow users to enter expenses in designated cells while preventing them from overwriting formulas that calculate totals.
Protection does not necessarily hide the sheet’s contents. Depending on the settings, people may still be able to view data, select cells, use filters, or copy information. A protected sheet is therefore not the right way to keep confidential information secret. If a workbook is open and you can see its contents, sheet protection should not be treated as encryption or as a substitute for controlling access to the file.
Excel may protect individual worksheets separately. Removing protection from one sheet does not automatically unprotect other sheets in the workbook. Also, a sheet can be protected without a password; in that case, Review > Unprotect Sheet may remove protection without asking for one.
Recover an earlier version or backup
If the workbook is stored in OneDrive or SharePoint, check its version history. In Excel for Microsoft 365 on Windows, open File > Info > Version History when that option is available. You can also find the file in OneDrive or SharePoint and use its version-history controls. The exact display can vary with the organization’s setup and whether you are using the desktop app or browser.
Open or download an older version as a separate copy before restoring anything. Find a version saved before the sheet was protected, or before the password was changed. Confirm that it contains the data you need and that it is genuinely unprotected; an older version may still have the same protection. Restoring a version can replace the current file, so preserve a copy of the latest workbook first and follow your organization’s procedures for shared files.
Also check normal backup locations: a network drive, a backup service, a prior email attachment, or a copy kept by the workbook’s author. AutoRecover is designed to help recover unsaved work after an interruption; it is not a password-recovery feature and may not contain an unprotected version. Search by filename and date rather than assuming that every recovered copy will solve the problem.
Check whether you can complete the task without unprotecting
Sometimes the password is not actually needed for the job. A protected worksheet can still allow particular actions, depending on how its owner configured it. Try the intended workflow first: enter information in unlocked cells, use allowed filters, or copy visible results if copying is permitted. If you only need a figure, ask the owner to provide it or to make the requested change.
For example, suppose a monthly sales sheet shows the figures you need but prevents editing formulas. If your goal is to prepare a summary, you may be able to read the relevant totals or use an authorized copy of the data in a new workbook. That is different from changing the protected source. If you need to correct a formula or change the sheet layout, contact the owner and request an editable copy or the password.
On Excel for the web, available protection controls and prompts can differ from the Windows desktop app, and some workbook operations may require opening the file in desktop Excel. The web version does not provide a way to reveal a forgotten worksheet password. On a Mac, the same general method applies: use the Review tab and choose Unprotect Sheet, then provide the password if prompted.
Sheet protection is not the same as a password to open
Excel has several protections that are easy to confuse. A worksheet password blocks certain edits on one sheet. Workbook-structure protection, available through Review > Protect Workbook in desktop Excel, restricts changes to the workbook’s sheet structure, such as adding, deleting, moving, hiding, or renaming sheets. Neither should be confused with encrypting a workbook so that a password is required before its contents can be opened.
If Excel asks for a password before showing any workbook contents, you are likely dealing with file-open encryption, not ordinary worksheet protection. If you can open the file but cannot edit cells or change the sheet structure, the restriction is more likely sheet or workbook protection. A password to modify a file can also be different from a password to open it; read the prompt carefully.
For a forgotten password that encrypts the entire file, Excel does not offer a way to bypass the password and recover the contents. Look for a known password stored by the owner or organization, or retrieve an accessible backup. A password manager or another authorized record may help if the password was saved there. Do not assume that a password-removal tool for worksheet protection can decrypt a file that Excel will not open.
Be cautious with unlock tools and file edits
Search results may offer macros, websites, or instructions for changing workbook files to remove protection. These methods are not an official password-reset feature. They may be unreliable across file formats and Excel versions, and modifying a workbook can damage it or remove information you did not intend to change. An online service may also require you to upload the workbook, exposing business, personal, or confidential data.
Only work on a file you own or are authorized to modify. Before using any third-party software, consider your organization’s security rules and the sensitivity of the workbook. Do not enable an unknown macro just because a webpage says it will unlock a sheet; macros can make changes beyond the task you expected. If a workbook is important, keep the original untouched and ask your IT team or document owner for an approved recovery path.
There is a useful distinction here: worksheet protection is intended to control editing, not to provide strong secrecy. That does not make it appropriate to defeat protection on someone else’s file. Permission, data sensitivity, and the risk of damaging the workbook still matter.
Prevent the same problem next time
For a workbook you manage, keep a clear record of the password and what it protects. Store it in an approved password manager or another access-controlled location rather than in a note beside the workbook. Document which cells users may edit and who can provide the password. If a team depends on a template, assign an owner and retain an unprotected master in a restricted location.
- Keep a dated, access-controlled master copy before applying protection.
- Use version history or managed backups, and periodically confirm that recovery works.
- Tell collaborators whether a password protects a sheet, workbook structure, or the file itself.
- Use file encryption and appropriate access controls when the goal is to protect confidential contents, rather than relying on sheet protection.
For a shared template, consider whether protection is needed at all. Clear instructions, locked formula cells, and unlocked input cells can reduce accidental edits, but the people who maintain the file still need a reliable way to access the master. Keep passwords separate from broadly shared copies, and update the documentation when ownership changes.
Frequently Asked Questions
Can Microsoft recover a forgotten Excel sheet password?
No. Excel does not provide a feature to reveal or reset a forgotten worksheet password, and Microsoft support cannot retrieve it. Ask the owner or use a backup or earlier version that you are authorized to access.
Can I view a protected Excel sheet without the password?
Often you can view a sheet that is protected against editing, because worksheet protection does not necessarily hide its contents. What you can select, copy, filter, or change depends on the protection settings. This is different from a password-encrypted workbook that cannot be opened.
What if Excel asks for a password before the file opens?
That is likely a password-to-open restriction, not sheet protection. Excel cannot recover a forgotten encryption password. Check authorized password records and backups, and contact the file owner or your organization’s IT team.
Does Unprotect Sheet remove protection from every worksheet?
No. Worksheet protection is applied separately, so you may need to unprotect each sheet individually. Workbook-structure protection is a separate setting and may still prevent changes such as adding or renaming sheets.
Will an older version definitely be unprotected?
No. Version history only helps if a saved version predates the protection or password change. Open a separate copy and check it before restoring or replacing the current workbook.
Related
- Vending Inventory Spreadsheet: Track Stock and Reorders
- Excel Power Query: Get Data, Clean It, and Load It Easily
- Excel Power Query Fuzzy Matching Explained
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel: How to Sort Dates by Month Without Mixing YearsTo sort Excel dates by calendar month, add a helper column with the month number, then sort the…
- How to Remove Spaces in Excel With TRIM and SUBSTITUTETo clean extra spaces in Excel, use TRIM; to delete every ordinary space, use SUBSTITUTE. With the original…
- XLOOKUP in Excel 2016: Why It Fails and What to UseXLOOKUP does not work in the standalone desktop version of Excel 2016 because that version does not include…
- How to Find XLOOKUP in Excel and Use It in a FormulaTo find XLOOKUP in Excel for Microsoft 365 on Windows, open the Formulas tab and choose Lookup &…
- Excel Let Cell Overflow? How to Show Text Across CellsYes. In Excel for Microsoft 365 on Windows, text can overflow into the cells to its right when…
- Excel: Sort Dates from Oldest to NewestTo sort dates from oldest to newest in Excel for Microsoft 365 on Windows, click a date cell…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.