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 SkipVought 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
0
0
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
111
ladyck3
ladyck3
Bijugate
  • Question
Excel update question
Replies
0
Views
97
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
128
combo
combo

Part and Inventory Search

Sponsor

Back
Top