Excel generates some instruction text when you hover-over a hyperlink as such...

enter image description here

Can I customize these instructions and set my own text (the "Click once to follow. Click and hold...")

  • Do you need a solution that works in all versions of Excel? If so, please remove the version-specific Excel tags as the generic microsoft-excel tag indicates you want a version agnostic solution. – Twisty Impersonator Feb 21 at 3:07
  • I do need a solution that works in all modern versions (2007+). Removed the version-specific tags. – SFun28 Feb 21 at 13:43
up vote 4 down vote accepted

I can say there are two situations.

  • Create Hyperlink by using the standard Excel Command Insert, Hyperlink.
  • Use the built-in Hyperlink Function.

When you use the Insert Hyperlink command all the parameters are available.

  • Address
  • Text to Display
  • Screen Tips

While using the command you have the liberty to customize the Hyperlink. During hover the link, the text which appears is in fact the Screen Tip which can be any text of user's choice.

Other is Text to Display, this replaces the Web Address and appears on the Sheet.

Other Advantage is, the Hyperlink can be modified in terms of Font, Size & Colour while select the Hyperlink and Right Click and hit Format Cell (Ver. 2010 or higher) or in older Versions Modify command can do all these.

But when you use the built-in Hyperlink function, you can't add the Screen Tip. Here Formatting Hyperlink is available but user can't enjoy the Edit Hyperlink command sequence.

Check out the HYPERLINK function in the help.

=HYPERLINK("www.google.com", "Link to google")

enter image description here

  • I'm sorry, I updated my post to clarify. I want to modify the "Click once to follow. Click and hold..." – SFun28 Feb 21 at 2:02
  • 1
    That's a bit more of a challenge. mrexcel.com/forum/excel-questions/… has some craziness with creating a dll from within the excel workbook. I don't recommend that ;-) – Ian McGowan Feb 21 at 2:12

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.