After Hours

Ask something
Question Locked

Excel 2003 Hyperlink Issue

0 helpful
6 replies

by mhaggerty

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to hyperlink a single work in a sentence that is all within one cell. So far, I'm only able to link to the entire cell/sentence. Example: Can techrepublic answer this question? With techrepublic underlined/highlighted as the hyperlink. All within a single cell. Any ideas?

6 replies

by fwang

I don't think you can make partial of the cell as a link. Once you put a link in any part of the cell, the whole cell becomes a link.

For example:
="AAA" & HYPERLINK("D:\FINANCE\1stqtr.xls", "BBB") & "CCC"

you will see AAABBBCCC as one link.

by frotterus

I don't see any posts to answer your question. Were you able to find the solution elsewhere? I've been attempting to do the same thing. So far, I've not had any success.

by sarijit

This is probably not possible. Only way out could be, replacing the hyperlinked text with an equivalent image & then link that image instead. This way you will be able to preserve selective hyperlink (& not the entire cell).

If anyone has a better approach, will love to learn.

by lb1947

I had a similar issue with Excel 2003, and worked around it by judicious formatting of the Excel cell intended to hold the hyperlink and combining it with a Textbox (see the Drawing toolbar) containing the word I wanted to be the hyperlink. For example, if you wanted the word "going" to be the hyperlinked word in the sentence "What is going on?", enter into the cell the text
What is______on? (Underline represents blank spaces.)
Then create a textbox formatted to have the same font and font size as that of the cell, and to have 0 (zero) margins all around it. Set the textbox's 'Line' and 'Fill' characteristics to "None", then type into it the word "going". Next activate the Drawing toolbar's Object Selection cursor (the Arrow), and using it, right click on the textbox. (Note: When you get near a border of the textbox, the cursor will change to what looks like an enlarged 'plus' sign with an arrowhead at the end of each arm.) Upon right clicking on the textbox, select 'Hyperlink' from the menu that appears, and set your hyperlink parameters. Once the textbox is a working hyperlink, again activate the Object Selection tool and use it to position the textbox with the hyperlinked word in it (in my example, the word would be 'going') into the spaces intentionally left in the text (What is_____on?) of the spreadsheet cell. The end result should appear as what you want. If the cell you put the textbox in might change position (get larger because more text was added or shift position because changes in the size and/or position of other cells of the spreadsheet affected its position), you can take further steps to lock the textbox's position to the associated text in the cell.

I hope this helps.

This discussion is closed to new replies.