Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
kec
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
galimi
 
Posts: n/a
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
kec
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Hyperlink to Plain Text Sam Excel Discussion (Misc queries) 2 May 6th 06 12:47 AM
how do i create hyperlinks Gold9er Excel Worksheet Functions 1 April 6th 06 08:33 PM
Hyperlinks Emece Excel Worksheet Functions 1 December 19th 05 02:16 AM
Macro to convert hyperlinks to text Emece Excel Worksheet Functions 1 December 15th 05 02:16 PM
Hyperlink from plain text. B.C.Lioness Excel Discussion (Misc queries) 2 May 3rd 05 04:10 PM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"