Encrypt the Entire Workbook With Password . One of the most effective ways to protect your Excel data from unauthorized access is by encrypting your entire workbook with a password.

Step 3: Next, click the Protect workbook button. From the drop-down menu, select Encrypt with password.. Step 4: Excel will then prompt you to type in a password. Pick one that’s complicated and ...