View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default Jumping To Precedents On Other Sheets

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


"Shane Devenshire" wrote:

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" wrote:

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?

--

Best Regards,
FARAZ A. QURESHI