AFAIK you can only trace dependents for the Active Cell (or 1 cell at a
time). It may be time consuming, but just imagine how confusing it would be
to have possibly hundreds (maybe thousands) of arrows & rectangles suddenly
overlapping one another. IMHO, that would be even worse.

One thing that may expedite the task... Go to EditGoTo, click 'Special' &
choose Formulas (uncheck any boxes if appropriate). You can then click the
Trace Precedents button on the Formula Editing toolbar to still trace only
one cell at a time, but then you can just press Tab afterward to go directly
to the next cell to be traced.

HTH |:)

"Ian Elliott" wrote:

Thanks for any help.
I want to trace all dependents in a worksheet at once-is that possible?
I have a large worksheet, and it would take a long time to go to cell by
cell to trace dependents.
Thanks.