Customize Hyperlink hover-over - Super User most recent 30 from superuser.com 2019-06-20T15:36:15Z http://asianhospital.com/?id=feeds/question/1296838 http://www.creativecommons.org/licenses/by-sa/3.0/rdf http://asianhospital.com/?id=q/1296838 1 Customize Hyperlink hover-over SFun28 http://asianhospital.com/?id=users/71134 2018-02-21T01:34:55Z 2018-02-21T13:56:56Z <p>Excel generates some instruction text when you hover-over a hyperlink as such...</p> <p><a href="https://i.stack.imgur.com/om69w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/om69w.png" alt="enter image description here"></a></p> <p>Can I customize these instructions and set my own text (the "Click once to follow. Click and hold...")</p> http://asianhospital.com/?id=questions/1296838/-/1296840#1296840 2 Answer by Ian McGowan for Customize Hyperlink hover-over Ian McGowan http://asianhospital.com/?id=users/217518 2018-02-21T01:41:18Z 2018-02-21T01:41:18Z <p>Check out the HYPERLINK function in the help.</p> <pre><code>=HYPERLINK("www.google.com", "Link to google") </code></pre> <p><a href="https://i.stack.imgur.com/ALceU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ALceU.png" alt="enter image description here"></a></p> http://asianhospital.com/?id=questions/1296838/-/1296878#1296878 4 Answer by Rajesh S for Customize Hyperlink hover-over Rajesh S http://asianhospital.com/?id=users/711214 2018-02-21T04:59:59Z 2018-02-21T13:56:56Z <p>I can say there are two situations.</p> <ul> <li>Create Hyperlink by using the standard Excel Command <strong>Insert</strong>, <strong>Hyperlink</strong>.</li> <li>Use the built-in <strong>Hyperlink Function</strong>.</li> </ul> <p><em>When you use the <strong>Insert Hyperlink</strong> command all the parameters are available.</em> </p> <ul> <li>Address </li> <li>Text to Display</li> <li>Screen Tips</li> </ul> <p>While using the command you have the liberty to customize the Hyperlink. During hover the link, the text which appears is in fact the <strong>Screen Tip</strong> which can be any text of user's choice.</p> <p>Other is <strong>Text to Display</strong>, this replaces the Web Address and appears on the Sheet.</p> <p><strong>Other Advantage is</strong>, the Hyperlink can be modified in terms of Font, Size &amp; 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.</p> <p><strong>But when you use the built-in Hyperlink function</strong>, you can't add the Screen Tip. Here Formatting Hyperlink is available but user can't enjoy the Edit Hyperlink command sequence.</p>