Has "Numbers" added functionality to trace dependents and precedents in cells. In Excel you click in a cell. Then under (function menu, "Auditing") there is selectable commands..."trace dependents and trace precedents and arrows appear that you can follow to see what the dependent and precedent cells.
MacBook Air 13", macOS 10.15
Not a supported feature in Numbers.
Double-clicking a cell inNumbers opens the Formula Editor. When the Formula editor is active, all cells referred to in the formula are highlighted in colours matching the colour of the token containing the reference to that cell. No tracking to cells further upstream, and no tracking to any cells downstream is available.
You can Provide Numbers Feedback, using the menu item in the Numbers menu, to request this feature be added to later versions of Numbers.
Regards,
Barry
Not a supported feature in Numbers.
Double-clicking a cell inNumbers opens the Formula Editor. When the Formula editor is active, all cells referred to in the formula are highlighted in colours matching the colour of the token containing the reference to that cell. No tracking to cells further upstream, and no tracking to any cells downstream is available.
You can Provide Numbers Feedback, using the menu item in the Numbers menu, to request this feature be added to later versions of Numbers.
Regards,
Barry
No, Numbers doesn't have that Auditing functionality similar to Excel. One way is to trace dependents is to deliberately introduce an error and note which cells then also contain an error. It's also possible to use an AppleScript to trace dependents, but that's a lot of trouble. Don't know of an easy way to trace precedents.
Note that in Numbers typically one would use smaller special-purpose tables rather than a big expanse of cells as in Excel. Using smaller tables simplifies document design, with less debugging problems of the sort that would require tracing dependents and precedents.
SG
Trace Dependents and Precedents in cells
