You could run this macro:

Sub ShowUsed()
Dim C As Range
For Each C In ActiveSheet.UsedRange.Cells
C.ShowDependents
Next
End Sub

To remove the arrows:
Tools Formula Auditing Remove All Arrows


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup