Protection of documents and cells can help prevent inadvertent changes to lớn your worksheet. This can be especially helpful if you have sầu someone who is unfamiliar with worksheets or doing your data entry, or if you spent many hours struggling to get the worksheet right.

Bạn đang xem: Khóa ô trong excel 2003

Excel offers the option of protecting the entire document, individual objects, structure of a window, and/or specific cells. With Excel, you can even add a password to lớn the file. If you want to lớn prevent changes to sheets or cells, you need to lớn loông xã the cells & then protect the sheet.

Protection Options

When you are protecting your workbook, you have sầu two primary options:

Prevent data entry for select cellsUsers can access the worksheet & view the information; however, access for making changes is restricted. For more information, refer khổng lồ Locking và Unlocking Cells below.

Restrict or prsự kiện access khổng lồ the fileUsers can be prevented from viewing the worksheet, or users can view the workbook but not make changes lớn it. For more information, refer to File Level Protection below.

Locking và Unlocking Cells

By mặc định, Excel protects cells, graphics, charts, và other worksheet objects. This protection will only take effect by turning on the Worksheet Protection option in the Protect Sheet dialog box. Therefore, if you enable protection, no changes can be made lớn a cell until you unlock that cell.

Locking Cells

You can easily lock any cell in a worksheet.

NOTE: Make sure lớn loông chồng the cells before you protect the sheet or document. Once a sheet or a document has been protected, you cannot access menu selections that allow you to lớn make changes to lớn cells.

Select the cell(s) lớn be locked.

From the Format menu, select Cells...The Format Cells dialog box appears.

Select the Protection tab.

Select Locked.There will be a kiểm tra before it.

*

Cliông chồng OK.

You must now protect the worksheet.

Unlocking Cells

In order khổng lồ unlock cells, sheet protection must first be turned off. For more information, refer lớn Worksheet Level Protection or Workbook Level Protection.

Unprotect the worksheet.

Select the cells you want to lớn unloông chồng.

From the Format thực đơn, select Cells...The Format Cells dialog box appears.

Select the Protection tab.

Deselect Locked.There will no longer be a kiểm tra before it.

Clichồng OK.The cells are unlocked.

Workbook Level Protection

You can prsự kiện a workbook from having its structure and windows modified or resized by another user.

Protecting the Workbook

From the Tools thực đơn, select Protection » Protect Workbook...The Protect Workbook dialog box appears.

*

In the Protect Workbook dialog box, select the appropriate option(s):OptionDescription
StructurePrevents the user from changing the order of the sheets within a workbook. This includes adding or deleting worksheets.
WindowsPrevents the user from being able lớn resize or move the window.
PasswordAllows only those who know the password lớn turn the workbook protection off.

Cliông xã OK.The workbook is protected.

Unprotecting the Workbook

From the Tools menu, select Protection » Unprotect Workbook…The workbook is unprotected. Users can now modify the structure & windows of the workbook.NOTE: If you included a password when you turned the protection on, you must enter the password to turn the protection off.

Xem thêm: Camera Nào Chụp Ảnh Đẹp Nhất Hiện Nay, 10+ Phần Mềm, Ứng Dụng Chụp Ảnh Đẹp Miễn Phí

Worksheet Level Protection

You can protect a single worksheet from being modified by another user.

Protecting the Worksheet

Windows:

From the Tools thực đơn, select Protection » Protect Sheet...The Protect Sheet dialog box appears.

*

In the Protect Sheet dialog box, select the appropriate options:OptionDescription
Protect worksheet and contents of locked cellsPrevents changes lớn locked cells.
Password to unprotect sheetAllows only those who know the password to unprotect the worksheet.
Allow all users of this worksheet toChecked boxes are aspects that any user can access.

Click OK.The worksheet is protected.

Macintosh:

From the Tools thực đơn, select Protection » Protect Sheet...The Protect Sheet dialog box appears.

*

In the Protect Sheet dialog box, select the appropriate options:OptionDescription
ContentsPrevents changes lớn locked cells, columns or rows, chart sheet, và any formulas in the cells.
ObjectsPrevents changes to lớn graphic objects (e.g., text boxes, an embedded chart).
ScenariosPrevents changes lớn scenartiện ích ios (i.e., any input đầu vào values you substituted in a worksheet).
PasswordAllows only those who know the password lớn unprotect the worksheet.

Cliông chồng OK.The worksheet is protected.

Unprotecting the Worksheet

From the Tools menu, select Protection » Unprotect Sheet…The worksheet is unprotected. Users can now modify the worksheet.NOTE: If you included a password when you turned the protection on, you must type the password in the Password text box to lớn turn the protection off.

File Level Protection

You have two options when saving your workbook file with a password. You can save sầu the file so only those who know the password can open or modify the file.

Protecting the File

From the File thực đơn, select Save As...The Save sầu As dialog box appears.

Windows: From the Tools pull-down menu, select General Options...Macintosh: Cliông chồng Options...The Save Options dialog box appears.

*

To prevent unauthorized access lớn the tệp tin, in the Password lớn open text box, type a password.To prevent unauthorized changes lớn the file, in the Password khổng lồ modify text box, type a password.

Click OK.The Confirm Password dialog box appears.

In the Reenter password lớn proceed/modify text box, type the password(s) in the order of the password(s) that you typed in the Save Options dialog box.HINT: If you type táo in the Password to open text box & orange in the Password to lớn modify text box, you must type táo khuyết in the first confirmation dialog box and orange in the second confirmation dialog box.

Cliông chồng OK.

Cliông xã Save.

Unprotecting the File

If you no longer need to lớn password-protect the file, you can remove sầu the password.

From the File menu, select Save sầu As…The Save As dialog box appears.

Windows: In the Save sầu As dialog box, from the Tools pull-down các mục, select General Options...Macintosh: Cliông xã Options.