Dots on Trace Precedents Arrows

T

Tanya

In Excel 2007, what is the meaning of the blue dots that appear on the
trace precedents arrows? I have an average formula that references
some non-contiguous cells. When I click Trace Precedents it shows a
line down the column containing the cells, but not every cell is
referenced in the formula. I thought the blue dots indicated the cells
that were referenced, but that's not the case. Any ideas? Thanks,
 
B

Bernard Liengme

I cannot repeat this. I have numbers in F1, F7 and F12 and in F14 I have the
formula =AVERAGE(F1,F7,F12). With Traces Precedence on, there is a blue line
from F1 to F14 with dots at F1, G7 and F12 and the arrow is in F14 as
expected.

This =AVERAGE(F1,F4,F7:F10) results in dots in F1, F4 and F7 with a box
around F7:F10

best wishes
 

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

Trace precedents from another worksheet 0
Data Validation drop down not showing and Formula Auditing bar greyedout 2
Trace Dependents doesn't work (precedents does!) 4
Trace Precedents (Saving Tracing to print) 0
Fastest ways to trace formulas (especially when cells link to otherworksheets) 4
Office 2007 Trace Precedents + Tables 8
Alternative for Trace Precedents 4
Trace Precedents Arrows Missing 0

Top