Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to have plain text and a hyperlink in the same cell. If so,
how does one accomplish it? Example: (plain text might be key words for us) teaching and learning (then a link to a web site) http://www.ncte.org/profdev/ Or does the content of the entire cell have to appear and become a hyperlink? Thanks. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I tried highlighting partial text in a cell and the Hyperlink button
became disabled. So it doesn't appear possible. Is there a reason you can't put your key words in one column and the hyperlink in an adjacent column? kec wrote: Is it possible to have plain text and a hyperlink in the same cell. If so, how does one accomplish it? Example: (plain text might be key words for us) teaching and learning (then a link to a web site) http://www.ncte.org/profdev/ Or does the content of the entire cell have to appear and become a hyperlink? Thanks. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Looks like it has to be an entire range (not partial) or a shape object.
-- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "kec" wrote: Is it possible to have plain text and a hyperlink in the same cell. If so, how does one accomplish it? Example: (plain text might be key words for us) teaching and learning (then a link to a web site) http://www.ncte.org/profdev/ Or does the content of the entire cell have to appear and become a hyperlink? Thanks. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could cheat.
You could add a rectangle over the portion of the cell (make the borders invisible) and assign a hyperlink to that rectangle. You could even format the text under the rectangle so that it looks like a hyperlink (blue, underline, smaller??). kec wrote: Is it possible to have plain text and a hyperlink in the same cell. If so, how does one accomplish it? Example: (plain text might be key words for us) teaching and learning (then a link to a web site) http://www.ncte.org/profdev/ Or does the content of the entire cell have to appear and become a hyperlink? Thanks. -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks!
"Dave Peterson" wrote: You could cheat. You could add a rectangle over the portion of the cell (make the borders invisible) and assign a hyperlink to that rectangle. You could even format the text under the rectangle so that it looks like a hyperlink (blue, underline, smaller??). kec wrote: Is it possible to have plain text and a hyperlink in the same cell. If so, how does one accomplish it? Example: (plain text might be key words for us) teaching and learning (then a link to a web site) http://www.ncte.org/profdev/ Or does the content of the entire cell have to appear and become a hyperlink? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Hyperlink to Plain Text | Excel Discussion (Misc queries) | |||
how do i create hyperlinks | Excel Worksheet Functions | |||
Hyperlinks | Excel Worksheet Functions | |||
Macro to convert hyperlinks to text | Excel Worksheet Functions | |||
Hyperlink from plain text. | Excel Discussion (Misc queries) |