To allow only authorized users to view or modify your Excel workbook, you can secure your entire workbook file with a password. Follow the steps below to achieve this goal:
- On the File menu, click Save As.
- Click Tools.
- On the Tools menu, click General Options.
- If you want users to enter a password before they can view the workbook, type a password in the Password to open box.
- If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box.
- Click OK.
- You will be prompted to reenter your password(s) for confirmation.
- Confirm your password(s) then click Save.
Tip:
To remove a password from a password-protected workbook (If you have the right to modify of course), then follow the same steps to assign a password i.e.
File –> Save As –> Tools –> General Options
Clear the password(s) –> Click OK –> Click Save.
Notes:
- Passwords are case sensitive.
- If you are the only one who is allowed to open the workbook, then there is no need to enter the Password to modify.
- Make sure that you don’t lose your passwords because there is no easy way to recover them.
- This procedure applies to a new workbook as well as an existing workbook for which you want to add a password. In the second case you will be asked if you want to replace the existing file. Click Yes.
Related Links:
How to protect worksheet elements
Applies to: Excel 2003







across the rest of the rows to generate the formulas.

in the standard toolbar.










