How to Password Protect Excel 2010 Workbooks

To keep you sensitive information you may want to protect your excel 2010 workbook, worksheet or the whole document. This guide shows you where this is located in the sometimes unfamiliar “ribbon”

Protect Excel 2010

  • Open the File menu then click Info
excel 2010 file menu
  • Then click Protect Workbook and choose what you want to password
excel 2010 protect workbook
  • If you choose Encrypt with Password you will then be asked for a password. Finally save you excel document
encrypt with password excel 2010

11 Comments (Newest on top)

  1. TomCru says:

    I found a solution called WitchFile ( http://www.witchfile.com)

    how about WitchFile ?

  2. chuck oliver says:

    This works great, but how does one remove the password protection?

  3. Kinzoh says:

    This works great, but how can i remove the password protection?

  4. Big Al says:

    to remove password, click on “Encrypt with password”. If file was protected the pop up box will already have the password, so simply clear it.

  5. Shirls says:

    Thanks Big Al – I spent ages looking for this solution in the help files and finally googled it and found your answer!

Leave a Reply