Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Excel 2010 and I have a simple problem where I need to hyperlink a certain part of my text. My cell content is as simple as "For blablabla, click here." I want to add a hyperlink to the "here".

Does anyone know how can I do this?

share|improve this question

migrated from May 24 '12 at 9:55

This question came from our site for professional and enthusiast programmers.

Questions on this site are expected to relate to programming: You should take the time to read the faq – annonymously Jan 24 '12 at 13:03
Actually, you can't. The link gets applied to the whole cell (even with a formula using HYPERLINK). You could try to embed an object in the cell but that would probably be overkill. – JMax Jan 24 '12 at 13:32
ok, thank you!! – user1045602 Jan 24 '12 at 14:45

I think Excel does not allow creating hyperlinks on only part of the text in a cell. The hyperlink can only be set on the complete cell.

But there is something you can do. You can make "here" look like hyperlink and the rest of the text look normal.

How to do it? Just get into the cell in edit mode (Press F2), select the text "For blabla.."; remove its underline and change the color to black.

This way you will have a visual feel of just "here" being a hyperlink but the other text will remain "clickable"! :)

Hope this helps!

share|improve this answer
Did not work for me, when I pressed enter to leave the cell, Excel made the whole content a link again. – Mixxiphoid Dec 9 '14 at 14:42

Hyperlink the entire cell, then reformat the part of the text that you don't want hyperlinked. That way it will appear that only "here" is hyperlinked.

share|improve this answer

I've had this problem too, and what I did was just add columns before and after the hyperlink and made them appear to be one cell.

share|improve this answer

Here is the hyperlink formula example:

=HYPERLINK(" report.xlsx", "Click for report")

And a screenshot:

Excel Screenshot for adding a Hyperlink

share|improve this answer
Answer updated for StackExchange purposes. @Ramhound – Keeya Wang-Jones Apr 25 at 18:10

You must log in to answer this question.