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.

Note

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.