fbpx

How to password protect an Excel file?

Yodalearning>Tutorials>How to password protect an Excel file?

When you share one Excel spreadsheet with multiple users, you may don’t want the spreadsheet to be modified arbitrarily by unauthorized persons. If you wish to restrict access to an Excel workbook or if you wish to deny editing privileges to other users, consider adding a password to the workbook as a security measure.

 Excel allows users to encrypt and password-protect workbooks. 

You can protect your Excel file with a password to prevent others from accessing data in your Excel files. There are two different ways you can protect an Excel file — using encryption and the setting a password to open/modify an Excel file.

When you encrypt an Excel file, you lock it with a password. Once you encrypt an Excel file, no one else will be able to open it. This is the most common and recommended technique to lock an Excel file.

Now let’s see How to password protect an Excel file by following steps.
Click File Tab

Step 1: Click File Tab.
Click Info

Step 2: Click Info.
Click Protect Workbook

Step 3: Click Protect Workbook.
Select Encrypt with Password

Step 4: A drop down list will be appear. Select Encrypt with Password.
Encrypt Document Dialog box will be appear

Step 5: Encrypt Document Dialog box will appear. Enter the Password. Click OK.
reenter the password you entered in the previous step

Step 6: Again in the Confirm Password dialog box, re-enter the password you entered in the previous step.you will see that you need to enter that password to open that excel file

Step 7: Save your excel file and Close it. Now You have Successfully created a password for your Excel File. Reopen that excel file. Now you will see that you need to enter that password to open that excel file as like above picture.
Now we are going to set a password to allow reading or modifying another users

Tips: Now we are going to set a password to allow reading or modifying another users.

Step 8: In the Excel file, click File tab. Then click Save As. Now click Browse to browse a directory for Save this file.
then click Tools and then click General Options

Step 9: In the Save As dialog box, go to the folder you want to use, then click Tools and then click General Options.
General Options dialog box will be appear

Step 10: Now General Options dialog box will appear. You can specify one or both passwords here. One to open the file, another to modify the file, depending on your requirements.
Reenter your password into Confirm Password Dialog box that you added for modify purpose

Step 11: Now Click OK and Reenter your password into Confirm Password Dialog box that you added for modify purpose. Click OK, then Save.

From Now when Someone will open this Excel file, it will ask for password 2 times. One for open file and another one is to modify file.

Now your Excel file is fully protected both for open and modify.

WARNING: 

  • Be cautious when sharing files or passwords with other users.
  • Remember that locking a file with a password does not necessarily protect your file from malicious intent.
  • Microsoft can’t retrieve forgotten passwords.
  • There are no restrictions on the passwords you use with regards to length, characters or numbers, but passwords are case-sensitive.
  • It’s not always secure to distribute password-protected files that contain sensitive information such as credit card numbers.

Enjoy Excel..!!

Excel Dashboard
Limited Period Offer.

30-Day Money-Back Guarantee

Includes:


11 hours on-demand video
Full Lifetime Access
Success on mobile and TV
Certificate of Completion
Downloadable Case Studies
Lifetime Support