You can add a password to an Excel file to prevent unauthorized users from opening or modifying it.

You can add a password to an Excel file to prevent unauthorized users from opening or modifying it.

How to protect an Excel file using a password to prevent unwanted access to your data.

Open the workbook that you want to change or remove the password for. On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet.

You can protect the Excel file by specifying two passwords: one to open, and the other to modify. You can later share the appropriate passwords with the team depending on the access they should be given.

Add a password to protect your entire workbook and control whether others can open or make changes to it. Protect your file by setting passwords for Open and Modify.

Open the workbook you want to protect. Click the File menu, and then click Passwords . In the File Passwords dialog box, select the Read-only recommended check box, and click OK .

Go to File > Info > Protect Document > Encrypt with Password. Type a password, press OK, type it again and press OK to confirm it. Save the file to make sure the password takes effect.

Find out how you can unlock an Excel spreadsheet when you are locked out of an Excel file by yourself or by another user.

If you're you seeing a "Something went wrong.." error message when trying to open a password-protected Excel file on your mobile device, it might be because the file is a format that's not supported by your mobile device. If so, you can work around the error by opening the file on a desktop computer and saving it to a file format that's ...