In desktop Excel, open the file, go to File, then Info, choose Protect Workbook, pick Encrypt with Password, type a password and confirm it, then save. The file now asks for that password every time it is opened. That is real encryption of the file, which is different from locking cells or sheets inside it.
What is the difference between encrypting a file and protecting a sheet?
These two features sound alike and do very different things.
| Feature | What it does | Stops someone opening the file? |
|---|---|---|
| Encrypt with Password (file level) | Scrambles the whole file; asking for a password to open it | Yes |
| Protect Sheet or Protect Workbook structure | Stops edits to cells, formulas or sheet layout | No: anyone can still open and read it |
| Hidden sheets or columns | Hides data from casual view | No |
| Read-only recommended | Prompts the reader to open without editing | No |
If your concern is a stranger reading your expenses, only file-level encryption helps. Sheet protection is useful for a different job: stopping you or a family member from overwriting the formulas in a monthly summary.
How do you set an open password on Excel for desktop?
- Open the workbook and click File, then Info.
- Click Protect Workbook, then Encrypt with Password.
- Type a password. Use a long passphrase rather than a short word.
- Retype it when asked and click OK.
- Save the file. The protection is only applied once you save.
Menu names move slightly between versions and on Mac, where the option sits under Review or in the Save options, so look for the word Encrypt or Password if your screen differs. To remove it later, repeat the steps and clear the password box.
What happens on Google Sheets or a phone?
Google Sheets has no open-password feature of the Excel kind. Access there is controlled by who you share the sheet with and by the security of your Google account, so use strong sign-in protection and check the sharing settings. If you download a Sheet as an Excel file you can then encrypt that copy on desktop Excel, but the online original stays under the Google account's rules.
On a phone, the Excel app can usually open a protected file after you type the password. Whether you can set one from the phone depends on the app version, so check before you rely on it. The dependable route is to set the password on a laptop, then use the file on the phone.
Where should you store the password?
- In a password manager, in a note titled for the file, not in the file name.
- Never in the same folder, the same email or the same message as the file.
- Not on a sticky note next to the laptop and not in a notes app that syncs to a shared account.
- With a second person you trust, in a sealed note, if you are the only one who can open the household files.
Choose a passphrase you can type from memory in an emergency, such as four unrelated words, and let the manager hold the exact version.
What else protects an expense file?
A password on the file helps only while the file is closed. Once you open it on a shared computer, anyone at the screen can read it. Close the workbook when you step away, and keep it out of folders that sync to shared devices. Your email attachment is encrypted only while you send the file protected, so send the passphrase by a different route.
If you outgrow a single workbook, SpendixAI is one option for when a sheet stops being enough: it takes statements as PDF, CSV or Excel, keeps the records in your own workspace behind Google sign-in, and lets you download CSV when you need a copy for a spreadsheet.
A quick checklist
- Encrypt with Password on desktop Excel; save the file.
- Close and reopen the file to confirm the prompt appears.
- Store the password in your manager.
- Keep a backup copy, and test that it opens on another device.
- Use sheet protection too if you want to guard formulas.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


