Microsoft Office Tutorials and References
In Depth Information
5. Use the Review ⇒ Changes ⇒ Protect command to protect the worksheet.
To prevent others from unprotecting the sheet, specify a password in the Protect Sheet dialog box.
Figure 2-7: Use the Format Cells dialog box to change the Hidden and Locked status of a cell or
By default, all cells are locked. Protecting a sheet prevents any locked cells from being changed. So you should
unlock any cells that require user input before protecting your sheet.
Be aware that it's very easy to crack the password for a worksheet. So this technique of
hiding your formulas does not ensure that no one can view your formulas.
Errors in Formulas
It's not uncommon to enter a formula only to find that the formula returns an error. Table 2-4 lists the types of
error values that may appear in a cell that has a formula.
Formulas may return an error value if a cell that they refer to has an error value. This is known as the ripple ef-
fect: A single error value can make its way to lots of other cells that contain formulas that depend on that cell.
Table 2-4: Excel Error Values