Hyperlink

  • Thread starter Thread starter Joe M
  • Start date Start date
J

Joe M

I creating hyperlinks in cells from within the same
sheet. In the dialog box I type in the cell reference,
but the 'Text to display' field gets updated with 'Master!
A1c35' in this case the c35 is the cell I want to hyper
link from. So, back in the spreadsheet the following is
displayed 'Master!A1c35' instead of the contents of cell
c35. In some cases the dialog box for 'Text to display'
contains <<Selection in document>> and the correct
information is displayed in the cell. Is there a way to
change the setting in the 'Text to display'?
 
Change that Text to display box to:
=master!c35
(add the equal sign)

Sometimes it's easier to work with the =hyperlink() worksheet function, too:

=HYPERLINK("#Sheet2!C34",Sheet2!C34)
 
Thanks Dave, the equal sign did the trick. BTW, is there
a way to create 'mass hyperlinks'? What I mean is that I
have to repeat the same operation for numerous
rows/columns, basically the next row down or next column
over...
 
David McRitchie has posted these formulas that he uses. Maybe one will be what
you want:

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

(I bet the 2nd or 3rd will do it!)
 
Back
Top