Password Protect for an Excel Workbook - ScoreInExcel

Easy way to Learn Excel....

ads
Responsive Ads Here

Post Top Ad

Your Ad Spot

Wednesday 23 August 2017

Password Protect for an Excel Workbook

Protecting the excel workbook is helpful to keep our data confidential and safe from unauthorized access. No one can access information of that workbook without the password. Confidential data should be keep with more security, this password protect method will make our information to be safe from unauthorized access. Follow the below steps to protect the workbook.

Step 1: 

Go to menu bar and click "File->Save As" where you want to protect the excel workbook as shown in the below picture.

Protect workbook with Password
Protect workbook with Password

Step 2:

When you click the above option a "Save AS" window will appear as below.
password protect
Save As Window

Step 3:

In that window, click Tools option which is near to Save button. A drop down list will be displayed as shown in the below picture.
Password protect
Click Tools To put password

Step 4:

Click General Option... from the drop down list, a window will appear to type the password as below.
Password protect
General Option to type password

Step 5:

Type the desired password in "Password to Open:" text box and click OK button. Another window will appear to re-enter the same password to confirm as shown in the below picture.
Password Protect
Re-enter Password

Step 6:

Now your workbook is ready with password protection. Close your workbook and re-open. It will ask you to type the password the open the workbook as below.
Password Protect
Give Password to open workbook

Thank You Visit Again!!!...

No comments:

Post a Comment

Post Top Ad

Your Ad Spot