CODEWITHSUNDEEP
excelhyperlink
Mus
Mus

Reputation: 7530

Excel 2010 - Hyperlink Text Only & Not Entire Cell

Is there a way to add a hyperlink to text only and not the entire cell in Excel 2010?

I am only able to insert a hyperlink which affects the entire cell (even white space after the text), but I wish to have it so that a user can click on the non-hyperlinked section of the cell in order to select the cell without activating the hyperlink.

Is this possible (ideally without VB)?

Many thanks.

Upvotes: 14

Views: 75555

Answers (5)

SAL
SAL

Reputation: 115

An indent (Home → Alignment → Indent: 1) makes the entire cell a hyperlink.

Upvotes: 0

KEVIN PATRICK MCALPINE
KEVIN PATRICK MCALPINE

Reputation: 1

It's a very odd thing. If I link to a .doc or docx document, only the text is linked. If I link to a .txt document, the whole cell is a link. I think it's just an odd excel glitch.

Upvotes: -1

Ladislav Tóth
Ladislav Tóth

Reputation: 31

really, if you have wrap text turned on, the whole cell will act as a hyperlink. if you have wrap text turned off, only text will act as a hyperlink.

Upvotes: 3

Martin
Martin

Reputation: 61

I got over this by turning off the "wrap text" from the cell formatting.

Upvotes: 6

Dave
Dave

Reputation: 8461

I'm not sure.. I just wrote this, but it acts the same as adding a hyper reference (although you can still select the whitespace of a cell (after the text has finished) and it won't follow the link)

=CONCATENATE("This is your ", HYPERLINK("http://www.google.com","Google"), " link")

Just as a FYI, you can hold ALT key and click on a cell without it opening the URI

Upvotes: 4

Related Questions