Hyperlink in cell with line breaks
 

When you have a cell with few link breaks in it, is it possible to
hyperlink only one line?

For example, if a cell had these contents

LINE ONE
LINE TWO
HYPERLINK THIS TEXT ONLY

How do I hyperlink the last line only?

Hyperlink in cell with line breaks
 

Not sure you can. In your example it would be better to format that cell
into three columns and reserve the third column for the hyperlink


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562488

Hyperlink in cell with line breaks
 

Thanks for the reply... seems like this should be possible....
Special-K wrote:
Not sure you can. In your example it would be better to format that cell
into three columns and reserve the third column for the hyperlink


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562488

Hyperlink in cell with line breaks
 

The cell gets the hyperlink--not the text in the cell.

But you could cheat.

You could put a rectangle over the last line (hide the borders) and then assign
the hyperlink to that rectangle.

You could even format that bottom line to make it look like a hyperlink.

wrote:

Thanks for the reply... seems like this should be possible....
Special-K wrote:
Not sure you can. In your example it would be better to format that cell
into three columns and reserve the third column for the hyperlink


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562488

--

Dave Peterson

Hyperlink in cell with line breaks
 

The rectangle can be found on the Drawing toolbar.

Dave Peterson wrote:

The cell gets the hyperlink--not the text in the cell.

But you could cheat.

You could put a rectangle over the last line (hide the borders) and then assign
the hyperlink to that rectangle.

You could even format that bottom line to make it look like a hyperlink.

wrote:

Thanks for the reply... seems like this should be possible....
Special-K wrote:
Not sure you can. In your example it would be better to format that cell
into three columns and reserve the third column for the hyperlink


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562488

--

Dave Peterson

--

Dave Peterson