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.
File option in Excel

Step 1: Click File Tab.
How to protect password in Excel File

Step 2: Click Info.
How to password protect in Excel File-Protect Workbook

Step 3: Click Protect Workbook.
How to Encrypt Password in Excel

Step 4: A drop down list will be appear. Select Encrypt with Password.
How to Encrypt Document in Excel using Password

Step 5: Encrypt Document Dialog box will appear. Enter the Password. Click OK.
Encrypt the content in this file using password

Step 6: Again in the Confirm Password dialog box, re-enter the password you entered in the previous step.How to insert password in Excel

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.
How to save as protect file in Excel

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.
How to use general option in Excel while save as

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..!!

 

Related Tutorials

Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018
25% Discount
No prize
All Courses at $200
Almost!
10% Discount
Free Ebook
No Prize
No luck today
Almost!
50% Discount
No prize
80% Discount
Get a chance to boost your knowledge!
Use this coupon code for any course that you wish for. 
Our in-house rules:
  • You can choose any course & redeem coupon
  • If you find any difficulty, mail us on [email protected]
  • Wheel Spin will end soon
  • Coupon code can be applied within 2 days.