• Excel - Protecting Your Workbook

     

    Setting permissions for your spreadsheets helps keep confidential information safe. With security features in Excel, you can encrypt your workbook or protect a single worksheet to keep your information safe by restricting access to only those people you give the password to.

    To encrypt your worksheet with a password:

    • Open the spreadsheet you want to password protect

    • On the File tab, click Info, and then click Protect Workbook

    • Select Encrypt with Password
                                     Password

    • In the dialog box that appears, enter your password and click OK 
                                         Set Password

    ** Important – If you lose or forget the password, it cannot be recovered. It is advisable to keep a list of passwords and their corresponding document names in a safe place. (Remember that passwords are case-sensitive.)