Excel (Mac) - How to password protect and encrypt a workbook

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.

If you are using Excel 2011
If you are using Excel 2008

Excel 2011

1) Open the workbook you want to protect.

2) On the Review tab, under Protection, click Passwords.

mac2011reviewtab.gif

3) In the Password to open box, type a password, then click OK.  (Note:  Password to modify, does not encrypt the document)

password to open

4) In the Confirm Password dialog box, type the password again, then click OK.

confirm password

5) Click Save.

Excel 2008

1) Open the workbook you want to protect.

2) On the Excel menu, click Preferences.

Excel menu

3) Click Security.

Excel preferences security

4) In the Password to open box, type a password, then click OK.

password to open

5) In the Confirm Password dialog box, type the password again, then click OK.

confirm password

6) Click Save.




Keywords:excel office mac password encrypt workbook encryptData@rest   Doc ID:17333
Owner:Allen M.Group:Office of Campus Information Security
Created:2011-03-16 19:00 CDTUpdated:2011-03-24 19:00 CDT
Sites:DoIT Help Desk, Office of Campus Information Security, Southern Illinois University Edwardsville
Feedback:  53   12