Links in Excel 2000...need help

  • Thread starter Thread starter pd
  • Start date Start date
P

pd

Hi,

Would you happen to know how to switch the setting in
excel so that when I doubleclick on a cell with a link to
another tab (worksheet), it will take me to that tab and
specifically the cell referenced?

Thx,
 
Maybe you can use a worksheet formula.

David McRitchie has posted these formulas that he uses.

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)


===
but you meant like what happens when you double click on a cell with a formula
and you go to the referenced range.

Maybe you could use the "formula auditing" toolbar. Click on the trace
precedents icon. You'll see an arrow and a little worksheet icon.

Double click on the arrow pointing to that worksheet icon and you'll get the
"edit|goto" dialog.

You can pick your "offsheet" reference and go to it.
 
Back
Top