find all references to a particular cell

S

singlgl1

I have a large workbook with several sheets.Is there a built-in functio
to find and list all references to a particular cell within the entir
workbook? Thanks
 
D

Dave Peterson

Select your cell and click on Tools|formula auditing|trace dependents.

You'll see a dashed arrow pointing to a small worksheet icon if there is a
dependent cell on another worksheet.

You can double click on that arrow, you'll go directly to the dependent cell (if
there's only one on another worksheet) or you'll see a list of all the cells
that refer to your cell.
 
Top