Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Hello all; the subject line really says it all.
I'm pretty sure at some point in the past I've seen text in a cell where there was a hyperlink in just PART of the cell... but I can't for the life of me figure out how to do that now. Any help would be MOST appreciated. Thanks! Jim |
#2
![]() |
|||
|
|||
![]()
Hi Jim,
Yes, you can definitely add a hyperlink to just one word in a cell in Excel. Here's how you can do it:
Now, when you click on the word that you turned into a hyperlink, it will take you to the Code:
URL
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
I fear you are mistaken.
Having inserted a hyperlink in a cell you can change the character formatting of all but one word to be black with no underlining so that it LOOKS like only the one word is the link - but you can't make only that word ACT as a link. You might be able to insert an object that looks like a cell and can contain rich text, including single hyperlinked words - but I have not found one that works in a quick search. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
You could cheat and add a rectangle over the word/phrase you want. Then hide
its borders and assign the hyperlink to that rectangle. You could even format those characters (if the value in that cell is not a formula) nicely. But it can be a pain if you re-edit the text and change the position of the characters. JaimeZX wrote: Hello all; the subject line really says it all. I'm pretty sure at some point in the past I've seen text in a cell where there was a hyperlink in just PART of the cell... but I can't for the life of me figure out how to do that now. Any help would be MOST appreciated. Thanks! Jim -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Copy all gents, thanks!
Jim "Dave Peterson" wrote: You could cheat and add a rectangle over the word/phrase you want. Then hide its borders and assign the hyperlink to that rectangle. You could even format those characters (if the value in that cell is not a formula) nicely. But it can be a pain if you re-edit the text and change the position of the characters. JaimeZX wrote: Hello all; the subject line really says it all. I'm pretty sure at some point in the past I've seen text in a cell where there was a hyperlink in just PART of the cell... but I can't for the life of me figure out how to do that now. Any help would be MOST appreciated. Thanks! Jim -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hyperlink cell to word in textbox | Excel Discussion (Misc queries) | |||
Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
How do I add a hyperlink to an individual word in an Excel cell? | Excel Discussion (Misc queries) | |||
Hyperlink ONE word in a cell ??? | Excel Worksheet Functions | |||
Hyperlink a word within a cell | Excel Discussion (Misc queries) |