Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jumping To Precedents On Other Sheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jumping To Precedents On Other Sheets
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tracing precedents | Excel Worksheet Functions | |||
Precedents | Excel Discussion (Misc queries) | |||
Exact Precedents | Excel Worksheet Functions | |||
Tracing precedents | Excel Worksheet Functions | |||
Jumping Between Sheets! | Excel Discussion (Misc queries) |