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 - 20 May 2008 20:15 GMT
No it isn't. What are you trying to accomplish?
What version of Excel? What operating system?

Signature
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Jody" <Jody@discussions.microsoft.com>
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 - 20 May 2008 20:25 GMT
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---

Signature
RyGuy
>
> No it isn't. What are you trying to accomplish?
> What version of Excel? What operating system?
Gary''s Student - 20 May 2008 21:29 GMT
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.

Signature
Gary''s Student - gsnu200787
> Is it possible to enter multiple links in one Excel cell? I am using the
> fuction string rather than the GUI interface.
>
> Thanks
Dave Peterson - 20 May 2008 23:35 GMT
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.
> Is it possible to enter multiple links in one Excel cell? I am using the
> fuction string rather than the GUI interface.
>
> Thanks

Signature
Dave Peterson