ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Multiple Hyperlink inside the Text boxt? (https://www.excelbanter.com/new-users-excel/125056-multiple-hyperlink-inside-text-boxt.html)

Anand vijay

Multiple Hyperlink inside the Text boxt?
 
How do I create multipal hyperlink inside the text box.

Mike

Multiple Hyperlink inside the Text boxt?
 
You can't but there is a workaround.

In Word create you list of keywords and assign a hyperlink to each word in
your list.
Select all the words in you list and copy them ctrl+c
In excel select paste special and then Microsoft word document object and OK.
You now have the object embedded and you can re-size as necessary.
Double click the object and then ctrl + click to follow and of the links you
created.

In truth is a lot easier to ceate links directly in Excel with 1 link per
cell.

Mike

"Anand vijay" wrote:

How do I create multipal hyperlink inside the text box.


Epinn

Multiple Hyperlink inside the Text boxt?
 
In truth is a lot easier to create links directly in Excel with 1 link per
cell. <<

I agree. The only way I can think of (within Excel) is:

1. Create a rectangle (A), insert hyperlink, add text.
2. Create another rectangle (B), insert hyperlink, add text. B should be smaller in size than A.
3. Drag B into A.
4. Format AutoShape of B to remove the lines of the rectangle.

Now, you have two hyperlinks in a rectangle (A). Don't think we can insert hyperlink to a textbox in Excel although it is okay to do so in PowerPoint.

Epinn

"Mike" wrote in message ...
You can't but there is a workaround.

In Word create you list of keywords and assign a hyperlink to each word in
your list.
Select all the words in you list and copy them ctrl+c
In excel select paste special and then Microsoft word document object and OK.
You now have the object embedded and you can re-size as necessary.
Double click the object and then ctrl + click to follow and of the links you
created.

In truth is a lot easier to ceate links directly in Excel with 1 link per
cell.

Mike

"Anand vijay" wrote:

How do I create multipal hyperlink inside the text box.




All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com