Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
I want to copy cell from word that includes line breaks to excel | Excel Discussion (Misc queries) | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
Copy hyperlink from one cell to/as hyperlink in another cell | Excel Worksheet Functions | |||
Hyperlink a word within a cell | Excel Discussion (Misc queries) |