Text Display Hovering to Hyperlink Cell

Is it possible to show custom information regarding the Hyperlink placed at any cell on a worksheet? Yes, it’s possible with a Screen Tip in Hyperlink editor.

In this article, you are going to learn about how to Display text as you click on Hyperlink in Excel to navigate one workbook to another. But for this, you should first know how to insert HYPERLINK using the Excel function.

To show the text as you hover the link

    •  Click on a Hyperlink under Insert Tab
    • Edit Hyperlink box appears on this click on ScreenTip….
    • In Hyperlink Screen Tip box type the text to appear as you hover
    • Click OK after filling in text
    • Click again OK Edit Hyperlink box

Download Your Example Excel File

Inserting text number format in cell
Click Screen Tip to show Text .

Here we select cells D2 and E2 to show information by just clicking on the link 2010 sales and 2011 sales respectively.