As you say, when you use "Trace Dependents", an arrow appears to represent
dependencies on other sheets. Point at this arrow with the mouse (the arrow
itself, not the icon at its head) and the cursor will change from the normal
thich cross to a pointer. Double-click, and the "Go To" window will appear
with a list of all these dependencies on other sheets.

Of course, you can select any one and Go To it from here if you wish.
Hope this helps.
Stephen

"Mariano" <Mariano@discussions.microsoft.com> wrote in message
news:4EAB4F13-3631-4309-A261-3243E01208EE@microsoft.com...
> BTW, I thought Trace Dependents would work, however the arrows weren't to
> helpful, and it looks like it only traces on the current active worksheet,
> I
> need one to go across all worksheets.
> A list would be a lot easier to use then arrows.
>
> "Mariano" wrote:
>
>> Is there a way to get a quick view of all the cells that have a formula
>> that
>> reference a particular cell?
>>
>> For example-
>> If Sheet2!B3 is being used in 10 different formulas in 10 different
>> cells,
>> can I see that without manually checking?