Excel 2007 Worksheet Protection

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

Step 1th 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 13.

Figure 13 Preparing cell formatting

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

Figure 14 Customizing settings

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