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. Raj says:

    Thanks mate. I spent 15 mins searching on google but cudnt find the solution. Your snapshots helped me immensely and it took me 5 seconds to undersatnd what do it in order to lock the workbook.

    Thanks.

  2. Narasimha Murthy says:

    Thanks ben, you had shown me procedure to put password.

  3. krishanth says:

    thaks a lottttttttttttttt

  4. Sreekanth says:

    Thnx buddy, how to give edit rights like in 2003 we have 2 security levels 1 is to open and the other is to edit, can i protect in the same way in office 2010.

  5. rajkumar says:

    Thanks alot, the walk through was very helpful.

Leave a Reply