Microsoft Office Tutorials and References
In Depth Information
For specialized linear and nonlinear problems, Excel’s Solver add-in calculates solutions to
whatif scenarios based on adjustable cells, constraint cells, and, optionally, cells that must be
maximized or minimized. Excel 2010 comes with a new version of Solver.
Excel offers a number of different protection options. For example, you can protect formulas
from being overwritten 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
Lock to unlock
those cells. (The command toggles the Locked status.) Next, choose Home
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,
unless you have a protected worksheet.
When you protect a worksheet, the Protect Sheet dialog box (see Figure 1-14) 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.
Figure 1-14: Select which elements to protect in the Protect Sheet dialog box.
You can also hide your formulas so they won’t appear in the Excel Formula bar when the cell is
activated. To do so, select the formula cells and press Ctrl+1 to display the Format Cells dialog
box. Click the Protection tab and make sure that the Hidden check box is selected.