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.
Search JabSto ::




Custom Search