How to Require a Password to View a Workbook in Excel 2013

You might decide to password protect a file in Excel 2013 if you are storing sensitive or important information, and you wish to limit access to that information. it is very common for businesses and individuals to keep private or crucial data in spreadsheets, and serious issues might arise if that data is shared publicly or compromised.

Fortunately Excel 2013 has a built-in tool that allows you to create and apply a password to your entire Excel file. Once you have completed the steps in this article to require a password to view a workbook in Excel, the file that you have chosen to protect will not be accessible to anyone that does not have the password.

 

How to Password Protect a File in Excel 2013

The steps below were performed in Microsoft Excel 2013. The result of completing these steps will be an Excel workbook that requires a password before it can be used. If you choose to share this workbook with another person, you will need to provide them with the password before they will be able to open, view, or edit the contents of your spreadsheet.

Step 1: Open your Excel file in Excel 2013.

 

Step 2: Click the File tab at the top-left corner of the window.

how to encrypt an excel file with a password

 

 

Step 3: Click the Info tab in the left column.

how to create a password for an excel file

 

 

Step 4: Click the Protect Workbook button, then click the Encrypt with Password option.

how to password protect a spreadsheet in excel 2013

 

 

Step 5: Type the password that you wish to use into the Password field, then click the OK button. As noted in this window, there is no way to recover this password if you forget it, so make sure that it is something you will remember, or store a copy of the password somewhere safe.

how to use a password in excel 2013

 

 

Step 6: Re-enter the password to confirm it, then click the OK button.

can i set a password for an excel file

 

 

Step 7: Click the Save button to apply your changes. You can then close the file.

how to protect an excel spreadsheet with a password

 

 

The next time you open the file, you will be greeted with a pop-up window like the one shown below. You will need to enter your password and click the OK button to gain access to the workbook.

how to stop someone from opening an excel spreadsheet

 

 

Are you having trouble getting your Excel file to print correctly? Checkout our Excel 2013 printing guide and learn about many of the options available in the program to help you print your spreadsheets more efficiently.