How to Remove Password from Excel 2013

Forgetting or misplacing Excel 2013 password can be frustrating and can result in unnecessary inconveniences, and that’s why most people would rather remove passwords from their documents than fail to access their documents on time. Users can also remove passwords to avoid the hassle of sharing the password with other collaborators of the file. In this article, we are going to talk about how to remove password from Excel 2013 with several different methods.

There are actually 5 types of password in Excel 2013, which are:

  • Open Password
    Users are prompted to key in the password each time the file is opened.
  • Modify Password
    Users can view the document but have to enter a password to modify its contents.
  • Read Only Password
    The password places the workbook in read-only mode and makes the workbook to open only in read-only mode. The document cannot be altered unless it is saved in another file location.
  • Workbook Structure Password
    This type of password prevents other users from viewing hidden worksheets and altering generally the structure of your Excel workbook.
  • Sheet Password
    Sheet password protects a particular worksheet preventing users from editing the contents of that worksheet. 

Part 1. Remove Open Password from Excel 2013 When Password is Known

Thinking about how to remove a password from Excel 2013 when the password is known? Users can do so by using the Protect Workbook feature as detailed in the procedure below.

Option 1. How to Remove Password to Open in Excel 2013

Step 1: Navigate to the location of the Excel file and open the workbook.

Step 2: Click the File tab locate in the ribbon then select Info.

Excel 2013 info options

Step 3: Click the dropdown arrow next to the Protect Workbook option.

Step 4: Click Encrypt with password option.

Excel 2013 info options

Step 5: A pop-up window will be displayed. Clear the dots in the password section and click Ok.

clear password

Step 6: Hit Ctrl + S simultaneously to save the document.

Now you can unprotect Excel 2013 workbook successfully. You will not be prompted to enter a password when you open the file.

Option 2. How to Remove Password to Modify in Excel 2013

The Modify Password prevents users from editing the contents of the workbook albeit they can view the documents.

Step 1: Navigate to the location of the Excel file and open the workbook.

Step 2: A Password dialog box will pop-up. Click the Read Only button. (Don’t type the password in the password field.)

click read only

Step 3: Click the File Tab located in the ribbon, then click Save As and select a different file location on your hard drive.

save as

Step 4: Save the file by clicking Save. This is a good workaround of modifying a modify password protected Excel file.

save as

Option 3. How to Remove Workbook Structure Password in Excel 2013

To remove the workbook structure password, follow the procedure in Option 1 and 2 above.

Option 4. How to Remove Sheet Password in Excel 2013

To edit a particular worksheet that has been password protected, remove the password by following the procedure below.

Step 1: Navigate to the Excel file in question, select a worksheet at the bottom of the interface right-click it and click Unprotect Sheet.

Step 2: Enter the password in the Unprotect Sheet Password dialog box and click Ok: it is the same password you used to protect your worksheet.

enter unprotect sheet password

Alternatively, in the ribbon, click Review and then Unprotect Sheet. Enter the unprotect sheet password in the dialog box that appears. This will remove Excel password from Workbook/Worksheet.

Part 2. Remove Excel 2013 Password When Password is Unknown

Want to remove password from Excel 2013? Look no further than PassFab for Excel. It is a great tool that allows users to remove and recover passwords on MS Excel 2019, 2016, 2013, 2010, 2007, 2003, 97. In addition to that, it employs three powerful attack options: the brute force with mask attack, dictionary attack, and brute force attack in the recovery of passwords. Better still, PassFab for Excel allows users to remove and recover passwords both online and on their computers. It supports decryption of multilingual Excel files at swift speeds regardless of the length of passwords and complexity all the while guaranteeing 100% decryption for both spreadsheets and workbooks.

Step 1: Download, install and run the free trial version of this Excel password recovery software on your PC.

Step 2: Click "+" button on the main interface.

add excel file

Step 3: Navigate to the location of the file you wish to remove the password and add it. Choose one of the password attack types, and then click Start button and the password will be removed.

excel password remove


This article details 5 methods users can use to unprotect Excel 2013 sheet without password. We recommend using PassFab for Excel since it is a simple and straight-forward process. Furthermore, PassFab for Excel allows users to remove password from Excel 2013 online. With it users are guaranteed of 100% document decryption; both workbooks and spreadsheets can be decrypted. It also supports decryption of Excel files in different languages. Users can also use it to recover forgotten passwords. It allows users to recover and remove passwords by using a multi-core CPU and GPU acceleration. Download it and try it out.

Updated on / Posted by Shirley Howard to Excel Tips / Follow @Shirley Howard

(Click to rate this post)

(0 votes, average: 5.0 out of 5 )


Product-related questions? Speak directly to our Support Team >>