C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » General »

Want multiple hyperlink in a cell ??????? (Excel)


Posted Date: 28 Oct 2009      Posted By: Girish Chaudhari      Member Level: Silver     Points: 1   Responses: 1



Hi to All,

I have a column1 named test. there are multiple test for a paricular test in column1. I want to select test for the column1 test in dropdown for column2 & for the selected value I want a particular hyperlink so as to open web page of the test page.

Is there is any way to hold hyperlink collection in a cell??? Is there is any other option to do this functionality????

Regards,
Girish



Responses
Author: Munish    29 Oct 2009Member Level: BronzeRating: 2 out of 52 out of 5     Points: 2

Directly giving different hyperlinks to different words in one column
is not possible in excel, at least in the versions so far.

However, there is a workaround. For that:
1.Type the different words in word document separated by comma or space(or any character u like).
2.Hyperlink them individually(shortcut - Ctrl+K).
3.Open Excel sheet. EDIT -> PASTE SPECIAL.
4.Double click on the cell to embed.

Hope it helps!!

------------------------------------------------------------------
Munish Chauhan
"Simplicity is the ultimate sophistication"
http://munishchauhan.com


Post Reply
You must Sign In to post a response.
Next : Google Adsense Revenue
Previous : General question
Return to Discussion Forum
Post New Message
Category: General

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use