Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Tracing
When one cell is the product of a number of other cells (ie. sum), when I hit
F2 I can trace all the cells that are included as part of the formula. However this only works if all the cells are on the same tab and not included across other tabs. Is it possible to have cells included as part of the formula highlighted when I go to those tabs as well. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Tracing
\
try using the formula auditing toolbar and hitting trace precendents its under view - toolbars - formula auditing On Jul 4, 9:46*am, Wicad wrote: When one cell is the product of a number of other cells (ie. sum), when I hit F2 I can trace all the cells that are included as part of the formula. However this only works if all the cells are on the same tab and not included across other tabs. Is it possible to have cells included as part of the formula highlighted when I go to those tabs as well. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Tracing
take a look at "Trace Precedentes" on the formula auditing.
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Wicad" escreveu: When one cell is the product of a number of other cells (ie. sum), when I hit F2 I can trace all the cells that are included as part of the formula. However this only works if all the cells are on the same tab and not included across other tabs. Is it possible to have cells included as part of the formula highlighted when I go to those tabs as well. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fomula tracing | Links and Linking in Excel | |||
Looking for alphabet tracing | Excel Discussion (Misc queries) | |||
Tracing precedents | Excel Worksheet Functions | |||
Tracing dependents - Excel 2003 | Excel Discussion (Misc queries) | |||
Tracing Dependents | Excel Discussion (Misc queries) |