Solved

make partial text in a cell as hyperlink

Posted on 2014-03-02
4
4,080 Views
Last Modified: 2016-09-15
hi,

I know how to make a cell into a hyperlink, is there a way to make partial text in a cell as hyperlink?  thx
0
Comment
Question by:mcrmg
  • 2
4 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 39899537
Hi mcrmg,

Step 1 Right click on hyperlink cell & select edit hyperlink.
Step 2 very first option on popup box "Text To display". Enter what ever you want to display instead of whole URL.
Step 3 ok & Done.


Thanks
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 39899880
No, it is not possible to add a hyperlink to only part of the cell content in Excel. It's all or nothing, I'm afraid.

Regards,
Rory
0
 

Expert Comment

by:P WD
ID: 41800634
Rory - not true.  I just did itjockey's suggestion and it worked for me.  Basically, what you end up putting in the "Text to Display" window, is the only text that will show in that window, so make it meaningful.  And put the link that you want it to go to, in the Link window in the bottom of that dialog box.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 41800637
That is not actually adding a hyperlink to part of the text. The whole text is still a hyperlink.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to line 23 54
assignment of laptops - risks 6 50
Excel formula - data format 5 22
How can I calculate a balloon payment in Excel? 5 14
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question