Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel cell reference 1

Status
Not open for further replies.
ahaboub

ahaboub

Technical User
Jul 31, 2009
41
LB
Anyone has an idea about how to know where a cell reference is used?
like i have a cell A1, i want a list of all cells that are using A1 as part of their functions.
Thanks.
 
Sort by date Sort by votes
You could use formula auditing. Show the formula auditing toolbar (right click a blank area of toolbar and select it) then select the cell and click the "trace dependents" button. Excel draws arrows to all the cells whose formulas depend on that cell (or shows an "off worksheet" symbol if the cell is on another sheet).

I don't know how to get a list as such, but the graphic generally sorts the problem.

Ian
 
Upvote 0 Downvote
splendid!

substitute: thank you for your detailed explanation.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
181
ladyck3
ladyck3
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
277
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
274
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
836
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
576
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top