creating a hyperlink inside a cell

[marko300]

I'm having trouble posting hyperlink inside an individual cell. I need to highlight some of the text within a cell and create a hyperlink to another folder. However, when i try to insert a hyperlink, the entire cell content is selected and becomes the link (not just the few lines of text i would like).

does anyone have a solution?

many thanks

 

[Peter_SSs]

I'm having trouble posting hyperlink inside an individual cell. I need to highlight some of the text within a cell and create a hyperlink to another folder. However, when i try to insert a hyperlink, the entire cell content is selected and becomes the link (not just the few lines of text i would like).

does anyone have a solution?

many thanks

Is the problem just that the extra text is blue and underlined?

If so, after you have everything in the cell and hyperlinked to where you want;
1. Select the cell (click and hold a second or two)
2. In the formula bar select the first text that you don't want blue/underlined.
3. Format|Cells...|Font|select colour and underline options|OK
4. Repeat if there is more text after the hyperlink text.

The whole cell/text would still act as a hyperlink, we have just changed the appearance. Sorry if that is not what you were wanting.

 

[marko300]

Hi Peter,

thanks for your help - it' certainly in the right direction. I'm not sure if it's possible to separate the hyperlink from the rest of the cell contents completely but i'll keep trying.

Many thanks for your advice.
Mark

 

[Peter_SSs]

Hi Peter,

thanks for your help - it' certainly in the right direction. I'm not sure if it's possible to separate the hyperlink from the rest of the cell contents completely but i'll keep trying.

Many thanks for your advice.
Mark

I could be wrong but I don't you can separate it. It is the whole cell that is hyperlinked to the destination, not just the text. eg if you make the cell much wider than all the text and hover over (or click) a blank part of the cell well away from any text, you will see that it still hyperlinks.