Hyperlink to a cell

[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

 

[Don Guillett]

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

 

[Andy B]

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.

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

--
Don Guillett
SalesAid Software
[email protected]

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

 

[Don Guillett]

Without an example I can ask you to look in HELP index for INDIRECT

--
Don Guillett
SalesAid Software
[email protected]

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.

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

--
Don Guillett
SalesAid Software
[email protected]

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

 

[Dave Peterson]

(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.

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.

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

--
Don Guillett
SalesAid Software
[email protected]

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