View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hyperlink a word

Hyperlinks (=hyperlink() or insert|hyperlink) will apply to the whole cell.

But you could cheat.

Add a rectangle over the word in the cell. Hide its borders. Assign a
hyperlink to that hidden rectangle.

If you enter the string in the cell as text (not a formula), you could even
format the characters under the rectangle so that it looks like a hyerlink
(blue, underlined).

But if you enter a formula (or numbers), then you can't do this kind of
character by character formatting.

James wrote:

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks


--

Dave Peterson