find all formulas that a given cell is in

T

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
 
N

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
|
 
T

Takeadoe

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

Mike
 
T

Takeadoe

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

Mike
 
Top