Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All,
I know how to tell which cells are used in the formula of the selected cell, but is there any way to tell if the selected cell is used in other formulas? TIA, Sammy |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know how to tell which cells are used in the formula of the selected
cell, but is there any way to tell if the selected cell is used in other formulas? One way: Tools Formula auditing Trace dependents |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Click TOOLS/FORMULA AUDITING and trace dependents
-- Kevin Backmann "sammy" wrote: Hi All, I know how to tell which cells are used in the formula of the selected cell, but is there any way to tell if the selected cell is used in other formulas? TIA, Sammy |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks to both of you, this is what i needed.
"Kevin B" wrote: Click TOOLS/FORMULA AUDITING and trace dependents -- Kevin Backmann "sammy" wrote: Hi All, I know how to tell which cells are used in the formula of the selected cell, but is there any way to tell if the selected cell is used in other formulas? TIA, Sammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 formulas 1 cell | Excel Discussion (Misc queries) | |||
CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |