Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I track how often a cell is being referenced?
I have a very large SS with multiple worksheets. I need to make some changes
but don't want to effect Macros or other formulas. If A1 has a value of 2 and B1 has a value of 3 and C1 has a formula of A1+B1 Is there a function or command I can use on A1 that will show me that it is included in a formula in C1? |
#2
|
|||
|
|||
If you'll click View Toolbars and check "Formula Auditing" a toolbar
appears; in your scenario, with the cell pointer on cell A1, click Trace Dependents and a line will point to cell C1. This is a one-at-a-time approach, though; how many times will you need to do this? |
#3
|
|||
|
|||
"Dave O" wrote: If you'll click View Toolbars and check "Formula Auditing" a toolbar appears; in your scenario, with the cell pointer on cell A1, click Trace Dependents and a line will point to cell C1. This is a one-at-a-time approach, though; how many times will you need to do this? THANK YOU! I knew there had to be something. Don't know how I overlooked it. There is about 50 cells I have to check, but this will make it much easier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab name / reference cell? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |