Not traditionally. There are some workarounds though. Either code your own routine to do this, whic *may* look something like this ...
Sub showAllDependents()
Dim cel As Range, rng As Range
Set rng = Selection
For Each cel In rng
cel.ShowDependents
Next cel
End Sub
Sub showAllPrecedents()
Dim cel As Range, rng As Range
Set rng = Selection
For Each cel In rng
cel.ShowPrecedents
Next cel
End Sub
Sub showNoArrows()
ActiveSheet.ClearArrows
End Sub
Also, Aaron Blood has a great add-in for doing similar things, it's called Explode, and it's very much worth the download. It is a free add-in. Here is a link: http://www.xl-logic.com/pages/explode.html
Bookmarks