Trace precedents and dependents

[Dhavalshah]

HI,

I want to trace precedents and dependents , where it pop out a box and helps to go through each cell. attaching screen shot for reference.

[HansV]

See Trace Precedents Add-In for Excel

[Dhavalshah]

Thanks. It is working.

Regards,
Dhaval

[Dhavalshah]

Hi,

It traces formula in reverse order for example i have put formula A8+A9+A10 then it will tracing first cell A10 then A9 and so on.

Is it possible to trace A8 then A9 and so on.

[HansV]

You'd have to ask Bill Jelen (MrExcel).