hyperlink in middle of paragraph

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I am trying to create a hyperlink in the middle of a text
paragraph in an excel cell. I know I can make the entire
cell a hyperlink, but can figure out how to have just part
of the text in a cell be a hyperlink. I even tried
creating the paragraph in word and copying and pasting,
but no luck. Anyone know if it's possible?

Thanks,
Mike
 
I don't believe it is possible, you probably have to try a workaround and
use several cells for the text
Like if A2 holds some text, B2 the hyper link and C2 the rest of the text.
 
Hyperlink objects are a properties of the range, not the text, so
you can't have the hyperlink apply to only part of the text.

If you're just interested in appearance, however, you can format the
cell with the hyperlink with default color and underlining, then
apply character formatting to the word(s) you want (e.g., blue,
underlined).
 
How important is it to you?

But maybe you could put a rectangle over the cell. Then assign a hyperlink to
it.

If you make the rectangle (found on the drawing toolbar) transparent with no
line, it might even look ok.

right click|format autoshape|colors and lines tab
100% transparency
Line|Color|None

right click again and assign it a hyperlink.

And then format the URL inside the cell so that it looks like a hyperlink.
 
Back
Top