Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
double click on cell that have link, Excel will jump to the refere
I would like to know how can I doulble click on cell that have link, Excel
will automatically jump to the tab that is connect to the link. e.g tab "summary" cell A2 = 40 (this number is link from a tab call "data 1" cell B10), when one double click on A2 it will automatically jump to the tab "data 1 cell B10 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
double click on cell that have link, Excel will jump to the refere
ToolsOptionsEdit. Uncheck "edit directly in cell".
Double-click A2 to jump to data1 B10 Gord Dibben MS Excel MVP On Sun, 8 Jun 2008 10:44:01 -0700, RW wrote: I would like to know how can I doulble click on cell that have link, Excel will automatically jump to the tab that is connect to the link. e.g tab "summary" cell A2 = 40 (this number is link from a tab call "data 1" cell B10), when one double click on A2 it will automatically jump to the tab "data 1 cell B10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list of items click on it and have excel jump there | Excel Worksheet Functions | |||
Double Click Cell with link should take you directly to source | Excel Discussion (Misc queries) | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Double click in a Cell | Excel Discussion (Misc queries) |