This document explains how to require a password to open a workbook which also encrypts the file. Caution: If you lose or forget the password, it cannot be recovered. Encrypted data cannot be recovered without your password. 1) Open the workbook you want to protect. 2) On the Review tab, under Protection, click Passwords.
3) In the Password to open box, type a password, then click OK. (Note: Password to modify, does not encrypt the document) 4) In the Confirm Password dialog box, type the password again, then click OK.
5) Click Save. 1) Open the workbook you want to protect. 2) On the Excel menu, click Preferences. 3) Click Security. 4) In the Password to open box, type a password, then click OK. 5) In the Confirm Password dialog box, type the password again, then click OK. 6) Click Save.
Password-protection will work no matter what device you set it up on or are accessing it from. The following method applies only to the 2011 version of Word for Mac. If you want to password-protect other files in Mac OS X, like photos, videos, and music, you can dump them in a folder and use the.