QuoUsqueTandem
New Member
- Joined
- Nov 9, 2017
- Messages
- 4
Hi all,
At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the original formula in turn with repeated presses of CTRL+N. With each press of the 'next' shortcut, the next precedent in the cycle would be selected and the screen would navigate to it. Pressing CTRL+G while one of the precedents was selected would end the cycle and start a new one, taking the user to the first precedent of that cell.
The tool worked even where certain of the precedents were on a different worksheet within the same workbook (reading through the previous posts regarding precedents, that seems to be a pertinent point), although it did not unhide/expand hidden or grouped rows. To get back to the original cell of the current cycle (i.e. the one containing the formula you were interrogating) you'd just press CTRL+N until all of the precedents had been visited and the next press of the shortcut took you back to it.
The tool saved so much time that the built-in precedent tool barely got used. I'm really missing it in my new role and wonder if anyone knows of a tool or has some code that does what I've described. If not, I'd like to cobble together an imitation so any help or advice would be really appreciated.
Cheers,
QUT
At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the original formula in turn with repeated presses of CTRL+N. With each press of the 'next' shortcut, the next precedent in the cycle would be selected and the screen would navigate to it. Pressing CTRL+G while one of the precedents was selected would end the cycle and start a new one, taking the user to the first precedent of that cell.
The tool worked even where certain of the precedents were on a different worksheet within the same workbook (reading through the previous posts regarding precedents, that seems to be a pertinent point), although it did not unhide/expand hidden or grouped rows. To get back to the original cell of the current cycle (i.e. the one containing the formula you were interrogating) you'd just press CTRL+N until all of the precedents had been visited and the next press of the shortcut took you back to it.
The tool saved so much time that the built-in precedent tool barely got used. I'm really missing it in my new role and wonder if anyone knows of a tool or has some code that does what I've described. If not, I'd like to cobble together an imitation so any help or advice would be really appreciated.
Cheers,
QUT