To password protect an Excel bank statement for free, use File, Info, Protect Workbook, Encrypt with Password. That setting encrypts the whole file, so nobody can open it without the password. Sheet protection and workbook structure protection only stop edits. They do not keep anyone from reading your transactions.
Encrypt with Password: the Excel setting that locks a bank statement
Encrypt with Password is the Excel setting that requires a password before the file opens at all. It is the only built-in Excel option that keeps a reader out of a bank statement spreadsheet. It is included in desktop Excel at no extra cost, so it needs no add-in or other tool.
Step list
Microsoft's article on protecting an Excel file gives these steps:
- Open the converted statement and select File, then Info.
- Select the Protect Workbook box and choose Encrypt with Password.
- Type a password and select OK.
- Type it again to confirm, and select OK.
- Save the file. Close it, then reopen it to check that Excel asks for the password.
Choosing the password
Passwords in Excel are case-sensitive. Use a long phrase you will remember, not the account number or your birth date, both of which appear on the statement or in paperwork near it. Microsoft says plainly that it cannot retrieve a forgotten password, so a lost password means a lost file. Store it in a password manager if you use one.
Removing it later
To take the password off, open the file with the password, repeat the same steps, clear the password box and save. Do this before you hand the file to a tool that cannot open encrypted workbooks.
Sheet and workbook protection in Excel is not a lock
Sheet protection and workbook protection stop people from changing cells or moving sheets, but they do not stop anyone from reading the data. Microsoft's guide to protecting a worksheet says directly that worksheet level protection is not intended as a security feature.
What each protection actually does
| Protection | Where it is | Stops someone opening the file? | What it is for |
|---|---|---|---|
| Encrypt with Password | File, Info, Protect Workbook | Yes | Keeping a reader out |
| Protect Sheet | Review tab | No | Stopping edits to locked cells |
| Protect Workbook (structure) | Review tab | No | Stopping sheets being added, moved or deleted |
| Numbers password | File, Set Password | Yes | Keeping a reader out on a Mac |
The middle two rows are useful when you share a budget built from your statement and want formulas left alone. They are not useful for privacy. A person who opens the file still sees every row.
Can you password protect a bank statement in Google Sheets?
Google Sheets has no setting that puts a password on a single spreadsheet. Access to a sheet depends on your Google account and the file's sharing settings. To protect a statement in Sheets, protect the account with a strong password and two-step sign-in, and keep the file restricted to you.
What the protected ranges feature does
Sheets has protected sheets and ranges under the Data menu. Like Excel's sheet protection, this controls who can edit, not who can view. Anyone the file is shared with can still read the protected cells.
Downloading to Excel to add a password
If you need a password-protected file, download the sheet as an .xlsx file, then encrypt it in desktop Excel with the steps above. Students may have desktop Excel through their school, and using the Office access your school provides explains how to find out. Account settings for files you keep online are covered in whether it is safe to store bank statements in the cloud.
Setting a password on a Numbers spreadsheet on a Mac
Numbers on a Mac can require a password to open a spreadsheet, at no cost. Apple's guide to password-protecting a Numbers spreadsheet describes it as File, then Set Password, then entering the requested information and clicking Set Password.
Apple warns there is no way to recover the password if you forget it. If you later export the spreadsheet to Excel format to send to someone, check whether the exported copy is still protected before you send it. If it is not, encrypt the .xlsx copy in Excel or send it another way.
Excel password mistake: sending the password with the file
The most common way people defeat their own Excel password is sending it in the same email as the file, so anyone who opens that inbox gets both. Why the password needs a second channel when you email a statement covers the fix.
Other ways the protection gets undone
- Saving an unprotected copy. Converting the file to CSV removes the password, because CSV is plain text and cannot hold encryption.
- Leaving the original PDF next to it. An encrypted spreadsheet beside an unencrypted statement PDF in the same folder protects nothing.
- A guessable password. Your surname plus the year is easy to guess for anyone who knows you.
Who can still read a password-protected bank statement file?
A password-protected bank statement file can still be read by anyone who has the password, and by anyone who can see it while it is open. Encryption protects the file at rest. It does nothing once you have opened it on a shared screen or a computer with someone else's software running.
The limits worth knowing
Microsoft's file-protection article cautions that locking a file with a password does not necessarily protect it from malicious intent, and that sharing password-protected files with sensitive information is not always secure. Treat the password as one layer. Knowing what someone could do with your bank statement helps you decide how many layers the file deserves.
Where the spreadsheet came from
If the spreadsheet came from a converter, the converter saw the statement before you added the password. Choose that tool with care, and reading bank statement converter reviews critically helps. CheapBankConvert, in early access, encrypts statements in transit and at rest and deletes them after your download, which leaves the password on your copy as the remaining protection.