ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hyperlinks and plain text in same cell? (https://www.excelbanter.com/excel-discussion-misc-queries/92647-hyperlinks-plain-text-same-cell.html)

kec

hyperlinks and plain text in same cell?
 
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.

Mark Lincoln

hyperlinks and plain text in same cell?
 
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.



galimi

hyperlinks and plain text in same cell?
 
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.


Dave Peterson

hyperlinks and plain text in same cell?
 
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

kec

hyperlinks and plain text in same cell?
 
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



All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com