multiple Hyperlinks one Excel cell?
 

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

Thanks

multiple Hyperlinks one Excel cell?
 

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"
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

multiple Hyperlinks one Excel cell?
 

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---


--
RyGuy


"Jim Cone" wrote:


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"
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

multiple Hyperlinks one Excel cell?
 

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.
--
Gary''s Student - gsnu200787


"Jody" wrote:

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

Thanks

multiple Hyperlinks one Excel cell?
 

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.

Jody wrote:

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