Home |
Search |
Today's Posts |
#1
|
|||
|
|||
finding all references to a cell
How can I find all the references to a particular cell in a spreadsheet? I
tried using the find command but then it won't find absolute refernces unless you specifically code in the '$'. |
#2
|
|||
|
|||
Try using the Auditing Toolbar to Trace Dependents. Select the cell in
question, then click the Trace Dependents button as many times as necessary. You can also go the other way to Trace Precedents as well as some other options on that bar. HTH |:) "Brett" wrote: How can I find all the references to a particular cell in a spreadsheet? I tried using the find command but then it won't find absolute refernces unless you specifically code in the '$'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
Finding Cell References | Excel Discussion (Misc queries) | |||
Cell References in Functiona | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |