Formula Tracing
 

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.

Formula Tracing
 

\

try using the formula auditing toolbar and hitting trace precendents

its under view - toolbars - formula auditing



On Jul 4, 9:46*am, Wicad wrote:
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.

Formula Tracing
 

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

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



"Wicad" escreveu:

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.