Protecting formulas from being overwritten

In many cases, you might want to protect your formulas from being overwritten or modified. To do so, perform the following steps:

1. Select the cells that may be overwritten.

2. Right-click and choose Format Cells from the shortcut menu.

3. In the Format Cells dialog box, click the Protection tab.

4. In the Protection tab, clear the Locked check box.

5. Click OK to close the Format Cells dialog box.

6. Select Review Changes Protect Sheet to display the Protect Sheet dialog box, as shown in Figure 2-18.

Protect Sheet

PI Protect worksheet and contents of locked cells Password to unprotect sheet:

Allow a: users of tn.s vcrksl-ee: to:

E Select locked cells

0 Select unlocked cells Format cells

J Format columns J Format rows

1 I Insert columns

J Insert hyperlinks

□ Delete columns

¡CanceTll

Figure 2-18: The Protect Sheet dialog box.

7. In the Protect Sheet dialog box, select the options that correspond to the actions to allow, specify a password if desired, and then click OK.

Note By default, all cells are locked. The locked status of a cell has no effect, however, unless you have a protected worksheet.

You can also hide your formulas so they won't appear in Excel's formula bar when the cell is activated. To do so, select the formula cells and make sure that the Hidden check box is marked in the Protection tab of the Format Cells dialog box.

0 0

Post a comment