Microsoft Office Tutorials and References
In Depth Information
Refer to Chapter 21 for more information about Excel's auditing features.
For specialized linear and nonlinear problems, Excel's Solver add-in calculates solutions to what-if scenarios
based on adjustable cells, constraint cells, and, optionally, cells that must be maximized or minimized.
Excel offers a number of different protection options. For example, you can protect formulas from being over-
written or modified, protect a workbook's structure, and protect your VBA code.
Protecting formulas from being overwritten
In many cases, you may want to protect your formulas from being overwritten or modified. To do so, you must
unlock the cells that you will allow to be overwritten and then protect the sheet. First select the cells that may be
overwritten and choose Home ⇒ Cells ⇒ Format ⇒ Lock to unlock those cells. (The command toggles the Locked
status.) Next, choose Home ⇒ Cells ⇒ Format ⇒ Protect Sheet to show the Protect Sheet dialog box. Here you can
specify a password if desired.
By default, all cells are locked. Locking and unlocking cells has no effect, however, un-
less you have a protected worksheet.
When you protect a worksheet, the Protect Sheet dialog box (see Figure 1-10) lets you select which elements
won't be protected. For example, you can allow users to sort data or use AutoFiltering on a protected sheet.