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)


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. ...


Helpful Pop-up Screen Tips

Screen tips can be helpful to people reading your document on-screen. Using the technique described here, you can add ...

Discover More

Subtotals Option Grayed Out

The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. If the ...

Discover More

Creating a String

Need to use a macro to create a text string? One easy way to do it is to use the String function, described in this tip.

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

Hyperlinks No Longer Work in a Workbook

Hyperlinks can be a great timesaver and very convenient. Unless, of course, if they don't work as you expect. This tip ...

Discover More

Hyperlinks in Shared Workbooks

Inserting a hyperlink into a workbook that is shared with others is not possible in Excel. Here's what you can do about it.

Discover More

Opening an HTML Page in a Macro

Excel allows you to open HTML pages within the program, which is great for some purposes. What if you want to open a ...

Discover More

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

View most recent newsletter.


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. Maximum image size is 6Mpixels. 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 one more than 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



I am looking to do something similar did you have any luck finding a solution?


2014-09-21 17:37:44


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

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.