Microsoft Office Tutorials and References
In Depth Information
Displaying Formulas in a Worksheet
As you know, formulas do not
normally display in the worksheet. Instead, the
results of formulas appear in the result cells. If
you click a result cell, the formula appears in the
Formula bar—but that means in order to check a
formula, you have to first find and then click its
result cell and look in the Formula bar. A rather
tedious process, especially if your worksheet has
a lot of formulas.
Follow these steps to display formulas:
1. Change to the worksheet containing the
formulas you want to display. To change
from one worksheet to another, click the
worksheet’s tab, located along the bottom
of the Excel window.
2. Click the Formulas tab.
3. Click the Show Formulas button, located in
the Formula Auditing group. Cells are
automatically expanded to display formulas fully,
as shown in Figure 4-1.
Luckily, Excel allows you to display formulas
instead of results when needed. With formulas
displayed, it’s easier to double-check each one
to ensure that it was entered correctly, which is
particularly helpful when the formulas in your
worksheet are long or complex.
Cells referred to by the
result cell are highlighted
With formulas displayed, you can
print them if you like, and then use
the printout to double-check formulas.
Displaying formulas in a worksheet is an all-or-
nothing thing, which means that once you display
formulas, they remain displayed in that
worksheet until you turn the feature off. By the way,
this is a worksheet-level feature, so if you want
to display formulas in all the worksheets in a
workbook, you need to repeat these steps for
One way to check formulas is to display
them in the worksheet.