Microsoft Office Tutorials and References
In Depth Information
Hide a Formula
Chapter 9: Protecting Excel Data
The Format Cells dialog
6 Click the Protection tab.
7 Click to select the Hidden
8 Click OK.
Note: Remember that the formula
is not hidden until you protect the
worksheet; for more information,
see the section, “Protect the Data in
In some cases you might want to hide not
only a formula, but also the formula’s
result. To do this, you need to create a
custom numeric format, as described in
Chapter 3. Specifically, you need to create
an empty custom numeric format, which
consists of just three semi-colons (;;;).
You then assign this format to the
If your workbook contains one or more
scenarios (see Chapter 5), you might not
want other users to see those scenarios.
To hide a scenario, click the Data tab, click
What-If Analysis, and then click Scenario
Manager. In the Scenario Manager dialog
box, click the scenario and then click the
Edit button. Click to select the Hide check
box, and then click OK.