Protect A Sheet In Excel Password When You

Passwords can consist of almost any combination of numbers, uppercase or lowercase letters, and special keyboard characters.

Protect A Sheet In Excel Password When You

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, be sure to notify participants.

Important: Theres no way to recover your password if you forget it.

Be sure to choose a password you wont forget, or write the password down 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 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 isnt set up for Touch ID, Remember this password in my keychain appears.

You can select the checkbox to add the password to your keychain so you dont have to type the password each time.

If your computer is set up for Touch ID, Open with Touch ID appears.

You can select the checkbox to turn on Touch ID for the spreadsheet.

Change or remove a password With the spreadsheet open, do one of the following: Change a password: Choose File Change Password (from the File menu at the top of your screen).

A spreadsheet can have only one password, so if you change the password when you share the spreadsheet, that becomes the spreadsheets only 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 both of the following: Set up Touch ID for your Mac: Choose Apple menu System Preferences, click Touch ID, click Add a fingerprint, then follow the onscreen instructions.

Note: If you dont see Touch ID, this feature isnt available on your Mac.

Set up Touch ID for Numbers: In Numbers, choose Numbers Preferences (from the Numbers menu at the top of your screen), then select Use Touch ID.

Open a password-protected spreadsheet with Touch ID Double-click the spreadsheet, then place your finger on the right end of the Touch Bar at the top of your keyboard.

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.

How To Protect A Sheet In Excel For Mac