Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Adding a ScreenTip.
ScreenTips are a Web feature supported by the latest versions of Web browsers. They appear when your mouse pointer hovers over a hyperlink, and they are used in the same way that ToolTips are used in Excel. You can add a ScreenTip as you add a hyperlink by following these steps:
Figure 1. The Set Hyperlink ScreenTip dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8348) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Adding a ScreenTip.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Converting a single URL into a hyperlink is easy. Converting hundreds or thousands can be much harder if you have to rely ...
Discover MoreNeed to add a hyperlink to a comment? It's easy to do by following the steps outlined in this tip.
Discover MoreCreating a drop-down list with Excel's data validation feature can be a nice touch for a worksheet. What if you want the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-08-15 03:00:20
Alicia White
For a SAM project, I am to insert a hyperlink in cell B11, that I had no problem with. Then we are supposed to place in cell B13 a screen tip further explaining B11 hyperlink data. How do I do this?
It is as though I am to edit the hyperlink--then magically go down to Cell B13 and place the screen tip.
'
How do I do this?
2014-10-28 16:26:17
Bigger Don
@Mike and @BobWald
Two alternatives:
Comments & Data Validation Input Messages.
A Data Validation Input Message appears when the cell is selected and, unlike the ScreenTip for a Hyperlink, there is no need to add additional information that might not be otherwise need. The allowable length is about the same but you can also add a title to a Data Validation Input Messages. Data Validation Input Messages and hyperlinks ScreenTips are both limited to 256 characters.
Comments will appear when hovering over the cell.
Comments have longer max lengths (32K!) and the size can be programmatically manipulated (e.g. Range.Comment.Shape.Width), unlike Data Validation Input Messages and Hyperlink ScreenTips.
Last, comments are not a panacea. Manipulating the content programatically is not straight-forward.
2014-10-27 19:32:23
MikeM
Bob,
I am looking to do something similar did you have any luck finding a solution?
Thanks
Mike
2014-09-21 17:37:44
BobWald
I want to insert, in to a ScreenTip box, two paragraphs of text (~ 200 characters)that are currently in an excel text box. However, the tip window is too small to show all the text. With no scroll bars or ability to alter the window size I'm stuck. Is there some alternative way of sizing the tip window?
In the absence of resizing the tip window- Is there some way to linking the "Hover-cell" in a way that will display text box itself? - any help is appreciated p.s. It also looks like the tip text has eliminated the paragraphs marks - any way to fix this?
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments