track use of cell

  • Thread starter Thread starter willemeulen
  • Start date Start date
W

willemeulen

When standing on a cell with formula you can see which cells it uses by
clicking the command line. Is it also possible the other way around. Can I
track if or where a cell is used in formulas elswhere in the sheet?
 
From the Formula Auditing Toolbar (under View|Toolbars|) click Trace
Dependents to see whether a cell is being referenced by any formula.


If this post helps click Yes
 
You must log in or register to reply here.

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

High light data 3
Tracking Changes Column Limit 2
Hyperlink 5
problem with fractions to decimal 1
Excel VBA 1
Conditional formatting in Excel 2010 2
automatically show cell references of formulas 2
Tracking using =sumproduct 3

Back
Top