Password-Protecting an Excel Workbook

Excel can require a password before a workbook is opened or modified. This can be useful for reducing casual or unauthorized access to a file that contains sensitive information.

Version context: The menu labels below reflect the Excel version used when this article was written. Current Microsoft 365 and Excel releases may place password and encryption options in different menus.

Configure Password Protection

1. Open the workbook.
2. Select File from the application menu.
3. Open Passwords.
4. Enter a Password to open if access to the workbook should be restricted.
5. Enter a Password to modify if editing should require a separate credential.
6. Re-enter each password when prompted.
7. Save and close the workbook.
8. Reopen the file to verify the protection behaves as intended.

Security Considerations

Use a strong, unique password and store it securely. Losing the password can make the workbook difficult or impossible to recover depending on the Excel version and protection method.

Password-protecting a workbook should also not be confused with enterprise access control. For sensitive organizational data, combine document encryption with appropriate storage permissions, sharing controls, retention policies, and approved collaboration platforms.

Takeaway

Workbook passwords can provide a useful additional layer of protection for individual files, but they work best as part of a broader data-access strategy rather than as the only security control.