Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

multiple Hyperlinks one Excel cell?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jody - 20 May 2008 19:45 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.