Data Protection Issues

What Encryption Does Office 2019 Use for Excel Password Protection?

John WilsonJohn Wilson Nov 2, 2026 871 views

Question details

The user wants to understand the encryption methods and security strength of Excel password protection features in Office 2019.

What Encryption Does Office 2019 Use for Excel Password Protection?
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 you start

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.

Solution 1Recommended

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.

1
Open File Information

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.

2
Select Protect Workbook

Click on the 'Protect Workbook' button to reveal a dropdown menu of security options.

3
Apply Password Encryption

Choose 'Encrypt with Password' from the list. A dialog box will appear prompting you to enter a password.

4
Confirm and Save

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.

Use File-Level Encryption for Confidential Data
Important Security Distinction: Never rely on the 'Protect Sheet' or 'Protect Workbook' options found in the 'Review' tab for confidential data. These only restrict editing structure, not data access.
Secure Your Spreadsheets with WPS Office

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. 1. Open Spreadsheet: Launch WPS Office and open the spreadsheet you want to secure.
  2. 2. Access Menu: Click the 'Menu' button at the top-left corner of the interface.
  3. 3. Navigate to Document Encryption: Hover over 'Document Encryption' and click on 'Encryption' from the sub-menu.
  4. 4. Set Password: In the Encryption dialog box, enter your desired password in the 'Document password' field and confirm it.
  5. 5. Apply Security: Click 'OK' to apply the password and save your document to ensure the AES encryption takes effect.
Free and lightweight Office alternativeFully compatible with Microsoft Excel (.xlsx) formatsStrong file-level encryption for maximum data protectionFamiliar user interface with zero learning curve
microsoft office alternative - wps office

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.