Pages

28 September, 2011

How to protect MS Excel file by password?

In Microsoft Excel, it's possible to protect a individual cell, group of cells along with a worksheet neither of the 2 a complete workbook at the time of employing password that allows unauthorized someone incapable of display including alter your written document. Well you could utilize parallel types of password...

Password to spread currently the written document :.
If this substance is applied then you have to give the correct password to spread out currently the workbook. Otherwise you can not spread out currently the workbook.

Password to change currently the document :.
If it is applied then you have to give the correct password to change currently the workbook. Otherwise the workbook is spread but you can not change currently the workbook. This substance shows that your workbook goes read-only.

To use a password to MS Excel text file, pursue currently the opened measures :.

Number one mouse click available on "Tools" menu now choose currently the "Option" from the comfort of drop down menu.

A windows dialog box will come out, at this site take currently the "Security" tab key.
Get in 1st password in "Password to open" text box under "File encryption settings for this workbook" part and after this 2d password in "Password to change" text box (when commanded) under" File sharing settings for the workbook" section then mouse click "OK" push button of dialog box.



Microsoft Excel will spread out "Confirm Password" dialog box on the part of currently the verification of passwords. Currently the max length of password is 15 characters. Re-enter currently the password to open and here password to change and then mouse click "OK" push of Confirm Password dialog boxes one by one.

Currently close up currently the data file and so reopen to essay currently the password.

No comments:

Post a Comment