Excel should find all places a particular cell is referenced

In Office 2003, it would be nice if by highlighting a cell there was a
function that would allow a user to see all other places in the worksheet
where the cell is referenced. It could be similar to the way clicking on an
equation puts colored boxes around cells used in the equation.

Jules,

Select the cell, then press Ctrl-], (Select dependents) and Excel will
select all cells that reference the selected cell on the current sheet.

HTH,
Bernie
MS Excel MVP

"julesme1" <[email protected]> wrote in message
news:[email protected]...
> In Office 2003, it would be nice if by highlighting a cell there was a
> function that would allow a user to see all other places in the worksheet
> where the cell is referenced. It could be similar to the way clicking on
an
> equation puts colored boxes around cells used in the equation.

Aaron Blood has a free Excel add-in on his website that
may interest you:

http://www.xl-logic.com/pages/explode.html

Look for "explode.zip".

HTH
Jason
Atlanta, GA

>-----Original Message-----
>In Office 2003, it would be nice if by highlighting a
cell there was a
>function that would allow a user to see all other places
in the worksheet
>where the cell is referenced. It could be similar to
the way clicking on an
>equation puts colored boxes around cells used in the
equation.
>.
>