Adding a Workbook Password

 To add a password to a workbook in Excel, which will prevent unauthorized users from opening the workbook without the password, follow these steps:

Open Excel Workbook: Launch Microsoft Excel and open the workbook you want to add a password to.

Navigate to the File Tab: Click on the "File" tab located in the top-left corner of the Excel window.

Open Info Options: From the menu on the left side, select "Info" to open the Info options.

Click on "Protect Workbook": Under the "Workbook Protection" section, click on the "Protect Workbook" dropdown menu.

Select "Encrypt with Password": From the dropdown menu, select "Encrypt with Password."

Enter Password: In the "Encrypt Document" dialog box, enter the password you want to use to protect the workbook. Make sure to choose a strong and secure password.

Confirm Password: After entering the password, click "OK" to confirm. You will be prompted to re-enter the password to confirm it.

Save Workbook: Once the password is confirmed, click "OK" again to close the dialog box. Save the workbook to apply the password protection.

Remember Password: Excel will ask if you want to save the password. If you want to be able to open the workbook without entering the password each time, choose "Yes." Otherwise, choose "No" to require entering the password every time the workbook is opened.

After following these steps, the workbook will be password-protected, and users will need to enter the correct password to open it. Make sure to remember or securely store the password, as there is no way to recover it if forgotten.