How to lock Excel file, set password, pass for Excel file

Your Excel file contains important data and you want to lock the Excel file to protect your Excel file. You do not know how to set password to lock Excel file, so you are looking to lock Excel file, set password, pass for Excel file to protect your Excel document? So, please refer to the following article.

How to lock Excel file, set password, pass for Excel file Picture 1

The following article is how to lock Excel files, please follow along.

Set a password for the Excel file

Method 1

Step 1: On the Excel file to set a password, select File -> Info -> Protect Workbook -> Encrypt with Password.

How to lock Excel file, set password, pass for Excel file Picture 2

Step 2: The Encrypt Document dialog box appears, enter the password you want to create for your Excel file in the box below Password and click OK .

How to lock Excel file, set password, pass for Excel file Picture 3

Step 3 : Next, in the Confirm Password dialog box, enter the password in the box below the Reenter password and click OK .

How to lock Excel file, set password, pass for Excel file Picture 4

After setup is complete you need to save the file to save changes to your file. So when you open the file, Excel will ask you to enter the password, you enter the correct password to open the file.

How to lock Excel file, set password, pass for Excel file Picture 5

Method 2

Step 1 : On the Excel file you want to set a password, select File -> Save As -> Browse or select the F12 key to open the Save As window .

How to lock Excel file, set password, pass for Excel file Picture 6

Step 2 : In the Save As window , select the location to save the Excel file, next to the name of the Excel file in the File name section . Then you select Tools -> General Options.

How to lock Excel file, set password, pass for Excel file Picture 7

Step 3 : The General Options dialog box appears , you can create a password for the Excel file by entering the password in the Password to open box if you want to create a password to open the file, enter the password in the Password to modify box if you Want to create a password to modify the Excel file. You can create both passwords if you want. Then click OK

How to lock Excel file, set password, pass for Excel file Picture 8

The Confirm Password - Reenter password to proceed dialog box appears, enter the password you entered in the Password to open box and click OK .

How to lock Excel file, set password, pass for Excel file Picture 9

The Confirm Password - Reenter password to modify dialog box appears, enter the password you entered in the Password to modify box and click OK to confirm.

How to lock Excel file, set password, pass for Excel file Picture 10

Then you click Save to save the file.

How to lock Excel file, set password, pass for Excel file Picture 11

Step 4 : So when you open the passworded Excel file, you will be asked to enter the password.

How to lock Excel file, set password, pass for Excel file Picture 12

If you put the password in the Password to modify box , you will be asked to enter the password as shown below. If you only want to read the file without editing you select Read Only, if you want to edit the file you need to enter the correct password.

How to lock Excel file, set password, pass for Excel file Picture 13

Delete password, password for Excel file

To delete the password and password set for the Excel file, you still need to enter the password to log in to the Excel file, select Excel File -> Info -> Protect Workbook -> Encrypt with Password.

How to lock Excel file, set password, pass for Excel file Picture 14

In the Encrypt Document dialog box, delete the characters in the box under Password and select OK to finish.

How to lock Excel file, set password, pass for Excel file Picture 15

Set a password to lock the sheet

Method 1 : Open the sheet to set a password, select the Review tab -> Protect Sheet.

How to lock Excel file, set password, pass for Excel file Picture 16

Method 2 : Right-click on the name of the Sheet below and select Protect Sheet.

How to lock Excel file, set password, pass for Excel file Picture 17

Step 2: The Protect Sheet dialog box appears, enter the password in the box below Password to unprotect sheet , in the Allow all users of this worksheet to section (allow all users of this sheet). ) select the sheet key properties you want to protect. Then click OK .

How to lock Excel file, set password, pass for Excel file Picture 18

Step 3 : The Confirm Password dialog box appears, enter the password in the box below Reenter password to proceed -> OK.

How to lock Excel file, set password, pass for Excel file Picture 19

So you can still see the Sheet, but you will not be able to perform the operations selected for protection in Step 2 if you do not enter the correct password to protect the sheet. To unlock the sheet protection, right-click the sheet name -> Unprotect Sheet or select Review -> Unprotect Sheet.

How to lock Excel file, set password, pass for Excel file Picture 20

Unprotect Sheet dialog box appears, enter the password protection in the Password box and click OK.

How to lock Excel file, set password, pass for Excel file Picture 21

To remove the password to protect the sheet, you need to unlock the sheet and press Ctrl + S to save the file.

So the article has shared with you how to lock files, password protect your Excel file as well as how to lock the sheet to protect your sheet. Hope this article will help you. Good luck!