In latest versions of Excel, Microsoft has introduced custom options relate to encrypt Excel file, which allows you to set different passwords for open and modify. Way 3: How to set passwords for different rights Step 3: Next, you can set users’ rights by unchecking the options in the list. Step 2: Enter your password into the field and make sure to check the box of “Protect worksheet and contents of locked cells”. Select “Format Cells” on the menu bar to open the Protect Sheet dialog. Step 1: Open the Excel file in your Excel program, locate to the bottom, select the worksheet that you’d like to protect and right-click on it. If you just want to hide a single worksheet but not encrypt Excel file, you can encrypt the sheet separately. Mac users ca find different ways here to encrypt files on Mac including the Excel file, Word file, etc. In addition to Review tab, you can go to “File” > ”Info” > ”Protect Workbook” > “Encrypt with Password” to set password as well. If you select “Structure”, others cannot edit, hide or look at the hidden worksheets without password while the Windows option is used to prevent others from moving or changing the workbook window. Note: In Excel 2010 and earlier versions, there are two options on the popup dialog.

Step 3: On the popup dialog, drop your password in the box and click on “OK” button to confirm it. Step 2: Go to the “Review” tab on top of the window and click on the “Protect Workbook” option in the “Changes” section. Step 1: Open the Excel file that you want to encrypt in Excel program. Way 1: How to encrypt an Excel fileĮncrypting Excel file means password protect all worksheet in the file. Part 3: How to open password protected Excel file with VBA codeĪs mentioned before, Excel has powerful encryption feature, which allows users to password protect a whole workbook or a single worksheet for different rights.Part 2: How to restore deleted or lost password-protected Excel files.And to help you recover data, we are going to show you how-to in detail below. Fortunately, there are methods to unlock encrypted Excel file without password. Once forgot the password, you will be locked out of the workbook and your data. How to open password protected Excel file?Įvery coin has two sides, so does Excel encryption feature. If you need to save some important business data in an Excel file, you have to add password on it to prevent from others read it.

How to open ws file