Fastest ways to trace formulas (especially when cells link to otherworksheets)

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Hello, I am finding it challenging to trace my formulas when they link
to other spreadsheets. It is a manual and tedious process, and I am
thinking that there has got to be a faster way than physically
searching for the cells to which the formulas are referring.

Does anyone know of a fast way to jump to precedents and dependents of
formulas. (I did notice the formula auditing toolbar, but it seems to
only work when you are trying to trace formulas in the SAME
worksheet).

Thanks for any suggestions.
 
For tracing across sheets, if you were to double-click on the dotted arrow
that points to/from the little spreadsheet icon, that'll bring up a "Go To"
dialog to navigate quickly to either the precedent(s) / dependent(s)
 
Ctrl+[

Pressing control+[ while on a formula will jump to the first cell or range
that the formula refers to. This can be particularly useful when the ranges
are external references as it will then open the workbook and jump to the
appropriate range.
 
For tracing across sheets, if you were to double-click on the dotted arrow
that points to/from the little spreadsheet icon, that'll bring up a "Go To"
dialog to navigate quickly to either the precedent(s) / dependent(s)
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik







- Show quoted text -
Click to expand...

Thanks! Incredibly helpful.
 
Back
Top