Password Protect a Numbers Sheet on iPhone

This guide shows you how to lock an individual Numbers spreadsheet on your iPhone with a password, so only people who know it can open or edit the file. You’ll need the Numbers app installed and the spreadsheet already saved on your device or in iCloud.

What You’ll Need

• An iPhone running iOS 13 or later (older versions have a similar but slightly different menu path).
• The Numbers app (free from the App Store if not already installed).
• The spreadsheet you want to protect, saved in Numbers format (.numbers).

Step-by-Step

1. Open the spreadsheet in the Numbers app. Tap the file from the spreadsheet manager, or if you’re already inside it, skip to step 2.
2. Tap the More button (the three dots in a circle) located in the top-right corner of the screen. This opens a menu of actions for the current spreadsheet.
3. Tap “Set Password” from the menu. If you don’t see it, scroll down—the menu can be long on smaller screens.
4. Enter a strong password in the “Password” field. Use at least 8 characters, mixing uppercase, lowercase, numbers, and symbols. Avoid using the same password you use for your Apple ID or other important accounts.
5. Re-enter the same password in the “Verify” field to confirm you typed it correctly.
6. Add a password hint (optional but recommended). This appears only after someone enters the wrong password, so it should be a clue only you would understand. For example, “My dog’s birth year” is better than “1234”.
7. Tap “Done” in the top-right corner. The password is now saved and applied to this spreadsheet only.
8. Close the spreadsheet to test it. Go back to the spreadsheet manager, tap the file, and you’ll be prompted to enter the password before it opens.

Common Mistakes

• Forgetting the password – There is no way to recover or reset it. If you forget it, you lose access to the spreadsheet permanently. Write it down somewhere safe or use a password manager.
• Setting a password on the wrong file – The password applies only to the currently open spreadsheet. Double-check the file name in the title bar before setting it.
• Using a weak password – Short or common passwords like “1234” or “password” offer little protection. Use a random combination of characters.
• Not testing after setting – Always close and reopen the file to confirm the password works. Sometimes the app doesn’t prompt until the file is fully closed.
• Confusing with device lock – The spreadsheet password is separate from your iPhone’s passcode. Even if your phone is unlocked, the spreadsheet still requires its own password.

Tips

• Use Face ID or Touch ID – After setting a password, you can enable biometric unlock for that spreadsheet. Go to the same More menu, tap “Set Password” again, and toggle on “Use Face ID” or “Use Touch ID” (depending on your iPhone model). This makes opening the file faster while still protecting it.
• Remove the password when no longer needed – If you decide the protection is unnecessary, open the spreadsheet, go to More > “Change Password” (or “Remove Password” if available), and enter the current password to remove it.
• Keep a backup of the password – Store it in a password manager like iCloud Keychain, or write it down in a secure place. Since there’s no recovery, a backup is your only safety net.
• Apply to multiple files – You must set a password on each spreadsheet individually. There’s no way to protect all files at once.
• Share securely – If you share a password-protected spreadsheet via iCloud, the recipient will need the password to open it. Share the password separately (e.g., in a text message) rather than in the same email or message as the link.

Troubleshooting

I don’t see “Set Password” in the menu. Make sure the spreadsheet is open and not in “view only” mode. If you’re viewing a shared file that you don’t own, you can’t set a password. Also, check that you’re using the latest version of Numbers—update from the App Store if needed.

The password prompt doesn’t appear when I reopen the file. This can happen if the file is still open in the background. Fully close the spreadsheet by swiping it away from the app switcher, then reopen it from the spreadsheet manager. If it still doesn’t prompt, try restarting your iPhone.

I forgot the password. Unfortunately, there is no way to recover it. If you have an iCloud backup from before you set the password, you could restore that backup, but you’d lose any changes made after the backup. Otherwise, the file is inaccessible.

Face ID/Touch ID doesn’t work. Go to Settings > Face ID & Passcode (or Touch ID & Passcode) and make sure biometric unlock is enabled for Numbers. Also, ensure you’ve enabled the “Use Face ID” toggle in the spreadsheet’s password settings.

I can’t open a protected file sent to me. The sender must provide the password separately. If they didn’t, ask them for it. If they forgot it, they’ll need to remove the password and re-share the file.

Frequently Asked Questions

Can I password-protect only certain sheets within a spreadsheet? No. The password applies to the entire file. You cannot lock individual tabs or ranges within Numbers on iPhone.

Does the password protect the file from being edited, or just opened? It protects the entire file. Anyone without the password cannot open it at all, so they can’t view or edit anything.

Will the password sync across my devices? Yes, if the file is stored in iCloud and you’re signed in with the same Apple ID, the password will be required on all your devices (iPhone, iPad, Mac). You’ll need to enter it once per device.

Can I share a password-protected file via AirDrop? Yes, you can share it like any other file. The recipient will need the password to open it.

Is the password encryption strong? Numbers uses AES-256 encryption, which is the same standard used by many security tools. It’s considered very secure.

What happens if I delete the app and reinstall it? The password protection remains on the file. When you reinstall Numbers and open the file (from iCloud or a backup), you’ll still need the password.

Related

• How to Add Location Details to Photos on iPhone
• Samsung TV Remote Not Working: Red Light Blinking Fix
• Fix Mail and Calendar Error 0x8007054e