How to password protect your
MS Excel file?
In Microsoft Excel, you can protect a single cell, group
of cells on a worksheet or an entire workbook by applying password so
that unauthorized
person can not display as well as modify your
document. You can apply two types of
password.
Password to open the document:
If it is applied then you have to give the correct
password to open
the workbook. Otherwise you
cannot open the
workbook.
Password to modify the document:
If it is applied then you have to give the correct
password to modify
the
workbook. Otherwise
your
workbook is opened but you cannot modify
the workbook. It means that
your workbook
becomes read-only.
To apply a password to MS Excel document, follow the given steps:
First
click on "Tools" menu and select the "Option" from drop down menu.
A windows
dialog box will appear, here select the "Security" tab.
Enter first password in "Password to open" text box under "File
encryption settings for this workbook" section and second password
in "Password to modify" text box (if required) under" File sharing
settings for the workbook" section then click "Ok" button of
dialog box.
Microsoft Excel will open "Confirm Password" dialog box for
the confirmation of passwords. The maximum length of password is 15
characters.
Re-enter the password to open and password to modify and click "Ok"
button of Confirm Password dialog boxes one by one.
Now close the file and then reopen to test the password.
COMPUTER TIPS