Password Protect an Excel Workbook

How to password protect an Excel workbook

Everything these days seems to require a password.. and of course everyone has different specifications. I would love to hear from people on how they safeguard their passwords. Send me an email with your method- send to “patricia@cpaselfstudy.com”

Below is a guest post from Joe Helstrom on protecting a workbook.
To ensure that unauthorized users do not access a workbook, a workbook can be password protected. Without the password, users cannot access the worksheets within the workbook. It is an effective control as long as the password is limited only to those users with authorized access, is properly safeguarded and is not shared with anyone else. A password is not very effective if it’s on a sticky note attached to your computer monitor.  However, I am sure that none of you do that.

1. Click on File
2. Click Info
3. Select Protect Workbook

steps to protect Excel spreadsheet
 

 

 

 

 

 

4. Click Encrypt with Password

password protect dialog box in excel
Once you have selected a password, you’ll be asked to re-enter it.
steps for encrypting Excel worksheet

 

 

 

Beware! If you lose the password, it cannot be recovered. Also note that passwords are case sensitive.
When you save the workbook, the password will be required to open it. Keep in mind that there is no way of recovering a lost password in Excel.

This feature not only password protects the workbook. It also uses AES 128 bit encryption which makes the file more secure.
Passwords should be strong. It is recommended that they be at least 7 characters long, contain both uppercase and lowercase letters as well as numbers and symbols.

3 Responses

  1. spirituality says:

    This is a great tip especially to those new to the
    blogosphere. Simple but very precise info… Thanks for sharing this
    one. A must read post!

  2. comment être riche says:

    Everyone loves it when people get together and share views.

    Great blog, continue thee good work!

  3. devenir millionnaire says:

    It’s actually a great and helpful piece of info.
    I’m glad that you just shared this helpful info with us.
    Please keep us up to date like this. Thank you for sharing.

Leave a Reply

Your email address will not be published. Required fields are marked *

  • “Thank you for a high quality CPE resource. As a CPA in a small nonprofit, I find your library quite helpful to meet my needs. I appreciate the service.”- 

    - Cheryl

  • Your ethics course was the most interesting and clear course I have taken. I usually dread the years it is required but this year was a pleasant surprise.

    - Terry

  • Thank you for providing very informative CPEs. I have enjoyed your courses for years now. Yours is truly my go-to CPE sources.

    - Lily