How To Password Protect An Excel File. Enter a password and Click OK. In the Password box type a password and in the Verify box type the password again.
In the top-left corner of the screen click the Microsoft Office Button. Now you can choose what part of the worksheet you want to protect. To set it follow the procedure below.
With the file open go to the File tab and click on Protect Workbook in the Info section.
On the File tab click Save As. Select Protect Workbook then Encrypt with Password from the dropdown menu. Choose any other protection options you want and click OK. In the top-left corner of the screen click the Microsoft Office Button.