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.
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.