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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and Trace Return Cell 2
referencing multiple cells when data is organised differently 1
Error when using Sum command 3
Help Writing a SUM Formula 5
Copy formula where the cell refrence is not sequential 1
Referencing a tab in a formula 2
Precedent Cell 1
Excel Vlookup Help 0

Back
Top