Excel Text Hover: How to Show Notes and Tooltips on Cells

How-to basics · Updated November 18, 2026

Excel does not have a general setting that turns any cell’s text into a hover tooltip. In Excel for Microsoft 365 on Windows, the closest built-in option is a cell Note: add a Note to the cell, and its text appears when someone points to that cell. For a message shown when a cell is selected, use a data-validation input message instead.

What Excel Means by Text Hover

People asking about Excel text hover usually want extra information to appear when a pointer rests over a cell, without making the worksheet wider or adding another visible column. Excel can do this with Notes, the feature previously called legacy comments. A Note is attached to a cell and can contain explanatory text; it is not the same as the value displayed in the cell.

For example, a cell might show the short label Priority A, while its Note explains that the label means the request must be reviewed within one business day. The label remains visible in the grid, and the longer explanation appears when the user hovers over the cell or its Note indicator.

This is not a universal tooltip property. You cannot simply select a cell and type text into a special hover-text box that works for every kind of cell. Notes are the practical built-in choice for hover explanations, while other Excel features suit different triggers and purposes.

Show Text on Hover with a Note

To add a Note in Excel for Microsoft 365 on Windows, select the cell that should carry the extra explanation and use either the ribbon or the context menu:

  1. Select the cell.
  2. On the ribbon, choose Review > Notes > New Note. You can also right-click the cell and choose New Note.
  3. Type the explanation in the Note box. Keep it specific and concise so it is readable when displayed.
  4. Click outside the Note box to finish editing.

In many Windows installations, Shift+F2 opens or edits a Note for the selected cell. Laptop keyboards may require the Fn key as well. The keyboard shortcut for a Mac can vary with keyboard and Excel settings, so use the Review tab or the cell’s context menu if the shortcut does not work. Ribbon labels and placement can differ slightly between releases.

Excel marks a cell containing a Note with a small indicator in a corner. When a person points to the cell, Excel displays the Note. To keep it visible instead of waiting for a hover, right-click the cell and choose Show/Hide Note, or use the corresponding option under Review > Notes. The exact menu wording can vary slightly by release.

What the Reader Sees

A Note is a small text box associated with its cell. It can hold context, definitions, reminders, or instructions that would otherwise clutter the worksheet. It does not replace the cell’s content, change the value used in a calculation, or automatically appear as a column in a printed report.

Notes are useful for information that is helpful but not needed constantly. A product code can remain compact in the grid while its Note identifies the supplier; a column heading can have a Note explaining which date convention it uses; or an unusual number can have a Note describing its source. Include enough context that a colleague can understand the message without guessing which part of the workbook it refers to.

Hover behavior depends on the Note being present and not hidden. A reader may need to move the pointer over the cell itself, and touch-screen users cannot rely on a mouse hover. If the explanation is essential to completing a task, put it in a visible heading, nearby instruction, or data-validation input message as well. Do not make a critical warning available only through a hover.

Notes and Comments Are Different

Excel’s terminology causes a common misunderstanding. What many users call a comment bubble from older versions is now generally called a Note. Modern Comments are threaded conversations designed for collaboration: people can reply, mention colleagues, and resolve a discussion. They are not the same as a simple hover tooltip.

In current Microsoft 365 for Windows, a Note is the more direct choice when the goal is to show static explanatory text on hover. To add a modern comment, use Review > New Comment; readers generally open the comment through its cell indicator or the Comments pane rather than treating it as a plain hover label. If a workbook already contains old-style comments, Excel may offer options to convert them to Notes or modern comments. Check which type you are editing before changing a shared workbook.

Choose Notes for definitions or reference details that belong to a cell. Choose threaded Comments when people need to discuss, reply, or track a conversation. Adding a modern comment simply because its name sounds like the right place for a tooltip can lead to a different user experience than intended.

Other Ways to Display Supplemental Text

There are two useful alternatives, depending on what should trigger the message:

  • Data-validation input message: Select the cell or range, then go to Data > Data Validation. On the Input Message tab, enable the option to show an input message when the cell is selected, then enter a title and message. This appears when the user selects the cell, not merely when the pointer hovers over it. It is useful for instructions such as “Enter a date in YYYY-MM-DD format.”
  • Hyperlink ScreenTip: In desktop Excel, a hyperlink can display a ScreenTip when the pointer rests over it. Select the cell, press Ctrl+K on Windows to open the link dialog, and use its ScreenTip control to enter the tip text. A hyperlink is still a link: clicking it may navigate to a web page, file, or workbook location. This is not a general tooltip for ordinary cell text, and ScreenTip options may differ in Excel for the web.

These options solve different problems. A Note is attached to a cell and is suited to reference information. A validation message helps someone enter data correctly and appears on selection. A hyperlink ScreenTip provides extra context for an actual link. Pick the feature based on the event that should reveal the message, not just on the fact that all three can display extra text.

Choosing the Right Approach

Before adding hover text across a large workbook, consider who needs the information and how they use the file. Notes can help keep a worksheet visually tidy, but they are less discoverable than text that is always visible. A person who does not notice the indicator may never find the explanation. For essential instructions, use a clear column heading, a dedicated help sheet, or visible text beside the relevant cells.

Also consider how the workbook is shared. Notes are cell-level annotations, so they move with their cells when rows or columns are rearranged, but they can become outdated if the underlying process changes. Assign someone to review important Notes during workbook maintenance. If the message applies to a whole column, a header Note or an on-sheet instruction may be easier to maintain than dozens of repeated Notes.

Keep wording short and concrete. “Check source” is vague; “Use the signed invoice date, not the shipment date” tells the reader what to do. Avoid putting sensitive information in Notes on a workbook that may be shared or copied. A Note is not a security control, and hiding it does not protect its contents.

Version and Sharing Considerations

Excel for Microsoft 365 on Windows is the focus here, but Notes and modern Comments are available in other Excel editions with interface differences. On a Mac, look for the Note commands on the Review tab or in the cell’s context menu; the ribbon layout and keyboard shortcuts can differ. Excel for the web also has a different interface, so do not assume every desktop command or hyperlink ScreenTip behavior is identical in a browser.

When a workbook is opened in another edition or application, the display and editing experience can differ. If hover text is important to a workflow, test a copy in the actual environment used by recipients, including the web version or Mac version if relevant. For a workbook used on phones or tablets, provide essential information visibly because pointer hover may not be available.

Common Problems and Fixes

  • The Note does not appear: Confirm that the selected cell actually contains a Note, not a modern Comment. Look for the corner indicator, then use the Review tab or context menu to show the Note. Also check that it was not deleted or hidden.
  • The message appears only after clicking: You may have created a data-validation input message or a modern Comment. Input messages appear on selection; modern Comments are collaboration threads. Create a Note if the desired behavior is a cell annotation that appears on hover.
  • The Note stays on screen: It may have been set to remain visible. Use the cell’s Show/Hide Note command to toggle its display. A visible Note can be useful during editing, but it may cover nearby cells.
  • The Note blocks other content: Move or resize the Note box where the interface permits, shorten its wording, or show it only when needed. If readers need the information all the time, move it into visible worksheet text instead.
  • A colleague cannot find the information: Add a brief instruction such as “Hover over cells with a corner marker for definitions,” or make critical guidance visible. Do not assume every reader knows what the small indicator means.

Frequently Asked Questions

Can I make any cell’s text appear as a tooltip on hover?
No. Excel has no universal hover-text field for ordinary cells. Add a Note for hover-style explanatory text, or use a hyperlink ScreenTip when the cell is an actual link.

Do Excel Comments show on hover?
Modern threaded Comments are intended for collaboration and are generally opened through the comment indicator or Comments interface. For simple text that appears when pointing to a cell, use a Note.

Can a data-validation message appear on hover?
No. The input message configured through Data > Data Validation appears when the cell is selected. It is useful for data-entry guidance, but selection is a different trigger from mouse hover.

Can I make a Note always visible?
Yes. Use the cell’s Show/Hide Note command or the corresponding command under Review > Notes. The Note remains displayed until you hide it again, though it may obscure worksheet cells.

Will hover text work on a phone or tablet?
Do not rely on it. Touch devices do not provide the same pointer-hover interaction as a desktop mouse. Put essential instructions in visible worksheet text or another format that works without hovering.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.