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@gmail.com]

When you're in cell F32, click:

Tools > Formula Auditing > Trace Dependents


Takeadoe wrote:
> 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

[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


"Takeadoe" <mtonkovich@msn.com> wrote in message news:1156081279.456671.30390@i42g2000cwa.googlegroups.com...
| 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
|