What Encryption Does Office 2019 Use for Excel Password Protection?
Question details
The user wants to understand the encryption methods and security strength of Excel password protection features in Office 2019.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying password protection to secure confidential data in Excel workbooks.
- Observed behavior
- The user needs to know whether standard workbook protection provides strong security or if file-level encryption is necessary to adequately protect confidential data.
Before applying strong encryption to your Excel files, ensure you write down or store the password in a secure password manager, as forgotten encryption passwords cannot be recovered.
Use File-Level Encryption for Confidential Data
To ensure strong security, use the 'Encrypt with Password' feature rather than basic worksheet protection. Office 2019 uses Advanced Encryption Standard (AES) with 256-bit keys for file-level encryption.
Worksheet and workbook protection features are primarily designed to prevent accidental modifications to the layout or formulas. They do not encrypt the data and can be bypassed relatively easily by malicious users.
For true data security, you must use the file-level encryption feature. When applied, Office 2019 scrambles the file contents using AES-256 encryption, meaning the data cannot be read or extracted without the correct password.
Open the Excel workbook you want to secure, click on the 'File' tab in the top-left corner, and select 'Info' from the sidebar menu.
Click on the 'Protect Workbook' button to reveal a dropdown menu of security options.
Choose 'Encrypt with Password' from the list. A dialog box will appear prompting you to enter a password.
Type a strong, unique password and click 'OK'. Re-enter the password to confirm, click 'OK' again, and then save your workbook to finalize the encryption.

How to Encrypt Spreadsheets in WPS Office
WPS Office provides robust, built-in encryption to keep your sensitive spreadsheet data secure. It offers full compatibility with Microsoft Excel formats and provides an intuitive, highly secure way to password-protect your files for free.
- 1. Open Spreadsheet: Launch WPS Office and open the spreadsheet you want to secure.
- 2. Access Menu: Click the 'Menu' button at the top-left corner of the interface.
- 3. Navigate to Document Encryption: Hover over 'Document Encryption' and click on 'Encryption' from the sub-menu.
- 4. Set Password: In the Encryption dialog box, enter your desired password in the 'Document password' field and confirm it.
- 5. Apply Security: Click 'OK' to apply the password and save your document to ensure the AES encryption takes effect.

Frequently Asked Questions
What is the difference between workbook protection and file encryption?
Workbook protection prevents users from accidentally deleting sheets, hiding rows, or modifying formulas, but it does not encrypt the file itself. File encryption scrambles the actual contents of the file, making it completely unreadable to anyone who does not have the correct password.
Can I recover a lost password for an encrypted Excel file?
No. If you lose or forget the password used for the 'Encrypt with Password' feature in Office 2019 or WPS Office, it cannot be recovered. Microsoft and WPS do not keep copies of your passwords, so maintaining a secure backup is essential.
Is Office 2019 encryption strong enough for sensitive data?
Yes, when using the 'Encrypt with Password' feature, Office 2019 uses AES-256 encryption. This is an industry-standard, highly secure cryptographic algorithm suitable for protecting confidential and sensitive financial or personal data.
Does WPS Office support opening password-protected Excel files?
Yes, WPS Office is fully compatible with Microsoft Office encryption standards. If you have the correct password, you can seamlessly open, read, and edit AES-encrypted .xlsx files using WPS Spreadsheets.




