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

Then click Protect Workbook and choose what you want to password

If you choose Encrypt with Password you will then be asked for a password. Finally save you excel document

Benosullivan.co.uk - Top Tutorials

Search Terms for this Article:

password protect excel 2010, excel 2010 password protect, excel 2010 password, password excel 2010, how to password protect excel 2010, how to password protect an excel file 2010, password protect excel 2010 workbook, how to set password in excel 2010, password protect excel file 2010, excel 2010 password protect workbook

11 Comments (Newest on top)

Raj says:

14/10/2011 at 9:36 am

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.

Reply
- Ben says:
  
  15/10/2011 at 10:26 am
  
  Glad I could help,
  Pictures always make it easier!
  
  Reply
Narasimha Murthy says:

21/10/2011 at 2:11 pm

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

Reply
krishanth says:

27/10/2011 at 11:31 am

thaks a lottttttttttttttt

Reply
Sreekanth says:

04/11/2011 at 5:34 pm

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.

Reply
rajkumar says:

26/12/2011 at 4:21 pm

Thanks alot, the walk through was very helpful.

Reply