View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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