An Excel file does not have a universal password: the person who protects it chooses one. In Excel for Microsoft 365 on Windows, set a password required to open a workbook by choosing File > Info > Protect Workbook > Encrypt with Password, entering the password, and saving the file. That is different from protecting a worksheet or workbook structure, which limits certain changes but does not encrypt the file.
What an Excel file password can mean
People use “Excel password” to refer to several different protections. The distinction matters because each one controls a different kind of access, and the steps for removing one are not the same as the steps for removing another.
- Password to open: Excel asks for this before displaying the workbook. In a modern Excel file, this encrypts the workbook’s contents, so someone who does not know the password cannot simply open the file and read its cells.
- Worksheet protection: This can prevent actions such as editing locked cells, changing formatting, or inserting rows. It is intended to control editing, not to keep confidential data secret.
- Workbook structure protection: This can restrict changes to the workbook’s sheet structure, such as adding, deleting, moving, or renaming sheets. It does not encrypt cell contents.
- Password to modify: Some file settings let a person open a workbook as read-only or enter a password to make changes. This is an editing restriction, not the same as a password that encrypts the file for opening.
A workbook can have more than one type of protection at once. For example, a file may require a password to open and also protect individual sheets from accidental edits. If a prompt appears, its wording can help identify which kind of password Excel is requesting.
How to set a password required to open a workbook
These steps apply to the desktop version of Excel for Microsoft 365 on Windows. Save the workbook before changing its security settings, and choose a password you can retain safely.
- Open the workbook, then select File > Info.
- Select Protect Workbook > Encrypt with Password.
- Enter the password and select OK. Enter it again when Excel asks you to confirm.
- Save the workbook. The password protection takes effect when the file is saved.
- Close the file and reopen it to confirm that Excel requests the password.
Passwords are case-sensitive, so uppercase and lowercase letters must be entered consistently. Excel does not provide a way to display the password later, so check that you have recorded it correctly before relying on the protected file. If you use a password manager, store the password with a clear label identifying the workbook.
Excel for Mac has a different interface; in current desktop releases, password options are available from File > Passwords. The exact options can depend on the Mac version. Excel for the web does not provide the same desktop workflow for adding or changing workbook encryption, so use the desktop application for these steps.
How worksheet and workbook protection differ
To protect a sheet in Windows Excel, open the sheet and choose Review > Protect Sheet. You can choose which actions are allowed, such as selecting cells, sorting, or using filters, and optionally set a password. Before protecting the sheet, decide which cells users should be able to change. Cells are generally marked as locked by default, but the lock only takes effect after sheet protection is enabled.
To protect a workbook’s sheet structure, choose Review > Protect Workbook, then follow the prompts. This protection can help prevent someone from changing the arrangement or membership of sheets. It does not stop someone from reading data in an unencrypted file, nor does it secure a copy of the workbook that has been distributed elsewhere.
These features are useful for reducing accidental changes in a shared template or report. They are not substitutes for encryption when the goal is confidentiality. Microsoft cautions that worksheet protection is not intended as a security feature; it should not be treated as a reliable barrier against someone determined to access or alter the underlying data.
How to remove or change a password
If you know the password required to open a workbook, open it and go to File > Info > Protect Workbook > Encrypt with Password. In the password box, delete the existing characters, leave the box empty, select OK, and save the workbook. Reopen it to check that Excel no longer asks for a password. To change the password, replace the old one with a new one, confirm it, and save.
For sheet protection, select the protected sheet and choose Review > Unprotect Sheet. If Excel requests a password, enter the one used to protect that sheet. For workbook structure protection, use Review > Protect Workbook to turn off protection and enter the password if prompted. Menu labels or placement can vary slightly between releases, but the Review tab is the usual place for these controls.
If a file also has a password-to-modify setting, clearing the password-to-open encryption will not necessarily remove that separate restriction. Identify the exact prompt or protection setting you want to change, and test the saved copy before sending it to anyone.
What to do if you forgot the password
Excel does not provide a supported way to retrieve a forgotten password required to open an encrypted workbook. Microsoft cannot look up the password for you, and there is no universal Excel password. If the correct password is unavailable, practical recovery usually means finding another legitimate copy or locating the password in the place where it was originally stored.
- Check a password manager, secure team vault, or the documentation used when the file was created.
- Ask the workbook’s creator or the person who sent it to confirm the password and, if appropriate, provide a new protected copy.
- Look for an earlier version or backup in a company document system, OneDrive, SharePoint, or another backup location you are authorized to use.
- Search carefully for a copy that was intentionally saved without encryption, while ensuring it is an approved version and is stored securely.
Forgotten sheet-protection passwords are a different issue from forgotten encryption passwords because sheet protection is designed to restrict editing rather than hide the workbook’s contents. If you are responsible for the file, use an authorized original or ask its owner for an unprotected or corrected copy. Be cautious with websites and software claiming guaranteed password recovery: they may expose confidential files, install unwanted software, or make promises that cannot be verified. Do not upload a sensitive workbook to an unknown service.
Choosing and storing a secure password
Use a long, unique password that is not reused for email, work accounts, or other files. A memorable passphrase made from several unrelated words can be easier to manage than a short, predictable password. Avoid information others can readily guess, such as a person’s name, company name, project title, or a familiar date. A password manager can generate and store a unique value for each protected workbook.
Think about how the password will reach the people who need the workbook. Sending the file and its password in the same email or chat means a person who gains access to that message may get both. When practical, send the password through a separate, approved channel and limit the file’s access to the intended recipients. If someone leaves a project or no longer needs access, consider changing the password and distributing the updated file through a controlled location.
Encryption cannot prevent every kind of exposure. A recipient who knows the password can copy, print, photograph, or share information after opening the workbook. Password protection also does not replace device security, access controls, backups, or an organization’s rules for handling sensitive data.
File formats, sharing, and common problems
Modern Excel workbook formats such as .xlsx and .xlsm support password-based encryption when the password-to-open option is used. A macro-enabled .xlsm file still needs its own password protection; the presence of macros does not automatically secure workbook contents. Older .xls files use legacy formats and should not be assumed to provide the same protection as a current workbook format. When compatibility allows, use a modern format and verify the protection after saving.
A common source of confusion is treating a “protected” sheet as a private one. If a workbook contains information that recipients must not see, hiding a sheet or locking its cells is not a substitute for encrypting the file or removing that information. Another frequent problem is assuming that a password change applies to every copy. It does not: copies already downloaded or emailed remain separate files, so distribute the updated workbook and handle older copies appropriately.
If a password prompt appears unexpectedly, confirm that you are opening the intended file and using the correct capitalization. Check whether the prompt says the password is needed to open the workbook or to modify it. A read-only prompt may offer a way to open a file without editing, but that does not mean the workbook is encrypted in the same way as a file that cannot be opened without a password. If recipients cannot open a protected workbook in a browser, try the desktop version of Excel or ask the sender for an approved alternative; browser support for encrypted workbooks differs from desktop support.
When sharing permissions are a better fit
A password protects a file, but it can be awkward to manage when many people need access or when access must be withdrawn. For collaborative work, storing a workbook in OneDrive or SharePoint and sharing it with specific people can offer more manageable access controls than distributing password-protected attachments. Depending on the service and organization settings, the owner may be able to change or remove a person’s access without replacing every copy of the file.
Sharing controls and file encryption solve related but distinct problems. A password-to-open setting can help protect a file that is stored or transferred outside a managed sharing service, while cloud permissions control who can access a shared item through that service. Neither approach guarantees that an authorized recipient cannot copy information. Follow your organization’s requirements, and choose the method that suits the sensitivity of the data and the way people need to work with it.
Frequently Asked Questions
Is there a default password for an Excel file?
No. Excel does not assign one universal password to workbooks. A password-protected file uses a password set by its owner or creator, so ask that person or check an authorized password store.
Can I open an Excel file if I forgot its password?
If it is encrypted with a password required to open, Excel has no supported password-retrieval feature. Check backups, version history, password records, or ask the file owner for an accessible copy.
Does Protect Sheet encrypt an Excel file?
No. Protect Sheet restricts certain editing actions, but it is not designed to keep the workbook’s contents confidential. Use password-to-open encryption when the goal is to prevent people without the password from opening the file.
Can Excel for the web add a password to a workbook?
Use desktop Excel to set or change workbook encryption. Excel for the web does not offer the same password-encryption controls as the Windows desktop app, and encrypted workbook behavior in a browser can differ.
How do I remove an Excel password when I know it?
For a password required to open, open the workbook and use File > Info > Protect Workbook > Encrypt with Password. Clear the password box, confirm, save, and reopen the file to verify. Sheet protection is removed separately from the Review tab.
Related
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
- Excel Data Validation Source: Lists, Ranges, and Rules
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting to Compare Two Sheets in ExcelYes. In Excel for Microsoft 365, you can highlight differences between two sheets with a conditional-formatting formula that…
- IFERROR in Google Sheets: Meaning and How to Use ItIn Google Sheets, IFERROR checks whether a formula produces an error and lets you show a different value…
- Excel Keyboard Shortcut to Insert a Row or LineIn Excel for Microsoft 365 on Windows, select a row and press Ctrl+Shift+= to insert a worksheet row…
- Advanced Excel Shortcut Keys for Faster, More Accurate WorkAdvanced Excel shortcut keys help you navigate large worksheets, edit data in batches, control formulas, and work with…
- Google Sheets Filter: Show Only the Rows You NeedTo filter data in Google Sheets, select a cell in your table and choose Data > Create a…
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New Contact Group in classic Outlook or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.