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.

Adding a ScreenTip

by Allen Wyatt
(last updated July 7, 2018)


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, 2013, and 2016. 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. ...


Ignoring Accented Characters in Searches

When writing in non-English languages, there can be many variations of accented characters that are used in a word. You ...

Discover More

Formatting Canadian Postal Codes

Postal codes in Canada consist of six characters, separated into two groups. This tip explains the format and then shows ...

Discover More

Referring to the Last Cell

It is not unusual to use worksheets to collect information over time. As you keep adding information to the worksheet, ...

Discover More

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!

More ExcelTips (ribbon)

Deleting a Hyperlink

Hyperlinks can be helpful in some worksheets but bothersome in others. Here's how to get rid of any hyperlinks you don't ...

Discover More

Specifying Default Hyperlink Text

When you insert into a cell a hyperlink that references a file on your system, the text displayed by default matches the ...

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

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 5 + 3?

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.