How to Password Protect Excel Workbook Microsoft Excel Tips


The Excel are one of the most important software which is broadly used in official works. It is used for Financial reporting, calculations and progress reporting. There are many sensitive data which are kept in it e.g; Reports. So, the company is supposed to be make it completely protected and unapproachable from the unconcerned one.Therefore, today we are going to share an important guide with you guys which will be making you learn that,

“How to Password Protect Excel Workbook?” The ATT has started a series for sharing Microsoft Excel tips in order to treat our official readers to. We are sure that the excel tips which are going to be shared here, are going to help many of officials out there and their is going to be convenient after applying these tricks.

Learn-How to Password Protect Excel Workbook

Here are the steps which you are supposed to follow to password protect Excel Workbook. The steps are simple and easy to be applicable. You only need to apply them with great care in order to avoid any error or lapse which may occur while apply wrong steps. So, now you are suggested to get towards the steps to explore about your query.

First of all, Open your Excel Workbook (File) and insert data which you want to password protect.

Now, Click on File button from top left corner and then Click on Save As button

After that, a pop up window will appear which will ask you to name your file, you need to name your file and then on the same pop up, Click on Tools and then from drop-down menu, Click on General Options…

Furthermore, you will have another pop-up which will ask you to set password for your Workbook. Now, enter the password to enter and Password to modify. You may give both the same. One will be required to open the file and the one will be required to make changes in it.

This was it!

Must Check: How to Lock a Folder without Using Software,folder lock

Removing Set Password

How to Password Protect Excel Workbook Microsoft Excel Tips

Now, you might be thinking that, “How to remove that set password from Workbook?” So, that is why, we are including this piece too. In order to remove or lift password from your workbook. You need to apply these steps:

Go to Save As panel >> Tools >> General Options >> Erase the Set Password and Click OK >> This was it.


This was our guide to password protect excel workbook. We are sure that now you can improve the security of your excel workbook. If you have any kind of question or confusion left related to this guide then do let us know. We shall get back to your queries and questions as soon as possible. Till then don’t forget to share this guide with your other friends and circle too. So, keep sharing and liking our content over social media in order to help the complete fraternity.