Microsoft Office Tutorials and References
In Depth Information
Displaying underlying formulas
Displaying underlying formulas
Usually, cells containing formulas display the results of that formula, not the formula itself.
Similarly, when you format a number, you no longer see the underlying (unformatted) value
displayed in the cell. You can see the underlying values and formulas only by selecting
individual cells and looking at the formula bar or by double-clicking the cell. But what if you
want to see more than one formula at once?
Click the File tab and click Options. In the Advanced category of the Excel Options dialog
box, scroll down to the Display Options For This Worksheet group and select the Show
Formulas In Cells Instead Of Their Calculated Results check box. This displays underlying values
and formulas, only for the worksheet you select in the Display Options For This Worksheet
drop-down list. As you can see in the worksheet view shown at the bottom of Figure 3-23,
the underlying contents of each cell appear, as in the sum formulas in rows 6 through 10,
and all the cells are left aligned. (Excel ignores any alignment formatting when you select
the Show Formulas check box.) In addition, the width of each column on the worksheet
approximately doubles to accommodate the underlying formulas. (The actual width of the
columns remains unchanged; columns appear wider only on the screen.) When you clear
the Show Formulas check box, Excel restores all columns to their former widths.
You can quickly display and hide formulas in your worksheet by pressing Ctrl+` (accent
grave), which is located on the tilde (~) key on most keyboards. To redisplay values,
press Ctrl+` again.
Figure 3-23 Display underlying values and formulas for easier auditing.
Search JabSto ::

Custom Search