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 '$'.
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 '$'.
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 '$'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks