| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick view of Cell References??
Sorry, saw your second post after I replied with the Trace Dependents answer.
Another possibility is to use Find All (in the Find dialog box). This isn't perfect, since you have to know whether to include absolute references or not, but it may get you started. Unfortunately, I don't know of any information function that would do what you want. There may be a VBA solution. -- ERR229 "Mariano" wrote: Is there a way to get a quick view of all the cells that have a formula that reference a particular cell? For example- If Sheet2!B3 is being used in 10 different formulas in 10 different cells, can I see that without manually checking? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas within Cell References | Excel Discussion (Misc queries) | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| Changing cell references automatically | New Users to Excel | |||
| Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Threaded Mode
