Hyperlinking specific text in a cell (not the entire cell)

[pjl]

Dear All,

In MS Excel 2007, I have several cells that contain a paragraph of text; however, I do not want to hyperlink the entire cells' contents to point to a URL but, rather, just one or two words within the cell (similar to what you might see in MS Word). Is there a way to do this?

Thanks in advance,
PJL

 

[Gary McMaster]

You can only have one hyperlink in a cell. There are ways to cheat but it can be a ton of work and a real pain.

Here's one hack:

Draw a rectangle (auto shape) over the word or phrase. Set the rectangle's Fill Color to "No Fill", set the Line Color to "No Line". This makes the rectangle invisible. Right click on the rectangle and set its hyperlink as desired. You'll probably also want to make sure the rectangle moves with the cell.

If desired you can change the color / underline etc of the individual word underneath the rectangle to look like a hyperlink.

You will probably have to use some VBA code in the "Follow Hyperlink" event if you want to make the text change color after a given link has been followed.

Hope this helps.

Gary