Jumping To Precedents On Other Sheets

[FARAZ QURESHI]

Pressing Ctrl+Shift+{ enables u 2 jump precedent cells on the same sheet. Any
combination of keys (shortcut keys) or code so as to enable precedents on
other sheets as well?

 

[Shane Devenshire]

Hi,

Double-click the line going to the external sheet icon and then double-click
the reference in the Go To dialog box.

You may be able to use Ctrl+[ but there are limitations to this - for
example if you have references to cells on the same sheet and another sheet
it only goes the the active sheet. If there is more than one reference on
the external sheet it only selects one.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[FARAZ QURESHI]

Sorry Shane,

I know that mode already but it's the mouse that I hate 2 use. Can't you
devise a code to even make such a GoTo Dialogue Box on a shortcut?
--

Best Regards,
FARAZ A. QURESHI

Hi,

Double-click the line going to the external sheet icon and then double-click
the reference in the Go To dialog box.

You may be able to use Ctrl+[ but there are limitations to this - for
example if you have references to cells on the same sheet and another sheet
it only goes the the active sheet. If there is more than one reference on
the external sheet it only selects one.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

Pressing Ctrl+Shift+{ enables u 2 jump precedent cells on the same sheet. Any
combination of keys (shortcut keys) or code so as to enable precedents on
other sheets as well?