Password-protect a Numbers spreadsheet on Mac
You can assign a password to a spreadsheet so only those who know the password can open the spreadsheet. Passwords can consist of almost any combination of numbers, upper case or lower case letters and special keyboard characters.
A spreadsheet can have only one password. If you change an existing password when you share a spreadsheet with others, the new password replaces the original. If you add a password after you share a spreadsheet, make sure you notify participants.
Important: There’s no way to recover your password if you forget it. Make sure you select a password you won’t forget or write down the password in a safe place.
If your computer has Touch ID, the fingerprint detection feature, you can use it to open your password-protected spreadsheets with your fingerprint alone.
Require a password to open a spreadsheet
Go to the Numbers app
on your Mac.Open a spreadsheet.
Choose File > Set Password (from the File menu at the top of your screen), enter the requested information, then click Set Password.
If your computer isn’t set up for Touch ID, “Remember this password in my keychain” appears. You can select the tick box to add the password to your keychain so you don’t have to type the password each time.
If your computer has Touch ID, the fingerprint detection feature, you can use it to open your password-protected spreadsheets with your fingerprint alone.
Note: Adding a password to a spreadsheet encrypts the file.
Change or remove a password
Go to the Numbers app
on your Mac.Open a password-protected spreadsheet, then do one of the following:
Change a password: Select File > Change Password (from the File menu at the top of your screen). Enter the requested information, then click Change Password.
A spreadsheet can have only one password, so if you change the password when you share the spreadsheet, that becomes the spreadsheet’s only password.
Remove a password: Choose File > Change Password. Type the old password, then click Remove Password.
People you invite to collaborate on a spreadsheet and who have editing permission can add, change, or delete the password.
Set up Touch ID to open password-protected spreadsheets
Before you can use Touch ID to open password-protected spreadsheets, you need to set it up on your computer.
To set up Touch ID, do the following:
On your Mac, choose Apple menu
Click Add Fingerprint, then follow the on-screen instructions.
Go to the Numbers app
, choose Numbers > Settings (from the Numbers menu at the top of your screen), then select the tick box for Use Touch ID.
Open a password-protected spreadsheet with Touch ID
Go to the Numbers app
on your Mac.Double-click the password-protected spreadsheet, then place your finger on Touch ID.
If you add a password to a spreadsheet or change an existing password, it applies only to that version of the spreadsheet and to subsequent versions.
If the spreadsheet is shared, to prevent others from restoring an unprotected version of the spreadsheet or a version with an older password, stop sharing the spreadsheet, add a unique password to it, then share the spreadsheet again.