How is the worksheet protected in Excel2007?

Excel2007 worksheet protection is very flexible, through the example below, I believe that friends will appreciate its benefits. Here, you will use the following features of Excel2007:

★ Insert Formula

★ Protect Worksheet

★ Remove Worksheet protection

First Step: Cell protection

By default, all cells have a locked property, and once the EXCEL2007 worksheet is protected, no data can be entered in those cells, so we have to cancel the locking properties of some cells.

First, you right-click the row and column junction of the worksheet, which produces two results: Select all cells and pop-up shortcut menus, and then click Format Cells, as shown in Figure 1.

Figure 1 Preparing cell formatting

Next, click Protect in the pop-up dialog box to switch to the tab page, as shown in Figure 2.

Figure 2 Customizing settings

Then, after you check lock and hide, click OK to exit the setup status and return to the Excel editing interface.

Step Two: Cancel the protection status of some cells

Select the range of the object cells, right-click, and select Format cells, as shown in Figure 3

Figure 3 Setting preparation

Then follow the previous action to clear the hook before the lock and hide, as shown in Figure 4.

Figure 4 Clearing the protection status of a cell

Step Three: Protect your worksheet

First, click Review to switch to the tool panel, then click Protect Sheet, then enter the password two times (the password must be the same two times), and then click OK, as shown in Figure 5.

Figure 5 Entering a password

Fourth step: test protection effect

Entering data in these cells will get the rejection dialog shown in Figure 18. In this way, we can only enter the data in the unprotected cell, which does not affect the normal use of the performance statistics, but also effectively protects the worksheet from being incorrectly manipulated.

Figure 6 Some of the cells are protected.

Fifth step: Unprotect the worksheet

If the EXCEL2007 worksheet is protected, the Protect Sheet button automatically changes to unprotect sheet, and we can click the button and then enter the previous password to unprotect the worksheet, as shown in Figure 7.

Figure 7 Removing worksheet protection