To password protect an Excel file, you can follow these straightforward steps:
- Open your Excel workbook.
- Click on the File tab in the ribbon.
- Select Info from the sidebar.
- Click on the Protect Workbook button.
- Choose Encrypt with Password from the dropdown menu.
- Enter a strong password in the dialog box and click OK.
- Re-enter the password to confirm it and click OK again.
- Save the workbook to apply the password protection.
Now, your Excel file will require the password to be opened, preventing unauthorized access
Additional options for protection in Excel
- Password to modify (read-only mode): You can set a password that restricts editing but allows users to open the file in read-only mode. This is done via File > Save As > Tools > General Options, then entering a password in the "Password to modify" box
- Protect Workbook structure: This prevents users from adding, deleting, renaming, or moving sheets inside the workbook. It is done from the Review tab by selecting Protect Workbook and setting a password
- Protect worksheets and cells: You can lock specific sheets or cells to prevent editing. This is done from the Review tab by selecting Protect Sheet and setting a password, with options to allow or restrict certain actions
Important notes
- Microsoft cannot recover lost passwords, so choose a memorable password and keep it safe
- Password protection encrypts the file with AES-256 encryption, providing strong security
- Password protection mainly prevents unauthorized access or editing but does not stop printing or saving copies if the file is opened
By following these steps, you can effectively secure your Excel files with passwords to protect sensitive data.
