Microsoft Office Tutorials and References
In Depth Information
Tip 49: Hiding and Locking Your Formulas
Hiding and Locking Your Formulas
If you distribute workbooks to other users, you may want to hide your formulas. This tip describes
how to do so.
Every cell has two key properties: Locked and Hidden. A locked cell can’t be changed, and the
contents of a hidden cell don’t appear in the Formula bar when the cell is selected. By default, every cell
is locked and not hidden. But it’s important to remember that these attributes have no effect unless
the worksheet itself is protected.
A common scenario is to lock (and possibly hide) formula cells and unlock constant (nonformula cells).
Hiding and locking formula cells
Follow these steps to hide all of the formula cells on the active worksheet:
1. Select a single cell, and choose Home➜Editing➜Find & Select➜Go To Special. Excel displays
the Go To Special dialog box.
2. In the Go To Special dialog box, choose the Formulas option and make sure all four check
boxes are checked (see Figure 49-1).
3. Click OK, and Excel selects all of the formula cells.
4. Right-click any of the selected formula cells and choose Format Cells from the shortcut menu.
The Format Cells dialog box appears.
5. Click the Protection tab to display the Locked and Hidden checkboxes.
6. Check both the Locked and the Hidden check boxes.
7. Click OK to close the Format Cells dialog box.
Figure 49-1: Using the Go To Special dialog box to select all formula cells.