Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 27th 05, 11:29 PM
Rosalie
 
Posts: n/a
Default How do I add a hyperlink to an individual word in an Excel cell?

I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.

Any ideas? I can manage some VBA too if necessary.

Thanks,

Rosalie

  #2   Report Post  
Old September 28th 05, 12:00 AM
David McRitchie
 
Posts: n/a
Default

Hi Rosalie,

You can't do that in Excel.

You would have to use HTML or Word or some other means.

You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another cell
and use the copy format button to remove the underscoring
on the formula bar for the portion you don't want it, and change
the color to black with the paint bucket also on the formula bar
for the part you don't want to look like a formula..

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rosalie" wrote in message ...
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.

Any ideas? I can manage some VBA too if necessary.

Thanks,

Rosalie



  #3   Report Post  
Old September 28th 05, 04:09 AM
Dave Peterson
 
Posts: n/a
Default

Another way to do fake it is to add a rectangle that covers the word. (Hide the
borders, but assign the link to that rectangle.)

And format the word nicely like David McRitchie wrote.

(You could even put multiple rectangles over different words so that it looks
like the cell has multiple links.)



Rosalie wrote:

I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.

Any ideas? I can manage some VBA too if necessary.

Thanks,

Rosalie


--

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
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file DCheslock Excel Discussion (Misc queries) 1 May 5th 05 10:46 PM
hyperlink in Excel to Word doc closes Excel doc Hyperlinks close Excel Document Excel Discussion (Misc queries) 2 March 17th 05 03:13 AM
Hyperlink a word within a cell kchambers Excel Discussion (Misc queries) 2 March 9th 05 04:29 PM
Hyperlink to a word document JS Excel Discussion (Misc queries) 1 December 10th 04 11:49 PM
Hyperlink to word document problem JS Links and Linking in Excel 0 December 8th 04 11:54 PM


All times are GMT +1. The time now is 08:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017