I'm looking at an existing spreadsheet someone else did, and I would
like to click on a cell, and then be able to see where that value is
used elsewhere in the sheet. Is there a way I can do this? Thanks.
(Excel 2003)
I'm looking at an existing spreadsheet someone else did, and I would
like to click on a cell, and then be able to see where that value is
used elsewhere in the sheet. Is there a way I can do this? Thanks.
(Excel 2003)
From the menus select View>Toolbars>Formula Auditing. Select the cell
you are interested in and then click on the Trace Dependents button on
the Formula Auditing toolbar.
Hope this helps
Rowan
termiflyer wrote:
> I'm looking at an existing spreadsheet someone else did, and I would
> like to click on a cell, and then be able to see where that value is
> used elsewhere in the sheet. Is there a way I can do this? Thanks.
> (Excel 2003)
>
Exactly what I was looking for. Thank you
Rowan Drummond wrote:
> From the menus select View>Toolbars>Formula Auditing. Select the cell
> you are interested in and then click on the Trace Dependents button on
> the Formula Auditing toolbar.
>
> Hope this helps
> Rowan
>
> termiflyer wrote:
> > I'm looking at an existing spreadsheet someone else did, and I would
> > like to click on a cell, and then be able to see where that value is
> > used elsewhere in the sheet. Is there a way I can do this? Thanks.
> > (Excel 2003)
> >
If you repeatedly click the same button it will lead you through any
additional dependents that rely on results from the original precedent cell.
No more arrows will appear once you reach the 'end of the line'.
Regards |:>)
"termiflyer" wrote:
> Exactly what I was looking for. Thank you
>
> Rowan Drummond wrote:
> > From the menus select View>Toolbars>Formula Auditing. Select the cell
> > you are interested in and then click on the Trace Dependents button on
> > the Formula Auditing toolbar.
> >
> > Hope this helps
> > Rowan
> >
> > termiflyer wrote:
> > > I'm looking at an existing spreadsheet someone else did, and I would
> > > like to click on a cell, and then be able to see where that value is
> > > used elsewhere in the sheet. Is there a way I can do this? Thanks.
> > > (Excel 2003)
> > >
>
>
You're welcome.
termiflyer wrote:
> Exactly what I was looking for. Thank you
>
> Rowan Drummond wrote:
>
>>From the menus select View>Toolbars>Formula Auditing. Select the cell
>>you are interested in and then click on the Trace Dependents button on
>>the Formula Auditing toolbar.
>>
>>Hope this helps
>>Rowan
>>
>>termiflyer wrote:
>>
>>>I'm looking at an existing spreadsheet someone else did, and I would
>>>like to click on a cell, and then be able to see where that value is
>>>used elsewhere in the sheet. Is there a way I can do this? Thanks.
>>>(Excel 2003)
>>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks