Hyperlink Text in Cell

[Guest]

I thought this would be pretty straight forward but I guess I was wrong. I
want to create a hyperlink to a web site within a cell. But, I have a large
amount of text in the cell and I don't want the whole cell hyperlinked - just
the one word.

Can this be done?

 

[JE McGimpsey]

Not directly. I've faked it by formatting the word(s) as a hyperlink and
placing a borderless transparent textbox with the hyperlink over the
words (set to move and size with cells).

 

[Guest]

thanks. you would think there would be an easier way to handle this.

 

[JE McGimpsey]

you would think there would be an easier way to handle this.

No, I wouldn't. Hyperlinks are a relatively new add-on to a relatively
old object structure.

I rarely, if ever, find the need to use hyperlinks in my XL
applications, though some clients request them.

 

[Guest]

you must work at microsoft.

No, I wouldn't. Hyperlinks are a relatively new add-on to a relatively
old object structure.

I rarely, if ever, find the need to use hyperlinks in my XL
applications, though some clients request them.

 

[JE McGimpsey]

you must work at microsoft.

Nope - never have, likely never will.

If I worked for MS, I'd probably use hyperlinks all over the place. Eye
candy and marginal features seem to take precedence there over actually
doing things efficiently.