find all formulas that a given cell is in

[Takeadoe]

Hi NG members,

I've dredged up some old work and I can't remember where and how a
given cell is used in my spreadsheet formulas. Is there a way to find
all instances where say cell F32 is part of a formula in another cell?


Any help on this would be greatly appreciated.

Mike

 

[Ryan.Chowdhury]

When you're in cell F32, click:

Tools > Formula Auditing > Trace Dependents

 

[Niek Otten]

Hi Mike,

- Edit>Goto>Special, check Precedents
- Look for the "Trace precedents" button, which will mark precedents with arrows (View>Toolbars, Formaula auditing)


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi NG members,
|
| I've dredged up some old work and I can't remember where and how a
| given cell is used in my spreadsheet formulas. Is there a way to find
| all instances where say cell F32 is part of a formula in another cell?
|
|
| Any help on this would be greatly appreciated.
|
| Mike
|

 

[Takeadoe]

Sorry for the delay in getting back to you. Thank you for taking the
time to help. I appreciate it.

Mike

 

[Takeadoe]

Sorry for the delay in getting back to you. Thank you for taking the
time to help. I appreciate it.

Mike