Thread
:
Hyperlink in cell with line breaks
View Single Post
#
5
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson