To password protect an Excel file, open it and choose File, then Info, then Protect Workbook, then Encrypt with Password. Type a password, confirm it, and save the file. Excel then asks for that password every time anyone opens it. There is no way to recover a forgotten password, so store it somewhere safe before you close the file.
Step by step on Windows
- Open the workbook and choose File, then Info.
- Click Protect Workbook, then Encrypt with Password.
- Type your chosen password and click OK.
- Type it again to confirm, and click OK.
- Save the file with Ctrl+S. The protection takes effect when you save and close.
- Close the file, reopen it, and check that Excel asks for the password.
On Excel for Mac the same option is reached from the Review tab, under Protect Workbook. To remove protection, repeat the steps, clear the password box, click OK and save.
What does the password actually cover?
It encrypts the file itself, so someone who gets hold of it cannot read the transactions without the password. That is the right protection for a file on a laptop, a pen drive or an email attachment. It does not protect anything else.
| Situation | Protected by the file password? |
|---|---|
| Someone opens this file without the password | Yes |
| An older copy saved before you set the password | No, it stays readable |
| A PDF or CSV you exported from the file | No, it is a new file |
| Someone looking at your screen while it is open | No |
| Sheet protection or workbook structure protection | Different feature, mainly stops accidental edits |
Is Protect Sheet the same thing?
No. Protect Sheet and Protect Workbook Structure lock cells, formulas or sheet tabs so nobody changes them by accident. They are not encryption and should not be relied on to hide financial information. Use Encrypt with Password when the aim is privacy.
Choose a password you can keep
- Use a long phrase of several unrelated words rather than a short complex word.
- Do not reuse your net-banking password, a UPI PIN, a card PIN or your phone unlock code.
- Avoid birth dates, vehicle numbers and phone numbers.
- Keep it in a password manager, or on paper in a place only you can reach. Do not store it in the same folder as the file.
Check the leftovers
After encrypting, look for unprotected copies: the Downloads folder, email attachments, WhatsApp backups, cloud sync folders and old versions. Delete the ones you no longer need. If a file lives on OneDrive or another sync service, test that you can still open it on each device, since some online viewers and co-editing features may not work with an encrypted workbook.
When you send the file to someone
If you must pass the workbook to a family member or an accountant, hand over the password by a different route from the file, such as telling them in person or on a call, not in the same email. Ask whether they need the whole workbook or only a summary. Sending a PDF of the relevant report exposes less.
A different approach
A file is only as private as the places it has been copied to. SpendixAI keeps records in your own workspace with role-based access, uses Google sign-in only so there is no separate password to manage, and lets owners export data, delete transactions and schedule deletion of the whole workspace. You can read more on its security and privacy pages before deciding whether that suits you.
Checklist: password set and saved safely, file reopened to confirm, old copies deleted, exports treated as separate files, and no password stored beside the workbook.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


