Cách Khóa Sheet Hoặc Một Vùng Nội Dung Của Sheet Trong Excel

By checking this box, you agree lớn the Terms of Use and Privacy Policy và to receive electronic communications from giangdien.com.vn, which may include marketing promotions, news & updates.

Excel 2010 includes a Protect Workbook command that prevents others from making changes lớn the layout of the worksheets in a workbook. You can assign a password when you protect an Excel workbook so that only those who know the password can unprotect the workbook & change the structure or layout of the worksheets.

Bạn đang xem: Cách khóa sheet hoặc một vùng nội dung của sheet trong excel

Protecting a workbook does not prevent others from changing the contents of cells. To protect cell contents, you must use the Protect Sheet command button on the reviews tab.

Protecting a workbook

Follow these steps to lớn protect an Excel 2010 workbook:

Click the Protect Workbook command button in the Changes group on the đánh giá tab.

Excel opens the Protect Structure và Windows dialog box, where the Structure check box is selected by default. With the Structure kiểm tra box selected, Excel won"t let anyone mess around with the sheets in the workbook (by deleting them or rearranging them).


You can protect the structure và windows in a workbook.

(Optional) If you want to protect any windows that you phối up, select the Windows kiểm tra box.

When selected, this setting keeps the workbook windows in the same kích cỡ and position each time you open the workbook.

Xem thêm: Giáo Án Lớp 4 Tuần 31 Đến 34, Giáo Án Toán Lớp 4 Tuần 31 Mới Nhất, Chuẩn Nhất

To assign a password that must be supplied before you can remove the protection from the worksheet, type the password in the Password (optional) text box.

Click OK.

If you typed a password in the Password (optional) text box, Excel opens the Confirm Password dialog box. Re-enter the password in the Reenter Password to lớn Proceed text box exactly as you typed it Step 2, & then click OK.

Unprotecting a workbook

To remove protection from the current workbook, follow these steps:

Click the highlighted Protect Workbook command button in the Changes group on the review tab.

The Unprotect Workbook dialog box appears.

If you assigned a password when protecting the workbook, type the password in the Password text box and click OK.

Xem thêm: Cách Bật Hoặc Tắt Gợi Ý Trang Được Đề Xuất Trên Facebook ? Cách Tắt Bài Viết Đề Xuất Trên Facebook

Protecting a shared workbook

If you create a workbook with contents to lớn be updated by several different users on your network, you can use the Protect và Share Workbook command khổng lồ ensure that Excel tracks all the changes made and that no user can intentionally or inadvertently remove Excel"s tracking of changes. Follow these steps:

Click the Protect và Share Workbook command button in the Changes group on the đánh giá tab.