Is this cell used in other formulas

's Computer Specifications

Hi All,

I know how to tell which cells are used in the formula of the selected cell,
but is there any way to tell if the selected cell is used in other formulas?

TIA,
Sammy

's Computer Specifications

> I know how to tell which cells are used in the formula of the selected
> cell, but is there any way to tell if the selected cell is used in
> other formulas?

One way:
Tools > Formula auditing > Trace dependents

's Computer Specifications

Click TOOLS/FORMULA AUDITING and trace dependents
--
Kevin Backmann

"sammy" wrote:

> Hi All,
>
> I know how to tell which cells are used in the formula of the selected cell,
> but is there any way to tell if the selected cell is used in other formulas?
>
> TIA,
> Sammy

's Computer Specifications

Thanks to both of you, this is what i needed.

"Kevin B" wrote:

> Click TOOLS/FORMULA AUDITING and trace dependents
> --
> Kevin Backmann
>
>
> "sammy" wrote:
>
> > Hi All,
> >
> > I know how to tell which cells are used in the formula of the selected cell,
> > but is there any way to tell if the selected cell is used in other formulas?
> >
> > TIA,
> > Sammy

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Two formulas in on cell based on two numbers in another cell?	Melody	Microsoft Excel Misc	5	19th Mar 2010 07:51 PM
Carrying formulas over to new cell when old cell is deleted: possi	Karl	Microsoft Excel Worksheet Functions	0	24th Jun 2008 01:10 PM
Copying formulas from cell to cell to cell to.......	Tom Hardy	Microsoft Excel Misc	3	15th Jun 2006 03:29 PM
change cell value greater than another cell value using formulas	=?Utf-8?B?VW5zdXJlPw==?=	Microsoft Excel Worksheet Functions	2	2nd Apr 2006 10:24 PM
Please help..activating array formulas in a range of cells without going cell by cell	Karenna	Microsoft Excel Worksheet Functions	3	1st Mar 2004 03:45 AM