Reverse track if value in a cell is used by a formula elsewhere

[solo9999]

Hi folks,

I am using Excel 2003. Looking for a way to find out whether some data I want to delete in a sheet is used by a formula somewhere else within the file. Is there a way to check that? In other words, I have the number 500 in A1, and I want to delete it, but I don't know whether it will impact a calculation on another sheet that involves that value in A1. I hope my explanation makes sense

Thanks!

 

[JoeMo]

Select the cell. Go to Tools/Formula Auditing/Trace Dependents.

 

[solo9999]

Select the cell. Go to Tools/Formula Auditing/Trace Dependents.

Thank you Joe. How can I find out which sheet it is referenced in though? It only shows a cell icon but no name / link.

 

[JoeMo]

double-click the arrow pointing from the cell to the icon and you will see a list of sheet names/cells that depend on your cell.

 

[solo9999]

Thank you!