Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. As we will show trace dependent across sheets, we will need at least two worksheets. Next, choose the 'Special'. function onCatChange() { You can open the Pro Precedents dialog, navigate multiple levels of precedent cells, and close the dialog without ever using your mouse.