LATEST TECH NEWS AND TIPS

How to protect MS Excel file using password?

Most of the business firm keep their data in excel work sheet.There for the protection of this data is essential. in Microsoft Excel, you can protect a single cell, group of cells on worksheet or an entire workbook by applying password so that unauthorized person cannot 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:
Under this method you have to give correct password to modify the workbook. Otherwise your work book is opened but you cannot modify the workbook.

To apply a password to MS Excel document follow the steps given bellow
First Click on the “Tools” menu and select the “option” from the drop down menu

A window dialogue box will appear,

here select the “security” tab
Enter first password in “password to open” text box under “file encryption setting for this workbook” section and second password in “password to modify” text box (if required) under “ file sharing settings for the work book” 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.