Office Compatibility Issues

How to Fix Missing Excel Hyperlink Hover Text in SharePoint Online

Khadija KhanKhadija Khan Nov 3, 2026 868 views

Question details

Users are unable to see the hover text for hyperlinks containing long strings of text when viewing an Excel workbook hosted on SharePoint Online.

Fix Missing Excel Hyperlink Hover Text in SharePoint Online
Product
Excel for the web / SharePoint Online
Device & OS
not provided
Scenario
Hovering over a hyperlink cell in an Excel workbook opened within a web browser via SharePoint Online.
Observed behavior
Hover text for long hyperlinks does not appear at all, whereas short hyperlink text (e.g., 'TEST') displays correctly on hover.
Before you start

Ensure you have editing permissions for the Excel workbook in SharePoint Online so you can modify the hyperlink display text.

Solution 1Recommended

Replace Spaces with Underscores in the Hyperlink Text

Modify the display text of the hyperlink to replace all spaces with underscores, which bypasses the rendering bug in Excel for the web.

Excel for the web can struggle to render long strings of text containing spaces within hover tooltips. By replacing spaces with underscores, the system treats the text as a continuous string, allowing the hover tooltip to display properly.

1
Open the workbook for editing

Navigate to SharePoint Online and open your Excel workbook in Excel for the web. Ensure you are in 'Editing' mode rather than 'Viewing' mode.

2
Edit the hyperlink

Right-click the cell containing the problematic hyperlink and select 'Edit Hyperlink' from the context menu.

3
Modify the display text

In the 'Text to display' field, locate any spaces in your long text and replace them with underscores (for example, change 'Needle placement non-spine' to 'Needle_placement_non-spine').

4
Save and test

Click 'OK' to apply the changes. Hover your cursor over the modified hyperlink to confirm the text now appears correctly.

Replace Spaces with Underscores in the Hyperlink Text
Formula Update: If you are using the HYPERLINK formula, ensure you also update the 'friendly_name' argument to use underscores instead of spaces.
Free Microsoft Office alternative

Use WPS Office as a Seamless Alternative to Microsoft Excel

Since Excel for the web has known limitations with displaying long hyperlink texts, consider using WPS Office. It provides a lightweight, highly compatible spreadsheet application that handles complex links and formatting with ease, ensuring a smooth workflow without web-based glitches.

  1. 1. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx file directly to view it without web-based limitations.
  3. 3. View Hyperlinks Without Issue: Hover over your hyperlinks to easily view long display texts without needing to replace spaces with underscores.
Free and highly compatible with Microsoft Excel (.xlsx) file formats.Reliable and accurate display of long hyperlink hover text and complex spreadsheet data.Lightweight installation with an intuitive, familiar user interface.Seamless transition from Microsoft Office with no steep learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why do only short hyperlinks show hover text in SharePoint Online?

Excel for the web has rendering limitations when handling long character strings in hover tooltips. Short text easily fits within the default rendering constraints, while longer text with spaces can trigger a bug that prevents it from displaying.

Can I fix the hyperlink hover issue without changing my display text?

If you must keep spaces in your display text and avoid using underscores, the most effective workaround is to open the workbook using the desktop application rather than the web version.

Will using the HYPERLINK function formula resolve the web display issue?

Using the HYPERLINK formula might still result in missing hover text in Excel for the web if the 'friendly_name' argument contains spaces. Replacing spaces with underscores within the formula is still necessary to bypass the web rendering glitch.

Does this hyperlink text issue affect printed Excel documents?

No, this is purely a visual display glitch in the web browser interface. Printed documents or exported PDFs will not be affected by the hover text limitation.