Hyperlinking a piece of text in Excel
Hyperlinking a piece of text in Excel
Hyperlinking a piece of text in Excel
Re: Hyperlinking a piece of text in Excel
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!
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!