How can I create multiple hyperlinks within a cell? For example, a cell
contains data with multiple hyperlinks which may need to be accessed
individually. I'm able to create an hyperlink within a cell to a specified
website but it will only take me to the website of the first hyperlink in the
cell. I need to get to others as well. I'm kinda new to worksheet functions.
You can't have multiple hyperlinks in a cell, so I don't know how you think
you entered three. The only think I know that you could do for one cell
is to create shapes assign a hyperlink to the shape an place it over a
portion of the cell.
The other thing that you can do is to create a hyperlink in each of three
cells and hide the borders between the cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;nursekaceyquot; gt; wrote in message ...
gt; How can I create multiple hyperlinks within a cell? For example, a cell
gt; contains data with multiple hyperlinks which may need to be accessed
gt; individually. I'm able to create an hyperlink within a cell to a specified
gt; website but it will only take me to the website of the first hyperlink in the
gt; cell. I need to get to others as well. I'm kinda new to worksheet functions.
contains data with multiple hyperlinks which may need to be accessed
individually. I'm able to create an hyperlink within a cell to a specified
website but it will only take me to the website of the first hyperlink in the
cell. I need to get to others as well. I'm kinda new to worksheet functions.
You can't have multiple hyperlinks in a cell, so I don't know how you think
you entered three. The only think I know that you could do for one cell
is to create shapes assign a hyperlink to the shape an place it over a
portion of the cell.
The other thing that you can do is to create a hyperlink in each of three
cells and hide the borders between the cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;nursekaceyquot; gt; wrote in message ...
gt; How can I create multiple hyperlinks within a cell? For example, a cell
gt; contains data with multiple hyperlinks which may need to be accessed
gt; individually. I'm able to create an hyperlink within a cell to a specified
gt; website but it will only take me to the website of the first hyperlink in the
gt; cell. I need to get to others as well. I'm kinda new to worksheet functions.
文章標籤
全站熱搜
