Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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.

Adding a ScreenTip

by Allen Wyatt
(last updated October 10, 2016)

4

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:
  1. Press Ctrl+K. Excel displays the Insert Hyperlink dialog box. (If you don't want to use the shortcut key for some reason, you can display the Insert tab of the ribbon and click the Hyperlink tool in the Links group.)
  2. Click on the ScreenTip button. Excel displays the Set Hyperlink ScreenTip dialog box. (See Figure 1.)
  3. Figure 1. The Set Hyperlink ScreenTip dialog box.

  4. In the ScreenTip Text box, enter the text you want to use for your ScreenTip.
  5. Click on OK to close the dialog box.
  6. Set any other hyperlink values, as desired.
  7. When completed, click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8348) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Adding a ScreenTip.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Removing Hyperlinks without a Macro

If you have a whole slew of hyperlinks in a worksheet and you want to get rid of them, it's easier than you think. This ...

Discover More

Links to Hyperlinks

Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a ...

Discover More

Controlling How Body Text is Displayed

When working in Outline view, you can control how Word displays the body text under each heading. You can specify that only ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (ribbon)

Adding Excel Information to a Web Page

Besides saving a worksheet as a complete Web page, you can also save smaller portions of your data to an existing Web page. ...

Discover More

Opening Sites in a Browser

You can store all sorts of information in a worksheet, including Web addresses. If you want to open those addresses in a ...

Discover More

Special Characters In Hyperlinks

Do you use special characters (such as the pound sign) in your worksheet names? If so, you could run into problems creating ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine minus 5?

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?


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.