how to add password to excel

To add a password to an Excel file, follow these steps

:

1. Select File , then Info

2. Select the Protect Workbook box and choose Encrypt with Password

3. Enter a password in the Password box, and then select OK

4. Confirm the password in the Reenter Password box, and then select OK

You can also password-protect an Excel worksheet to restrict editing

:

1. Go to File > Info, then click Protect Workbook > Protect Current Sheet

. You can also use the review tab in the ribbon.

2. Enter a strong worksheet password in the Password to unprotect sheet field

. Tick the actions you want to allow users to take. Bear in mind that you will need to untick “Select cells” if you want to prevent users from copying and pasting.

3. Press OK to apply the worksheet protection

To password protect an Excel Workbook:

1. Open the Review tab of your ribbon and press Protect Workbook

2. Enter a secure password and press OK. Save your document

Important information to remember about password protecting excel files:

• Microsoft cannot retrieve forgotten passwords, so make sure your password is memorable

• Passwords are case-sensitive

• It’s not always secure to distribute password-protected files that contain sensitive information such as credit card numbers

• Be cautious when sharing files or passwords with other users

. Locking a file with a password does not necessarily protect your file from malicious intent