ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add verbiage to a cell that has a hyperlink already (https://www.excelbanter.com/excel-discussion-misc-queries/67047-how-do-i-add-verbiage-cell-has-hyperlink-already.html)

bowlegged64

How do I add verbiage to a cell that has a hyperlink already
 
When you insert a hyperlink into a cell is there a way to add more verbiage
in addition to the hyperlink? I have not been successful in doing this.

agrimes75

How do I add verbiage to a cell that has a hyperlink already
 

Do you actually want more wording on the hyperlink itself, or are you
trying to have a hyperlink with alternate text associated to it?


--
agrimes75
------------------------------------------------------------------------
agrimes75's Profile: http://www.excelforum.com/member.php...o&userid=30790
View this thread: http://www.excelforum.com/showthread...hreadid=504464


SteveG

How do I add verbiage to a cell that has a hyperlink already
 

You can add text as part of the name and then re-format that part of the
hyperlink name to apear as regular text (i.e. no underline and black
font). Add the text that you want in the EditHyperlink. Then
highlight the area you want to appear as normal text in the formula
bar, right click on it and select format cells. You can then remove
the underline, blue font etc... just for the area you selected. It is
still part of the link though.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504464


bowlegged64

How do I add verbiage to a cell that has a hyperlink already
 
That would be correct. I wanted to have alternate text associated with the
link.

"agrimes75" wrote:


Do you actually want more wording on the hyperlink itself, or are you
trying to have a hyperlink with alternate text associated to it?


--
agrimes75
------------------------------------------------------------------------
agrimes75's Profile: http://www.excelforum.com/member.php...o&userid=30790
View this thread: http://www.excelforum.com/showthread...hreadid=504464




All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com