See where a cell is referenced

T

termiflyer

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)
 
R

Rowan Drummond

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
 
T

termiflyer

Exactly what I was looking for. Thank you :)

Rowan said:
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
Click to expand...
 
C

CyberTaz

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 |:>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External cell reference between two excel worksheets both in One Drive 0
Need Help with a VBA subroutine 0
Linking data in MS Word into Excel 5
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
VBA Coding Help for Beginner 0
Using checkbox to change cell color 2
Word macro that can call cells out of Excel for a find and replace 0

Top