How to Password Protect Excel Files

I’m sure there are some Excel files on your computer that either contain personal or business data. These files should have a layer of security by applying a password to keep the wrong people out of your business. I will review how to set up a password to protect a whole file.

The first step is to click on the file menu button in the top left-hand corner of your workbook.

You should already be in the info section of the file menu by default. If you aren't, select info from the file menu. Next, Choose the first option "Protect Workbook."

Next, choose the option "Encrypt with Password" and be prepared to use a password.

Now enter a password in the encrypt document window. After you click OK, enter the same password again into the new window.

At this point the workbook is now password protected.

Once the Excel file is closed the password that was previously saved will need to be entered to access the file.

To learn more about creating passwords and other accessibility options in Excel I recommend that you try the book shown below. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.

Alexander, M., Kusleika, D., & Walkenbach, J. (2019). Excel® 2019: bible. Indianapolis: Wiley.