To encrypt an Excel workbook on a Mac, open it in Excel, choose File > Passwords, enter a password in Password to open, confirm it, and save the workbook. This password protects the file itself; Review > Protect Sheet is a different feature that restricts editing but does not encrypt the workbook.
What Excel file encryption does
A password to open adds a barrier before Excel will display the workbook’s contents. For a modern Excel workbook saved as an .xlsx or .xlsm file, this is file-level encryption: someone who obtains the file still needs the password to open and read its contents in Excel. It is the relevant choice when the goal is to keep private information confidential, rather than merely prevent accidental changes.
Encryption is not the same as hiding a sheet, locking cells, or setting a password to modify. Those controls can help manage routine use, but they do not offer the same protection for confidential data. A determined person may be able to remove ordinary worksheet or structure restrictions from a copy of a file. A password-to-open barrier is designed to protect the workbook’s contents, not simply its layout.
Excel for Mac’s menus and dialog wording can vary somewhat by release and file format. In current Microsoft 365 for Mac, look for File > Passwords. If that command is missing, check that the workbook is open in the Excel desktop app and update Excel; do not assume that a sheet-protection command provides equivalent encryption.
Set a password to open a workbook
Use these steps in Excel for Microsoft 365 on Mac. Save a working copy first if the workbook is important, especially if you are changing a password on an existing file.
- Open the workbook in Excel. If it is a new file, save it in a modern Excel format such as .xlsx before applying protection.
- Choose File > Passwords from the macOS menu bar.
- In the Passwords dialog, type a strong password in Password to open, then enter it again when prompted to confirm.
- Leave Password to modify blank unless you specifically want to set a separate editing restriction. It is not a substitute for the password to open.
- Choose OK, save the workbook, and close it.
- Reopen the saved file and enter the password to verify that the protection is working. Do this before sharing or deleting any unprotected copy.
Excel may ask for confirmation when you save or close, depending on the version. The important check is to close the file and test the saved copy: a password dialog appearing when the file is reopened confirms that you applied the password-to-open setting to that copy, rather than only making an unsaved change.
Choose the right kind of protection
Excel offers several password-related controls, and their names can make them sound more alike than they are. Choose based on what you need to prevent:
- Password to open: Encrypts the workbook so that the contents are not available in Excel without the password. Use this for confidentiality.
- Password to modify: Can require a password to edit, while allowing a recipient to open the file as read-only. It is an editing control, not the same as encrypting the file against access.
- Protect Sheet: Restricts changes to a worksheet, such as editing locked cells. In Excel for Mac, the command is on Review > Protect Sheet. It does not keep someone from viewing the sheet’s data.
- Protect Workbook: Restricts workbook-structure changes, such as adding, deleting, or moving sheets. This is not the same as a password required to open the file.
For example, a budget workbook shared with a colleague might need sheet protection to prevent accidental edits to formulas. If the workbook also contains confidential salary or account information, sheet protection alone is not enough: use a password to open, and share the password through a separate secure channel.
Make a strong password and keep it recoverable
Choose a password that is difficult to guess and not reused from another account. A long, unique passphrase is often easier to store safely than a short mixture of symbols and familiar personal details. Avoid names, dates, company names, and simple patterns. Anyone who knows the password can open the workbook, so do not include it in the same email or message as the attachment.
Store the password in an approved password manager or another secure place that authorized users can access. Consider how a colleague will retrieve it if you are unavailable, and decide who should have access before the file is sent. A password that is strong but lost can make a workbook unusable to its owner as well as to other people.
Microsoft generally cannot retrieve a forgotten password for an encrypted workbook. Do not rely on a remembered hint alone, and do not treat the original file as a safe place to experiment with passwords. Keep a protected backup and verify the password before distributing the only copy.
Remove or change the password
To remove the password from a workbook you can open, use File > Passwords, clear the entry in Password to open, confirm the change if Excel asks, and save the workbook. Close and reopen the saved file to check that Excel no longer requests that password. Menu details can differ between Excel releases, so verify that you are clearing the opening password rather than changing a sheet or workbook-structure setting.
To change it, open the workbook with its current password, go to File > Passwords, replace the existing password-to-open entry, confirm the new password, and save. Test the new password by reopening the saved file. If you are preparing a version for a recipient who should not need a password, make a separate copy and remove protection from that copy; keep the encrypted original if you still need it.
Common problems on a Mac
If Excel does not show File > Passwords, first confirm that you are using the Excel desktop application rather than viewing the file in a browser or another spreadsheet app. Check for Office updates and confirm that the workbook is saved in a current Excel format. Older formats, protected files, and compatibility situations may expose different options. If a command is still unavailable, consult the help for the installed Excel version rather than substituting sheet protection.
If the file opens without asking for a password, you may have set a password to modify, protected a worksheet, or changed a different copy than the one you reopened. Check the filename and location, then inspect File > Passwords in the copy you intend to share. Cloud sync can also leave multiple versions or a pending upload; wait for syncing to finish and test the exact downloaded or shared file.
If the password is rejected, check keyboard layout, capitalization, and whether the password manager inserted an extra space. Excel passwords are case-sensitive. If the correct password is no longer available, Microsoft does not provide a universal reset for file-level encryption. Be wary of websites or apps that promise effortless recovery: uploading a sensitive workbook gives a third party access to the file, and recovery claims may be unreliable.
Sharing, cloud storage, and backups
Encryption protects the workbook when someone encounters the file, but sharing still requires care. Send the password separately from the attachment, ideally through a channel with appropriate access controls. Before sharing, check that the recipient has the password and an application that can open the file format. If a recipient needs to edit the workbook, explain whether they should use the opening password, a separate editing permission, or a protected shared location.
Saving an encrypted workbook in OneDrive or another cloud service does not make every part of the sharing process identical to file encryption. The service may also offer account permissions, link settings, and organizational access controls. Those settings govern who can reach the stored file; the Excel password governs opening the workbook itself. Use the controls appropriate to your organization and avoid public sharing links for confidential material.
Keep a backup, but make sure the backup has the protection you intend. A second unencrypted copy in Downloads, email, or a shared folder can undermine the protection on the original. If you need an accessible recovery copy, limit access to it and follow your organization’s data-handling rules. When a workbook is no longer needed, remove stored copies according to those rules rather than assuming that deleting one attachment removes every synced or backed-up version.
Frequently Asked Questions
Can I encrypt an Excel file on a Mac without Excel?
Excel’s password-to-open option is available in the Excel desktop app. Other spreadsheet apps may offer different password features or compatibility, so do not assume they create the same protection. For a workbook that must remain an Excel file, use Excel and test the resulting file in the app your recipient will use.
Does Protect Sheet encrypt an Excel file?
No. Review > Protect Sheet helps restrict edits to a worksheet, but it does not prevent someone from viewing its contents. Use the password-to-open option when you need to protect access to the workbook’s data.
Can I recover a forgotten Excel password on Mac?
Microsoft does not provide a general password reset for an encrypted workbook. Check your password manager, secure records, or an authorized organization-managed copy. Avoid uploading confidential files to unknown recovery services.
Will the password still work if I send the workbook to someone using Windows?
A password-to-open setting on a modern Excel workbook is intended to travel with the file, so a recipient using a compatible Windows version of Excel should be prompted for it. Test the file and confirm the recipient can open its format; older software or other spreadsheet applications may behave differently.
Can I password-protect an Excel workbook in a browser?
Excel for the web does not provide the same desktop password-to-open workflow. Set the file password in Excel for Mac or Windows, then use the cloud service’s sharing permissions as an additional access control where appropriate.
When to use another safeguard
A workbook password is useful when you need to protect a file that will be stored or sent as a standalone document. It is not a complete information-security plan: it cannot stop an authorized recipient from copying or photographing data after opening the workbook, and it does not replace careful account, device, and sharing controls. For sensitive business records, follow your organization’s rules for storage, access, retention, and approved encryption tools.
If several people need ongoing access, a permission-managed location may be more practical than sending password-protected attachments back and forth. If only some people should see particular information, consider whether that information belongs in a separate workbook with tighter access rather than relying on hidden sheets. The right approach depends on the sensitivity of the data and who needs it; a password-to-open is the direct Excel option for encrypting the workbook itself on a Mac.
Related
- DBeaver Export to Excel: Steps, Options, and Fixes
- Date Format Validation in Excel: Set Up Reliable Rules
- Excel Data Validation Disabled? Causes and Fixes
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 Bars: How to Add, Format, and TroubleshootExcel data bars are conditional formatting that add an in-cell bar to each numeric value, making relative sizes…
- D&A on the Balance Sheet: Where It Appears and WhyD&A means depreciation and amortization. The expense is generally reported on the income statement, not as a separate…
- Clear Cache in Outlook for Windows 10: Step-by-StepTo clear cache in classic Outlook on Windows 10, first choose which cache is causing the problem: use…
- Excel RANK vs RANK.EQ: Differences, Ties, and ExamplesRANK and RANK.EQ return the same result in current Excel: each gives a number’s position in a list,…
- Google Sheets IF Statement With Text: Examples and TipsYes. In Google Sheets, an IF statement can test text and return text: use =IF(A2="Paid","Complete","Pending") to show Complete…
- Excel Consolidate All Tabs Into One Sheet?To consolidate worksheet tabs into one Excel sheet, use Power Query to append their rows, or use the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.