To encrypt an Excel workbook so someone must enter a password to open it, use Excel for Microsoft 365 on Windows: go to File > Info > Protect Workbook > Encrypt with Password, enter and confirm a strong password, then save the file. This encrypts the workbook file; protecting a worksheet with Review > Protect Sheet is a different feature and does not provide the same confidentiality.
What “encrypting a sheet” means
People often say “encrypt a sheet” when they mean “stop other people from seeing my spreadsheet.” Excel has several kinds of protection, but only file-level password encryption is intended to prevent someone from opening and reading the workbook without the password. It applies to the workbook file as a whole, not to a single worksheet inside it.
Worksheet protection serves a narrower purpose: it can restrict editing of cells, formulas, or other worksheet elements. Workbook-structure protection can make it harder to add, delete, move, or rename sheets. Neither feature encrypts the contents against a person who can access the file. A recipient may still be able to view data in a protected sheet, copy information, or use other tools to inspect it.
This distinction matters when a workbook contains private information. If the concern is that an unauthorized person might obtain the file—for example, through an email attachment or a misplaced USB drive—use password encryption or an approved secure-sharing service. If the concern is accidental edits by a colleague who is allowed to see the data, worksheet protection may be appropriate.
How to encrypt a workbook in Excel for Windows
In desktop Excel for Microsoft 365 on Windows, use the built-in encryption command rather than relying on a worksheet password. The labels may vary slightly in older Excel releases, but the following is the standard route:
- Open the workbook and choose File > Info.
- Select Protect Workbook, then choose Encrypt with Password.
- Enter a password in the dialog and select OK. Enter it again when asked to confirm.
- Save the workbook. Close it, then reopen it to verify that Excel asks for the password.
Excel does not display the password again after it is set. Keep a secure record of it before closing the workbook, and share it with intended recipients through a separate, suitable channel when possible. Sending the workbook and its password together in the same unprotected message weakens the protection: anyone who gets that message has both pieces.
On a Mac, Excel’s password controls are available from File > Passwords in supported desktop versions; exact labels can vary by release. Excel for the web does not provide the desktop command for adding, changing, or removing file-open password encryption. A password-encrypted workbook may need to be opened in desktop Excel, so check the recipients’ software and collaboration needs before applying encryption.
File encryption versus sheet and workbook protection
Excel’s protection options answer different questions. Choose the one that matches what you need to prevent, rather than assuming that any password prompt encrypts the file.
- Encrypt with Password: Requires the password to open and read the workbook. This is the relevant Excel feature when the goal is to keep the file’s contents confidential from people who do not have the password.
- Protect Sheet: Limits selected actions on a worksheet, such as editing locked cells. Use Review > Protect Sheet to set it up. It is useful for reducing accidental changes, not for hiding sensitive data.
- Protect Workbook: The review-tab option protects workbook structure, such as whether users can add, delete, or rename sheets. It is not the same as the encryption command under File > Info.
- Permissions or sensitivity controls: Microsoft 365 organizations may offer access policies or sensitivity labels that control who can use a file. Availability depends on the organization’s subscription and configuration; these are not interchangeable with a password you set in Excel.
For example, suppose a workbook has a sheet with employee contact details and another with a budget. Protecting the budget sheet against edits may help preserve formulas, but it does not conceal the contact details. If the whole workbook must be unreadable to an unauthorized recipient, use file encryption or a managed access-control solution.
Choosing a password and keeping access recoverable
Use a unique, sufficiently long password that is difficult to guess. A memorable passphrase made from several unrelated words can be easier to manage than a short, predictable password. Avoid names, dates, company names, or familiar phrases, and do not reuse a password that protects an important account. A password manager is a practical place to store the exact password and identify which workbook it belongs to.
Plan for legitimate access as well as unauthorized access. If only one person knows the password and that person is unavailable, a team may lose access to an important file. For shared business records, agree on who is responsible for storing the password and how authorized staff can retrieve it securely. Keep a separate, protected backup if the data is important; encryption does not protect against accidental deletion, file corruption, or ransomware.
Excel does not provide a guaranteed way to recover a forgotten workbook encryption password. Microsoft support cannot simply reveal it, and a saved password in a browser or password manager is not the same as a recovery feature in the workbook. Do not remove or change a known password until you have confirmed that the replacement is stored correctly and that authorized users can still open the file.
Sharing an encrypted workbook safely
Before sending an encrypted file, consider how the recipient will open it. Desktop Excel is the most predictable option; web-based viewing, previews, third-party spreadsheet apps, automated processing, and some collaboration workflows may not support the same password-encryption behavior. Confirm compatibility with the actual people and systems that need the workbook.
Encryption does not decide who is allowed to receive the password. Send the file through an appropriate channel and communicate the password separately—for instance, by using an approved company password-sharing method rather than putting it in the same email as the attachment. For recurring collaboration, a controlled OneDrive or SharePoint sharing link with specific user permissions may be easier to manage than distributing a shared password, where that approach is available and suitable.
Cloud storage can add protections such as encryption in transit and at rest, but those protections do not automatically mean that only the people you choose can access a shared file. Review link settings, recipient permissions, and organizational policy. If you export the workbook as a PDF or copy its data into a CSV file, do not assume the new file inherits the Excel workbook’s password encryption. Protect the exported copy separately or use an approved secure-sharing process.
Common problems and how to address them
- The workbook opens without asking for a password: Check that you used File > Info > Protect Workbook > Encrypt with Password, not just Review > Protect Sheet or workbook-structure protection. Save, close, and reopen the file to test.
- A recipient cannot open it in a browser: Password encryption is a desktop-oriented feature. Ask the recipient to use a supported desktop version of Excel, or choose an approved sharing method that fits the required workflow.
- You can open it, but cannot edit certain cells: The worksheet may also be protected. If you have permission and the appropriate sheet password, use Review > Unprotect Sheet. The file-open password and sheet-protection password can be different.
- You need to remove a known file password: Open the workbook with the password, return to File > Info > Protect Workbook > Encrypt with Password, clear the password in the dialog, confirm, and save. Verify by closing and reopening the file.
- A password prompt appears unexpectedly: Confirm that you have the right password and are opening the intended copy. Check capitalization and keyboard layout, and ask the sender to confirm the password through a separate channel. Avoid repeatedly changing or resaving the file until you know which copy is authoritative.
When to use another protection method
Excel file encryption is useful when a password is an appropriate way to control access to a standalone workbook. It may be a poor fit when many people need frequent access, when access must be revoked for one person without changing a shared password, or when a process depends on browser editing or automated tools. In those cases, a managed cloud location with named-user permissions may offer clearer control, subject to your organization’s policies.
If the goal is to distribute only a limited view of the information, make a separate copy containing only the data that recipients need. Hiding a sheet or column is not a reliable way to keep it secret; hidden content may be revealed by someone who can work with the file. Likewise, a protected worksheet is not a substitute for removing confidential data before sharing. Apply the least-access approach that meets the real need, and check every copy or export you send.
There is no single option that prevents every kind of disclosure. A person who is authorized to open a workbook may be able to record or copy information they can see. Encryption protects the file while access is restricted; it does not control what a legitimate recipient does with the contents after opening it. For sensitive organizational data, follow the applicable security policy and ask an administrator about approved storage, sharing, and retention controls.
Frequently Asked Questions
Can I encrypt just one Excel worksheet?
Excel’s built-in Encrypt with Password command encrypts the workbook file, not an individual sheet. You can protect a sheet from certain edits, but that does not conceal its contents. If only selected information should be shared, create a separate workbook that excludes the rest.
Is Protect Sheet the same as encrypting an Excel file?
No. Review > Protect Sheet restricts certain changes to a worksheet; it is mainly useful for preventing accidental edits. File encryption is set through File > Info > Protect Workbook > Encrypt with Password and requires a password to open the workbook.
Can I open a password-encrypted workbook in Excel for the web?
Excel for the web does not add, change, or remove this file-open password protection, and encrypted files may require desktop Excel to open. If web collaboration is essential, confirm the current behavior with your organization’s Microsoft 365 setup before encrypting the only working copy.
What happens if I forget the Excel encryption password?
There is no guaranteed recovery option built into Excel for a forgotten file-open password. Check your password manager or secure team records, and ask the person who created the workbook. Keep a verified backup and password record before relying on encryption for important files.
Does a password-protected Excel file stay protected when I export it?
Do not assume so. A PDF, CSV, or other exported copy is a separate file and may not retain the workbook’s encryption. Apply suitable protection to the export itself, or share it through an approved service with appropriate access controls.
Related
- CSV vs Excel: Key Differences and When to Use Each
- Delivery Schedule Excel: Create and Manage a Delivery Plan
- Default Borders in Excel: What They Are and How to Set Them
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 Table With 3 Variables: Limits and WorkaroundsExcel’s What-If Analysis Data Table cannot vary three input cells in a single table: it supports one or…
- Google Sheets: Color Cells Based on CheckboxesYes. In Google Sheets, use conditional formatting to change a cell’s fill color when its checkbox is checked:…
- Insert Paste Row Shortcut in Excel: Keyboard GuideIn Excel for Microsoft 365 on Windows, copy the row, select the row number where it should go,…
- Excel Cut Shortcut: How to Move Cells with Ctrl+XIn Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+X to cut it;…
- How to Insert a Digital CAC Signature in Microsoft WordTo insert a digital CAC signature in Word on Windows, connect your CAC reader, open the document, and…
- Why Can’t I Add Slide Numbers in PowerPoint?You usually can add slide numbers in PowerPoint through Insert > Header & Footer: select Slide number on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.