Microsoft Office Tutorials and References
In Depth Information
Excel offers a number of different protection options. For example, you can protect formulas
from being overwritten or modified, protect a workbook’s structure, password-protect a
workbook, and protect your VBA code.
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:
Select the cells that may be overwritten.
Right-click and choose Format Cells from the shortcut menu.
In the Format Cells dialog box, click the Protection tab.
In the Protection tab, clear the Locked check box.
Click OK to close the Format Cells dialog box.
Choose Review ➜ Changes ➜ Protect Sheet to display the Protect Sheet dialog box, as
shown in Figure 2-18.
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.
By default, all cells are locked. The locked status of a cell has no effect, however, unless
you have a protected worksheet.
Figure 2-18: The Protect Sheet dialog box.