Guide · 8 min read
How to Protect an Excel File with a Password
Choose the right Excel protection method, set a strong password, and avoid common mistakes.
Protecting an Excel workbook properly means choosing the right type of protection for your goal. File-level encryption is necessary when unauthorized people must not see the content at all. Workbook and worksheet protection are useful for preventing accidental edits, but they are not confidentiality controls — they can be removed by anyone with the password or by the original creator.
Store your password in a password manager immediately after setting it. Losing an encryption password may make the workbook permanently unrecoverable.
Choose the right protection type
Encrypt with Password: Applies AES encryption so the file cannot be opened without the correct passphrase. Use this when you are sharing sensitive data and must prevent unauthorized access.
Protect Workbook Structure: Prevents users from adding, deleting, moving, hiding, or renaming sheets. It does not encrypt content — the file opens freely.
Protect Worksheet: Locks cells, formulas, and ranges so users cannot overwrite values or formatting. Use this in shared workbooks to protect critical formulas while allowing data entry in designated cells.
Encrypt the file (recommended for confidential data)
In Excel on Windows: File → Info → Protect Workbook → Encrypt with Password. Enter a strong, unique password and click OK. Confirm the password and save the file.
In Excel on macOS: Review → Passwords. Set the "Password to open" field, click OK, confirm, and save.
In LibreOffice Calc: File → Save As → check "Encrypt with GPG key" or use the standard password option in the Save dialog.
Test immediately: close the workbook, reopen it, and confirm the password prompt appears and the correct password works.
Tips
- Use a passphrase of 16+ characters that mixes words, numbers, and symbols. Avoid names, company acronyms, or keyboard patterns.
- Save the password in a password manager (Bitwarden, 1Password, KeePass) immediately — not in a plain text file or email.
- Send the password through a different channel than the file: for example, email the file and text the password.
Protect workbook structure
Review tab → Protect Workbook → check "Structure" → enter an optional password → OK.
Structure protection prevents sheet renaming and reordering. It is useful for workbooks where the sheet layout is part of the design, such as dashboards or forms.
Protect individual worksheets
Right-click the sheet tab → Protect Sheet → select which actions to allow → enter an optional password → OK.
Before protecting, select the cells users should be able to edit, right-click → Format Cells → Protection tab → uncheck "Locked." All other cells will be locked when protection is enabled.
Common use: lock all formula cells, leave input cells unlocked, then protect the sheet so users can only enter data in the designated fields.
Encryption versions and compatibility
Excel 2019 and Microsoft 365 default to AES-256 (ECMA-376 Agile Encryption). Recipients using older Excel or third-party tools must support this standard.
If sharing with users on Excel 2007–2010, note that those versions use AES-128. Modern Excel can still read AES-128 files; older Excel cannot open AES-256 files.
Google Sheets cannot directly open password-encrypted XLSX files — the recipient must decrypt locally first.
Ready to unlock your document?
PasswordRemover processes your file locally in the browser — no uploads, no account required.
Go to tools