Hyperlink to a cell

  • Thread starter Thread starter Andy B
  • Start date Start date
A

Andy B

Hi all

Is it possible to put a hyperlink in a cell, that references another cell?
In other words, I have text in a cell and I want to have a link in there (as
well as the text) like 'See here for further info' that, when clicked, will
take the user to the another cell.

Thanks all

Andy
 
try this on sheet1 where you modify the name of the xls
=HYPERLINK("[youractiveworkbook.xls]Sheet2!D3")
 
Thanks Don. Is it not possible, though, to have the link on just a couple of
words (eg 'See here') rather than the whole cell?

Andy.

Don Guillett said:
try this on sheet1 where you modify the name of the xls
=HYPERLINK("[youractiveworkbook.xls]Sheet2!D3")

--
Don Guillett
SalesAid Software
(e-mail address removed)
Andy B said:
Hi all

Is it possible to put a hyperlink in a cell, that references another cell?
In other words, I have text in a cell and I want to have a link in there (as
well as the text) like 'See here for further info' that, when clicked, will
take the user to the another cell.

Thanks all

Andy
Click to expand...
Click to expand...
 
Without an example I can ask you to look in HELP index for INDIRECT

--
Don Guillett
SalesAid Software
(e-mail address removed)
Andy B said:
Thanks Don. Is it not possible, though, to have the link on just a couple of
words (eg 'See here') rather than the whole cell?

Andy.

Don Guillett said:
try this on sheet1 where you modify the name of the xls
=HYPERLINK("[youractiveworkbook.xls]Sheet2!D3")

--
Don Guillett
SalesAid Software
(e-mail address removed)
Andy B said:
Hi all

Is it possible to put a hyperlink in a cell, that references another cell?
In other words, I have text in a cell and I want to have a link in
Click to expand...
there
(as
well as the text) like 'See here for further info' that, when clicked, will
take the user to the another cell.

Thanks all

Andy
Click to expand...
Click to expand...
Click to expand...
 
(From a previous post)

How important is it to you?

But maybe you could put a rectangle over the cell. Then assign a hyperlink to
it.

If you make the rectangle (found on the drawing toolbar) transparent with no
line, it might even look ok.

right click|format autoshape|colors and lines tab
100% transparency
Line|Color|None

right click again and assign it a hyperlink.

And then format the URL inside the cell so that it looks like a hyperlink.

---
ps. If you adjust the width/height of the rectangle when you're holding the
alt-key, the rectangle will snap-to the cell's border.



Andy said:
Thanks Don. Is it not possible, though, to have the link on just a couple of
words (eg 'See here') rather than the whole cell?

Andy.

Don Guillett said:
try this on sheet1 where you modify the name of the xls
=HYPERLINK("[youractiveworkbook.xls]Sheet2!D3")

--
Don Guillett
SalesAid Software
(e-mail address removed)
Andy B said:
Hi all

Is it possible to put a hyperlink in a cell, that references another cell?
In other words, I have text in a cell and I want to have a link in there (as
well as the text) like 'See here for further info' that, when clicked, will
take the user to the another cell.

Thanks all

Andy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top