Formula Tracing

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.
 
T

Tim879

\

try using the formula auditing toolbar and hitting trace precendents

its under view -> toolbars -> formula auditing
 
M

Marcelo

take a look at "Trace Precedentes" on the formula auditing.

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



"Wicad" escreveu:
 
Top