Hyperlink in cell with line breaks

[bordsby]

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?

 

[Special-K]

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

 

[bordsby]

Thanks for the reply... seems like this should be possible....

 

[Dave Peterson]

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.

 

[Dave Peterson]

The rectangle can be found on the Drawing toolbar.