Remove password for excel file

Below are the steps which removes the password protection of the excel:-

1.       Use the password to open the document.

2.       Click the Microsoft Office Button image, point to Prepare, and then click Encrypt Document.

3.       In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.

4.       Save the file. 

Set password for excel file

To set password for excel file you need to perform below steps:-


1.       Click the Microsoft Office Button  point to Prepare, and then click Encrypt Document.

2.       In the Encrypt Document dialog box, in the Password box, type a password, and then click OK.

3.       In the Confirm Password dialog box, in the Reenter password box, type the password again, and then click OK.

4.       To save the password, save the file.