Issue with tracing dependents
EXCEL 15.30. I know one can use the Precedent tool to see what cells are used in the formula of a particular cell but the tool requires finding, activating, and turning off, not to mention the really annoying and completely unnecessary new feature of the message box that tells you that there is no dependent or precedent, thus requiring another mouse click to remove the message. In all previous versions of Excel, simply double clicking in a cell would highlight cells that are dependents. OK, this happens in 15.30 as well but the highlights disappear as soon as one starts scrolling. Sometimes or perhaps very often, the dependent cell might not be in the current view, thus requiring scrolling. But, as already said, this removes the highlight. Please fix.
Rick Lawrence commented
C'mon people. This is a pain in the you know what. Please fix this example of yet another overblown addition to what used to be a decent progrm but is now turning into a black hole of a time waster