Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Auditing
I want to use the "Trace Dependents" when the dependent cell is in another tab.
When this happens a little mini square icon appears. But there does not appear to be any way of telling which tab or cells in the tab are dependent. Is there anyway to get this info? Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Auditing
Try double-clicking on the arrow which points to the mini square icon
The info will show in the "Go To" dialog which pops up. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff" wrote in message ... I want to use the "Trace Dependents" when the dependent cell is in another tab. When this happens a little mini square icon appears. But there does not appear to be any way of telling which tab or cells in the tab are dependent. Is there anyway to get this info? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
How do I activate the formula auditing toolbar | Excel Discussion (Misc queries) | |||
How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions |