How to Create Password protected Excel worksheet or workbook.

By Password protecting Excel worksheet can prevent a user from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook, you can protect certain worksheet or workbook elements, with a password. You can remove the protection from a worksheet as needed.

Steps to do :-

To do this in Microsoft Excel 2007,
1.Open your Excel worksheet.
2.Click on the Review tab and then click on Protect Sheet.

A pop-up window will appear, select your options and type the password. Any thing you can type as password,but don’t forget the given password.

After typing the password it will again ask for your password.

4.Now excel sheet will open all time as read only mode. Without knowing password no-one can update the sheet.whenever you will try to update the sheet, following alter box will appear.

Then how will you update the sheet,
Simply by Removing protection from a worksheet.
1.On the Review tab, in the Changes group, click Unprotect Sheet.

2. If prompted, type the password to unprotect the worksheet.

Next, Password Protect the Entire Workbook.

To do this, click on File, then Save As.

The Save-as window will come up,type in your file name,then select the Tools drop down menu. From that drop down menu,select General Options.

After clicking General Options, one pop-up window will appear,it will ask for two password
1.Password to open and 2.Password to modify

It will enable you to password protect the entire workbook and prevent anyone else from opening it and viewing its contents.

But remember When you protect worksheet or workbook elements by using a password, it is very important that you remember that password. Without it, you cannot unprotect the workbook or worksheet.