How to Fix Missing Excel Hyperlink Hover Text in SharePoint Online
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.

- 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.
Ensure you have editing permissions for the Excel workbook in SharePoint Online so you can modify the hyperlink display text.
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.
Navigate to SharePoint Online and open your Excel workbook in Excel for the web. Ensure you are in 'Editing' mode rather than 'Viewing' mode.
Right-click the cell containing the problematic hyperlink and select 'Edit Hyperlink' from the context menu.
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').
Click 'OK' to apply the changes. Hover your cursor over the modified hyperlink to confirm the text now appears correctly.

Open the Workbook in the Excel Desktop Application
Bypass the web browser limitations by opening the file directly in the full desktop version of Excel.
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. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx file directly to view it without web-based limitations.
- 3. View Hyperlinks Without Issue: Hover over your hyperlinks to easily view long display texts without needing to replace spaces with underscores.

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.




