Microsoft Office Tutorials and References

In Depth Information

**Seeing All Formulas**

Figure 9.26.

Figure 9.26.
Immediately after selecting all formulas, select the Paint

Immediately after selecting all formulas, select the Paint

Bucket icon to color the formula cells.

Bucket icon to color the formula cells.

Seeing All Formulas

Seeing All Formulas

For a long time, Excel has given users the ability to see all the formulas in

a worksheet. The mode that provides this functionality is called ShowFor-

mulas mode.

To toggle into Show Formulas mode for a worksheet, select the Formulas tab,

and then choose the Show Formulas icon in the Formula Auditing group. Al-

ternatively, you can press Ctrl+` (the backtick) to toggle into this mode. On

U.S. keyboards, the backtick is usually found just below the Esc key, on the

same key with the tilde (~).

Figure 9.27
shows a worksheet with all formulas showing.