multiple Hyperlinks one Excel cell?

[Jody]

Is it possible to enter multiple links in one Excel cell? I am using the
fuction string rather than the GUI interface.

Thanks

 

[Jim Cone]

No it isn't. What are you trying to accomplish?
What version of Excel? What operating system?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jody" <[email protected]>
wrote in message
Is it possible to enter multiple links in one Excel cell? I am using the
fuction string rather than the GUI interface.

Thanks

 

[ryguy7272]

You can hold down the alt key and press the Enter key, and the new link will
wrap down to the next line, but as far as I can telly, you will only be able
to access the first link, no matter which one you click on.

Regards,
Ryan---

 

[Gary''s Student]

Jim and Ryan are correct. You can get the effect as follows:

In B9 enter:
=HYPERLINK(B8,B8)
In B8 enter a Data Validation list that includes all the desired hyperlinks.


A similar trick works with VLOOKUP or other lookup functions.

 

[Dave Peterson]

You get one hyperlink per cell--either from the Insert|Hyperlink or from the
=hyperlink() worksheet function.

But you could cheat.

You could add multiple rectangles from the Drawing toolbar (hide the borders!)
and assign a different hyperlink to each of those rectangles.

But you can't use the =hyperlink() worksheet function to create the hyperlink
for the rectangles.