Create a function that brings precedents within a formula into view when the precedent cell is selected within the formula.
Macabacus offers this, but for some reason, the download is not working with Excel 2019. PLEASE create this functionality or just buy Macabacus. So much time is saved. All I needed to do with Macabacus is click on a long formula, and press the up and down keys to select a reference cell, and then like magic, I'm brough to that reference cell on a different tab, where I could do the same thing. It's very helpful for auditing. PLEASE ADD.