Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find all references to a particular cell
I have a large workbook with several sheets.Is there a built-in function to find and list all references to a particular cell within the entire workbook? Thanks. -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=397503 |
#2
|
|||
|
|||
Select your cell and click on Tools|formula auditing|trace dependents.
You'll see a dashed arrow pointing to a small worksheet icon if there is a dependent cell on another worksheet. You can double click on that arrow, you'll go directly to the dependent cell (if there's only one on another worksheet) or you'll see a list of all the cells that refer to your cell. singlgl1 wrote: I have a large workbook with several sheets.Is there a built-in function to find and list all references to a particular cell within the entire workbook? Thanks. -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=397503 -- Dave Peterson |
#3
|
|||
|
|||
If you consider the 'Offset' function I would guess it's not possible. singlgl1 Wrote: I have a large workbook with several sheets.Is there a built-in function to find and list all references to a particular cell within the entire workbook? Thanks. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=397503 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Cell References and External Data | Excel Worksheet Functions | |||
fix cell references | Excel Discussion (Misc queries) | |||
Cell References in Functiona | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions |