How to Protect Excel File with Password (3 Quick Methods)

For a confidential workbook, we must need to protect it with a password for security purposes. Excel has several ways to do it easily. You can set different kinds of protection in a file according to your need. In this article, I’ll show 3 quick and effective ways to protect an excel file with a password.


Download Practice Workbook

You can download the free Excel template from here and practice independently.
The password for the file is- 1234.


3 Ways to Protect Excel File with Password

Let’s get introduced to our dataset that represents some Salesperson’s Sales for 2021 in different Regions.


1. Use Protect Workbook Command from Review Tab to Protect Excel File with Password

You will get a command named Protect Workbook in the Review ribbon. We can apply it to protect our workbook structure from other users like no one can add, hide or unhide sheets.

Steps:

  • First, click as follows: Review ➤ Protect ➤ Protect Workbook.

Use Protect Workbook Command from Review Tab to Protect Excel File with Password

  • Next, type a password. I typed 1234.
  • Then press OK.

Use Protect Workbook Command from Review Tab to Protect Excel File with Password

  • Finally, Reenter the password and press OK again.

💬 Note: You will get the Windows option available in Excel 2007, 2010 for Windows OS, and 2011, 2016 for Mac OS. Using the Windows option other users can’t move, resize, or close the workbook window, and hide/unhide windows.

Now have a look, these options are unavailable after protecting the Structure.

Read More: How to Protect Excel Workbook from Editing (5 Effective Methods)


2. Apply Protect Workbook Command from File Option to Protect Excel File with Password

If you want that no one can open your workbook without a password then it is also possible to do it in Excel. No user will be able to open the workbook without the password.

Steps:

  • Click on File beside the Home tab.

Apply Protect Workbook Command from File Option to Protect Excel File with Password

  • After appearing the File menu, click as follows: Info ➤ Protect Workbook ➤ Encrypt with Password.

Apply Protect Workbook Command from File Option to Protect Excel File with Password

  • Give your desired password and press OK.

Apply Protect Workbook Command from File Option to Protect Excel File with Password

  • Reenter the password and press OK

Now close the file and try to open the file again, it will ask for the password first.

Read More: [Fixed!] Protect Workbook in Excel Not Working (with Quick Solution)


3. Use General Options to Protect Excel File with Password

There is another option in Excel by which we can set passwords to open a file also to modify a file. Or you can use them separately.

Steps:

  • Click on the File tab.

Use General Options to Protect Excel File with Password

  • Next, click Save As ➤ Browse.

Use General Options to Protect Excel File with Password

Here, a dialog box will open up.

  • Then click on Tools.
  • Later, select General Options from the drop-down

Use General Options to Protect Excel File with Password

  • Now set a password to open the file.
  • After that set another password to modify the file. I typed 1234 in both fields.
  • Next, press OK.

Use General Options to Protect Excel File with Password

  • Type the password again to proceed and press OK.

Use General Options to Protect Excel File with Password

  • Then Reenter the password to modify.
  • Finally, just press OK to finish.

Now close the workbook and open it again, it will ask for the password.

  • Give the password to open the file.

  • Next, it will ask for the password to modify.

Read More: Protect and Share Excel Workbook (2 Quick Methods)


Caution

  • There is no way to recover the Excel password. So keep your password written down in a safe place otherwise you may lose your important file if you can’t remember the password.

Conclusion

I hope the procedures described above will be good enough to protect an Excel file with a password. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo