Excel is a powerful spreadsheet software that is commonly used in business and personal finance. It allows you to create and manage financial statements, budgets, data tables, and charts. However, sometimes you may encounter an Excel file that is locked and protected with a password. In this article, we will show you how to unlock and open password-protected Excel files.

How to Open Password-Protected Excel Files

If you have access to the password-protected Excel file, opening it is easy and straightforward. Follow these steps:

  1. Open Microsoft Excel and click on the File menu.
  2. Select Open, locate the password-protected file, and double-click on it.
  3. Enter the password in the dialog box and click OK.

If you have forgotten the password, things can get a bit more complicated. Keep reading to learn how to recover a forgotten password.

How to Recover Forgotten Passwords for Excel Files

There are several methods you can use to recover a forgotten password for an Excel file. Here are some of the most effective ones:

Method 1: Try Common Passwords

Often, people use predictable passwords that are easy to remember, such as their names, birthdates, or simple words. Try these common passwords before moving on to more complex methods:

  • The name of the person who created the file
  • The name of the company or organization
  • The word “password” or “12345”

Method 2: Use a Password Recovery Tool

If the common passwords do not work, you can use a password recovery tool. These tools use brute-force or dictionary attacks to crack the password. Here are some popular password recovery tools:

Download and install the software on your computer, then follow the instructions to recover the password. Note that this method may take some time and it is not guaranteed to work.

How to Lock Excel Sheets and Workbooks

Now that you know how to unlock password-protected Excel files, you may want to learn how to protect your own Excel sheets and workbooks. Locking your Excel files is essential if you want to keep your data and formulas secure and prevent unauthorized access. Here’s how to do it:

How to Lock Excel Sheets

Excel allows you to lock individual sheets in a workbook. This is useful if you have sensitive data on a specific sheet that you want to protect. Here’s how to lock a sheet:

  1. Right-click on the sheet you want to lock and select Protect Sheet.
  2. In the Protect Sheet dialog box, select the options you want to allow users to perform on the sheet, such as select cells, format cells, insert rows or columns, and so on.
  3. Enter a password in the Password to unprotect sheet field, then click OK.
  4. Re-enter the password in the Confirm Password dialog box and click OK.

How to Lock Excel Workbooks

You can also lock entire Excel workbooks. This is useful if you want to ensure that nobody can open or modify your workbook without the password. Here’s how to lock a workbook:

  1. Click on the File menu and select Info.
  2. Click on the Protect Workbook drop-down menu and select Encrypt with Password.
  3. Enter a password in the Password field and click OK.
  4. Re-enter the password in the Confirm Password field and click OK.
  5. Save the workbook to apply the password protection.
Baca Juga :  Bagaimana Membuat Rumus Excel Jumlah Hari Kerja Pada Bulan


Q: What if I can’t remember the password for my Excel file?

If you forgot the password for your Excel file, you can use a password recovery tool to crack it. Alternatively, you can recreate the file and start over.

Q: Is it safe to use password recovery tools?

Yes, it is safe to use password recovery tools as long as you download them from a reputable source. Make sure to scan the downloaded file for viruses before installing it on your computer.


Excel files can be password-protected to prevent unauthorized access and modifications. Unlocking a password-protected Excel file is easy if you have the password, and if you don’t, you can use password recovery tools to crack it. Additionally, you can lock your own Excel sheets and workbooks to ensure that your data and formulas remain secure and confidential. By following the steps outlined in this article, you can enjoy the full benefits of Excel without worrying about security risks.