Change Or Remove Workbook Passwords, Protect An Excel File

You can help prevent unauthorized users from opening or modifying a workbook file, even if they have permission to open it.

Đang xem: Change or remove workbook passwords

Caution: When you create a password for a workbook, write down the password and keep it in a secure place. If you lose the password, you can”t open or gain access to the password-protected workbook.

Open the sheet or workbook that you want to protect.

On the Review tab, click Protect Sheet or Protect Workbook.

*

In the Password box, type a password, and in the Verify box, type the password again.

Choose any other protection options you want and click OK.

Click Save.

Require a password to open a workbook

Open the workbook that you want to protect.

On the Review tab, under Protection, click Passwords.

*

In the Password to open box, type a password, and then click OK.

In the Confirm Password dialog box, type the password again, and then click OK.

Xem thêm: hướng dẫn Classic Menu For Office 2007, 2010, 2013 And Other Product Lines

Click Save .

Require a password to modify a workbook

You can add a password so that only authorized users can make changes to a workbook. Users who are not authorized can still open the workbook and then save it by using a different file name.

Note: Unlike workbook element protection, which prevents changes to the structure and windows of a workbook, workbook-level password security helps protect the entire file against unwanted changes..

Open the document that you want to help protect.

On the Review tab, under Protection, click Passwords.

In the Password to modify box, type a password, and then click OK.

In the Confirm Password dialog box, type the password again, and then click OK.

Click Save .

Tip: To remove a password, select all contents in the Password to modify box, and then press DELETE .

*

*
*
*

*

Great! Any other feedback? The more you tell us, the more we can help.How can we improve? The more you tell us, the more we can help.

Xem thêm: Câu 1, 2, 3, 4 Trang 11 Vở Bài Tập Toán Lớp 5 Tập 1 Trang 11

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office lingocard.vn agents.

Xem thêm bài viết thuộc chuyên mục: Excel