How to Lock an Excel File Using Password to Be Secure [2023]


How to Lock an Excel File Using Password to Be Secure-Hello Friends, Welcome Back to Techgarv. In This Post, I’m Telling You How to Lock an Excel File Using Password to Be Secure.

Locking an Excel file with a password in an effort to protect your Excel worksheet so that it can prevent others from destroying your data. But it’s a good idea to never store very sensitive information in an Excel file. Why? The reason is simple, password-protecting Excel files can actually be easily hacked.

How to Lock an Excel File Using a Password to Be Secure

How to Lock an Excel File Using Password to Be Secure

This is possible because Excel itself uses a very weak form of encryption which can be easily breached using dictionary attacks and brute force attacks.

Read more:

However, if you really have to use Excel to store important and sensitive information, then it’s a good idea to use the latest versions of Excel, namely Excel 2013 or Excel 2010. Now there are also the latest editions of Microsoft, 2016 and 2019.

The older the version of Excel you are using, the easier it will be for people out there to crack your Excel file password. Inversions below Excel 2010, it doesn’t matter how complex or long the password you use, anything can be hacked.

In addition, newer versions of Excel already use more sophisticated encryption methods and therefore the length and complexity of the password you use are very important and influential. So you should use a longer password that is more random in nature and also include numbers and symbols in the password.

Locking Excel Files

Apart from protecting and password-locking certain Excel worksheet files, you can also secure and lock the entire Excel workbook file. So you can decide whether to lock the worksheet or lock all Excel worksheets in the Excel workbook file.

For those of you who don’t know what is the difference between a worksheet and a workbook in Excel, please read the discussion here: Difference between a workbook and a worksheet in Excel.

Now we will enter the tutorial section on how to lock an Excel file with a password. When using Microsoft Excel, there are several different ways to protect your Excel worksheet or workbook.

First step

The first method is one of the easy methods for you to apply to lock Excel files either only worksheets or the entire workbook.

To lock an Excel file in Microsoft Excel 2013:

  1. First of all, go to the Review tab.
  2. Then click Protect Sheet (to lock the worksheet ) or Protect Workbook (to lock the workbook ).
  3. When a new window appears, select the options you want by clicking the check or uncheck options.
  4. Then type the desired password. A password can be something random that no one will ever suspect ( like GBE45nf23 ) or it may be whatever the important passwords are complex and difficult for others to guess.
  5. To remember passwords, you can try using a password manager program like LastPass, which is very secure. Or you can also use Notepad to store your password.
password in excel table

If you previously chose to Protect Sheet. You can also lock excel workbook files at once. To do this:

  1. Click File
  2. Then select Save As.
  3. When the Save As file window appears, type a name for your file, then select the Tools drop-down menu.
  4. From the menu, then select General Options …
  5. Done.
tools in excel table

Then later this method can lock the entire Excel workbook file with a password and prevent other people from opening and viewing its contents. At this point, you have two layers of protection: one at the worksheet level and one at the workbook level.

Now, every time you want to open the locked Excel file, you will see a screen like the one below asking you to enter the password for the file.

Second Way

The second way I will give you to be able to lock the Excel file is limited to the Excel workbook only and not to the worksheet. So you can use this method if you really want to lock the Excel file as a whole.

Straight to.

  1. Please open the Excel file that you want to lock first (I am using Excel 2013 here). So you can just adjust it because the menu is not much different.
  2. Click the File menu in the upper left corner of the Excel window.
  3. On the left bar, select the Info menu and click on Protect Workbook.
  4. Then select Encrypt With Password and enter the password you want.
  5. If you have, please click OK to finish it.
  6. Then don’t forget to Save the file.

So now you can lock and password-protect your Excel file. If you open it again, there will be a notification to enter the password so that the file can be accessed.

How to Remove an Excel File Password

If one day you no longer need the password that you used in the Excel file, then you can remove the password again so that it is back to normal.

The method is straightforward.

  1. Open the Excel file which is locked with a password.
  2. Enter the password when the notification appears to be able to access the file.
  3. Click on the File menu.
  4. Select Info and click on the Protect Workbook box.
  5. Then select Encrypt With Password, please delete all password points in the column.
  6. Click OK to finish.
  7. Don’t forget to click Save the password-deleted file.

Now files that were locked with a password can be opened normally without having to enter a password first.

Overall, using Excel security in a simple password-protection manner is not sufficient to secure Excel files. Especially if the data in your worksheet is important data for the company or office where you work.

You need better encryption using a higher version of Excel, a longer password, and a higher number of words at random, as well as the extra, highly secure encryption Excel provides.

Closing:[Lock an Excel File Using Password to Be Secure]

Finally, if you follow the tutorial and also my advice above for your Excel file security efforts, God willing, your Excel file will be protected from evil hands and no one can access it freely without your permission, of course.

Don’t forget to bookmark and always visit every day because you can find here the latest Tech Computer Android games How-to Guide Tips&Tricks Software Review etc, Which we update every day.

Hope it’s useful, Thank You.


Please enter your comment!
Please enter your name here