Formula Tracing

  • Thread starter Thread starter Wicad
  • Start date Start date
W

Wicad

When one cell is the product of a number of other cells (ie. sum), when I hit
F2 I can trace all the cells that are included as part of the formula.
However this only works if all the cells are on the same tab and not included
across other tabs. Is it possible to have cells included as part of the
formula highlighted when I go to those tabs as well. Thanks.
 
\

try using the formula auditing toolbar and hitting trace precendents

its under view -> toolbars -> formula auditing
 
take a look at "Trace Precedentes" on the formula auditing.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Wicad" escreveu:
 
Back
Top