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

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, 2013, 2016, 2019, and Excel in Office 365. 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

Working with Multiple Printers

Word does not keep printer information associated with documents. You can define a macro for each printer you use and put ...

Discover More

Limiting Scroll Area

If you need to limit the cells that are accessible by the user of a worksheet, VBA can come to the rescue. This doesn't ...

Discover More

Converting European Dates to US Dates

Those in Europe use a date format that is different than those in the US; this is not news. But what if you need to ...

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)

Sending Single Worksheets via E-mail

Got a single worksheet that you want to e-mail to someone, but don't want them to see the rest of the worksheets in the ...

Discover More

Extracting E-mail Addresses from Hyperlinks

If you have a list of hyperlinked e-mail addresses in a worksheet, you may want to extract the addresses from those ...

Discover More

Converting a Range of URLs to Hyperlinks

Converting a single URL into a hyperlink is easy. Converting hundreds or thousands can be much harder if you have to rely ...

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. 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 two more than 2?

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.