Excel 2010 - Hyperlink Text Only & Not Entire Cell

Viewed 72680

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.

5 Answers

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

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.

Related