November 3, 2009

Tracing Cell References

Excel 2003 or 2007

Double click on a cell containing a formula and Excel will highlight the various cells used in the formula. Each step will be bordered in a different color that will coordinate with the formula.
  1. Cell contains formula adding C1 + D5 + G7.
  2. Double click on cell with formula.
  3. C1, D5 and G7 will be bordered with colors that match your formula.

No comments:

Post a Comment