Does this shortcut exist? Jump to precedent/dependent cell on another sheet

[the_arcadian]

Hey Mr Excel users,

I'm looking for a shortcut that allows me to jump to dependent or precedent cells on other sheets. I know you can do it within the same sheet, but hate having to manually click that arrow that pops up when the cell being traced has a dependent / precedent on another sheet.

Thanks!

 

[Toadstool]

Are you saying Ctrl-[ and Ctrl-] don't jump sheets for you?

 

[the_arcadian]

Are you saying Ctrl-[ and Ctrl-] don't jump sheets for you?

Nope. Doesn't happen -- I get a "No cells were found" message.

 

[mikerickson]

This would have to be VBA.
Most formulas have multiple precedent/dependent cells. e.g. =Sheet1!$A$1 + Sheet2!$B$2

I'm envisioning a setup where the user selects a cell, presses ether ShowPrecedents or ShowDependents, presses a key combination and is taken to the first precedent cell, (Sheet1!A1 in the example)

If they press the key-combo again, do you want them to be taken to the second precedent of the original cell or do you want them to go to the precedent of the (possible) formula that is in Sheet1!A1?

 

[Peter_SSs]

Nope. Doesn't happen -- I get a "No cells were found" message.

Ctrl+[ works to jump sheets or even workbooks for me. (To the first precedent cell/range)
What Excel version & what operating system are you using?