Excel 2013, like other productivity tools in Office suite, allows users to protect their files using a password. Protecting your Excel file provides it with a layer of security: unauthorized persons cannot access sensitive and private data stored in the file. Secondly, it protects the file when sending it to other users over different media. It is, therefore, important to secure your Excel files with a password. This article explains how to password protect Excel 2013.

Method 1. Protect Excel 2013 with Open Password

Wondering how to set password in Excel 2013? The Open Password feature that is accessed through the Save As option can be used to protect your Excel file. Follow the procedure below.

Step 1: Navigate to the Excel file and open it.

Step 2: In the ribbon, click File and then Save As.

excel save as

Step 3: Select a file location on which you’ll save your document by clicking This PC or Browse.

Step 4: Click Tools in the Save As pop-up window then proceed to click General Options.

tools general  options

Step 5: Key in a password under the Password to open option and reenter it to confirm password in the prompt that appears next.

Note: Check other options such as Read-only or Always create a backup.

password to open

Step 6: Click Ok and then Save.

Any user will be prompted to key in a password when trying to access the file.

Method 2. Protect Excel 2013 via Modify Password

Modify Password feature allows users to modify the contents of the Excel File. To set Modify Password, follow the procedure below.

Step 1: Navigate to the Excel file and open it.

Step 2: In the ribbon, click File and then Save As.

 excel save as

Step 3: Select a file location on which you’ll save your document by clicking This PC or Browse.

Step 4: Click Tools in the Save As pop-up window then proceed to click General Options.

tools general  options

Step 5: Key in a password under the Password to modify option.

password to  modify

Step 6: Reenter the password to confirm it in the prompt that appears next. (Note: Check other options such as Read-only or Always create a backup.)

reenter password to modify

Step 7: Click Ok and then Save.

Note: Users who don’t have the modify password, can click the Read Only button to access the contents of the file.

read only

Method 3. Protect Excel 2013 with Read Only Password

The Read Only feature ensures that users cannot edit the contents of the workbook unless they use the Save As feature to save the document in a different location. Follow the procedure below.

Step 1: In the ribbon, click Review > Restrict Editing.

 restrict editing

Step 2: Under Editing Restrictions, check the “Allow only this type of editing in the document” checkbox and select the No changes (Read Only) option.

 editing  restrictions

Step 3: Click “Yes, Start Enforcing Protection” option.

 enforce protection

Method 4. Protect Excel 2013 using Workbook Structure Password

Thinking of how to add the password to Excel 2013? The most direct way of protecting your password is by using the Protect Workbook feature that is located in the Info under the File option. Follow the procedure below.

Step 1: Navigate to the Excel document you would like to password protect and open it.

Step 2: In the ribbon, click File and then Info.

 excel 2013 info  options

Step 3: Click Protect Workbook. It is the first option in the Info section. Then proceed to click Encrypt with Password.

 encrypt with  password

Step 4: Excel will prompt you to key in a password. Type one and record it somewhere safe e.g. On your notebook.

Note: Losing your password means that you will not access it.

enter password

Step 5: Reenter the password to confirm it.

reenter password

You will have protected your Excel file with a password. Close the file then open it. You will be prompted to type in the password to access the file.

enter password

Method 5. Protect Excel 2013 through Sheet Password

Sheet password protects only one worksheet and not the whole workbook. To set it, follow the procedure below.

Step 1: Select a worksheet at the bottom of your screen, right-click it and click Protect Sheet. Alternatively, in the ribbon, click Review > Protect Sheet under the Changes group.

protect sheet  excel

Step 2: Enter the protect sheet password, check other options and reenter the password to confirm it.

protect sheet password

Users can open the worksheet but will be required to enter the password to make any changes.

Extra Tip: How to Unprotect Excel 2013 Password

PassFab for Excel is a great tool that allows users to recover and remove passwords for Excel 2013 files. It uses multi-core CPU and GPU acceleration to swiftly recover the passwords. To use PassFab for Excel to recover your forgotten Excel password, follow the procedure below.

Step 1: Download install and launch PassFab for Excel on your PC.

Step 2: Click the Add button to import the password protected file.

recover file password

Step 3: Choose a suitable attack that will be used to recover the password: brute force with mask Attack, Dictionary attack or Brute Force Attack.

A. Dictionary attack can only be used if you have a dictionary. Download one or import it to the program if you already have one.

dictionary  settings

B. Brute Force with Mask attack option helps you key in any characters you recall about your password, making it easier for SmartKey Excel Password Recovery to recover it.

brute force with mask attack settings

C. Brute Force Attack unlocks your password by using a combination of all likely characters.

brute force

Step 4: Click Start and wait for the password to be recovered.

password successfully recovered

Summary

This article explains different ways to password protect Excel 2013 file. It is important to note down your password because you won’t be able to access the file without it. However, if you forget it, we recommend using PassFab for Excel to recover it.