Home Basic Excel 4 Ways to set password, lock Excel file to prevent editing, copying

4 Ways to set password, lock Excel file to prevent editing, copying

by Nhóm Biên Tập
A+A-
Reset

You do not want strangers to copy or edit the content of important documents and reports. If you do not know how to prevent and secure personal data, I will guide you through the steps to set a password for Excel files to prevent viewing, copying and editing. Follow along now!

I. How to set password, lock Excel file

1. How to set password, lock

Quick Guide

Open the Excel file that needs a password, select File > Click Save As > Select the Tools button > Select General Options > Select the installation mode (Password to open or Password to modify) and enter the password > Confirm the password you just set > Click Save and you have finished setting the lock for the Excel file.

Detailed instructions

Step 1: First, open the document you want to password protect, click File .

Click File

Step 2: Continue, click Save As .

Click Save As

Step 3: The Save As dialog box will appear on the screen, you need to select the location to save the file. Then, click the Tools button as shown.

Click the Tools button

Step 4: Continue, click General Options .

Click General Options

Step 5: At this point, the system will display an interface so you can set a password to open the Excel file.

Set password to open Excel file

There are 2 password setting modes you can choose from:

  • Password to open: requires a password to open the document. If you don’t know the password, you can’t view or edit any content in the file.
  • Password to modify: requires a password to edit the document. You can also choose not to enter a password and only read the file content and cannot copy or edit.

Step 6: Then, you will be asked to confirm the password you just set for the file .

Confirm the password you just set for the file.

Note: If you set 2 password modes, the system will ask you to confirm 2 passwords in the order Password to open then Password to modify.

Step 7: Finally, click Save to save the settings.

Click Save

Now when you open that Excel file, a form will appear asking you to enter the password to open the file as shown below.

Key entry required

2. How to remove password, lock

Quick Guide

Open the Excel file and enter the password > Select File > Click Save As > Select the Tools button > Select General Options > Delete the password in the mode you want to cancel > Click OK . So you have just deleted the document security mode.

Detailed instructions

Step 1: Open Excel file and enter password

Open locked Excel file and enter password

Step 2: Click File .

Click File

Step 3: Continue, click Save As .

Click Save As

Step 4: The Save As dialog box will appear on the screen, click the Tools button as shown.

Click the Tools button

Step 5: Continue, click General Options .

Click General Options

Step 6: Now, you just need to delete the password in the mode you want to cancel > Click OK . So you have just deleted the document security mode.

Delete the password in the mode you want to cancel

II. How to set password and lock using Protect Workbook

1. How to set password, lock

Quick Guide

Open the Excel file that needs a password, select File > Click Protect Workbook > Select Encrypt with Password > Enter the password and confirm the password > Click OK to save the password.

Detailed instructions

Step 1: First, open the document you want to password protect, click File .

Click File

Step 2: On the Info tab, click Protect Workbook > Select Encrypt with Password .

Click Protect Workbook

Step 3: The system will display an interface for you to enter the password for the Excel file .

Enter password for Excel file

Step 4: Then, you will be asked to confirm the password you just set for the file .

Confirm Password

Now when you open that Excel file, a form will appear asking you to enter the password to open the file as shown below.

Password required

2. How to remove password, lock

Quick Guide

Open the locked Excel file and enter the password > Select File > Click Protect Workbook > Select Encrypt with Password > Delete the set password > Click OK .

Detailed instructions

Step 1: Open Excel file and enter password

Open locked Excel file and enter password

Step 2: Click File .

Click File

Step 2: Click Protect Workbook > Select Encrypt with Password .

Click Protect Workbook

Step 3: Delete the password you set for the Excel file > Click OK .

Delete password, click Ok

III. How to create a password for a sheet on Excel

Note: Normally, this method of creating a lock applies to document files with more than 1 worksheet. Creating a password for a sheet helps you limit the right to edit and change important data.

1. How to set password, lock

Quick Guide

Open the Excel sheet that needs a password, select Review > Click Protect Sheet > Enter the password and click OK > Re-enter the password to confirm and click OK > You have now set the lock for the sheet on Excel.

Detailed instructions

Step 1: First, open the document that needs a password, select the sheet you want to lock editing > Click Review .

Click Review

Step 2: Click Protect Sheet to lock that sheet.

Click Protect Sheet

Step 3: Next, enter the password to lock editing > Click OK.

Enter password to lock editing

Step 4: The system will ask you to re-enter your password to confirm > Click OK.

Re-enter password to confirm

Finally, you will see the formatting and editing toolbar of that sheet dimmed as shown. So you have successfully set a password for the sheet!

Lock editing and formatting

2. How to remove password, lock

Quick Guide

Open the Excel sheet with a password, select Review > Click Unprotect Sheet > Enter the password set for that sheet > Click OK . So you have just removed the password for the Excel sheet.

Detailed instructions

Step 1: First, open the sheet (spreadsheet) you want to delete the created password > Click Review .

Click Review

Step 2: Click Unprotect Sheet to remove the lock created for that sheet.

Click Unprotect Sheet

Click Unprotect Sheet

Step 3: Next, enter the set password > Click OK.

Enter the set password

Finally, you should see your spreadsheet’s formatting and editing toolbar appear as normal!

Unlock

IV. How to enable protection for any Excel data area

1. How to set password, lock

Quick Guide

  • Highlight the entire content of the worksheet > Right-click > Select Format Cells… > Uncheck Locked for the worksheet in the Protection section.
  • Highlight the area you want to lock > Right click > Select Format Cells… > Select Locked in the Protection section.
  • Click Review > Select Allow Users to Edit Ranges/ Allow Edit Ranges > Click New > Enter password and confirm password > Click OK.
  • Select Protect Sheet in the Allow Users to Edit Ranges/ Allow Edit Ranges dialog box > Enter the password and confirm the password > Click OK . You have successfully created a password for the data range!

Detailed instructions

Step 1: Highlight the entire spreadsheet content. Right-click then select Format Cells…

Right click, select Format Cells...

Step 2: In the Protection section, uncheck Locked > Click OK.

Uncheck the Locked section

Step 3: Select the Excel data area you need to lock > Right-click > Select Format Cells…

Right-click in the area, select Format Cells...

Step 4: In the Protection section, re-check the Locked section > Click OK.

Click again to select the check mark in the Locked section

Step 5: Click Review > Select Allow Users to Edit Ranges/ Allow Edit Ranges .

Select Allow Users to Edit Ranges

Step 6: In the dialog box that appears, click New .

Click New

Step 7: Then, enter the password for the area to be locked as shown below > Click OK.

Enter the password for the area to be locked, select OK

Step 8: You are asked to re-enter your password to confirm > Click OK.

Re-enter password to confirm

Step 9: Next, select Protect Sheet in the Allow Users to Edit Ranges dialog box .

Select Protect Sheet in the Allow Users to Edit Ranges dialog box

Step 10: Enter the password to lock editing > Click OK.

Enter password to lock editing

Step 11: The system will ask you to re-enter your password to confirm > Click OK.

Confirm Password

Finally, when you click on the locked area, you will see a similar password request command appear below. So you have successfully created a password for the data area!

Key entry request dialog

2. How to remove password, lock

Quick Guide

Select the locked data area > Select Review > Click Unprotect Sheet > Enter the set password > Click OK.

Detailed instructions

Step 1: Select the password-locked data area > Click Review .

Click Review

Step 2: Click Unprotect Sheet to delete the created key.

Click Unprotect Sheet

Step 3: Next, enter the password created for that area > Click OK .

Enter the password created for that area

Above is a detailed article guiding you on how to set passwords and locks for Excel files. Hopefully it will help you secure your documents, prevent strangers from copying and editing content. Wish you success!

See more: 6 Ways to separate data in Excel simply and quickly

Bài viết cùng chuyên mục

Leave a Comment

Về chúng tôi

Chào mừng các bạn đến với “Hoa ngữ Phổ truyền ” – nơi chúng tôi luôn cố gắng giúp bạn học tiếng Trung một cách tốt nhất! Chúng tôi hân hạnh được chia sẻ với cộng đồng những kiến thức, tài liệu, phần mềm trải nghiệm học tiếng Trung và văn hóa truyền thống Trung Hoa.

Bài viết nổi bật

@2023 – Bảo lưu mọi quyền. Được thiết kế và phát triển bởi hoanguphotruyen