How to Fix Excel Showing the Same Hover Text Over Every Cell
Question details
The user needs to resolve an issue where the exact same tooltip or comment-like text appears when hovering over multiple cells in a workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working in an Excel worksheet that utilizes the PyXLL add-in, where the add-in cannot be disabled for testing.
- Observed behavior
- Identical hover text displays across every cell despite the absence of any visible comments or notes on the worksheet.
Save your work and create a backup copy of the affected Excel file before modifying global settings or clearing application caches.
Check and Clear Data Validation Input Messages
Data validation rules can include an 'Input Message' that acts like a hover tooltip. If applied to the entire sheet, it causes the same text to appear everywhere.
Often, phantom hover text is not a standard Excel comment or note, but rather an input message tied to a Data Validation rule. Users might accidentally apply this rule to a large range of cells.
Click the triangle icon in the top-left corner of the worksheet (where the row and column headers meet) or press Ctrl+A to select the entire sheet.
Navigate to the 'Data' tab on the Excel ribbon and click on 'Data Validation' in the Data Tools group.
In the Data Validation dialog box, click on the 'Input Message' tab. Look for any text that matches the phantom hover text you are seeing.
Uncheck the box that says 'Show input message when cell is selected' or click the 'Clear All' button, then click 'OK' to apply the changes.
Clear the Office Document Cache
Clearing the document cache forces Excel to discard temporary files that might be causing visual glitches or stuck tooltips.
Investigate PyXLL Add-in Conflicts
Since the workbook relies on the PyXLL add-in, compare the file against other working documents to isolate add-in specific corruption.
Try WPS Office for a Seamless Spreadsheet Experience
If you are tired of troubleshooting Excel add-in glitches, phantom tooltips, and caching errors, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative to Microsoft Office, ensuring smooth data management without the clutter of conflicting add-ins.
- 1. Download WPS Office: Visit the official WPS website and download the free office suite for your operating system.
- 2. Install the application: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office.
- 3. Open your spreadsheet: Launch WPS Spreadsheet and open your Excel file to view, edit, and manage your data without persistent tooltip glitches.
Frequently Asked Questions
Why does Excel show a tooltip when there is no comment?
This is typically caused by a Data Validation 'Input Message' applied to the cells. Unlike standard comments, input messages do not show a red indicator triangle but will display a yellow tooltip whenever the cell is clicked or hovered over.
How do I remove a data validation input message in Excel?
Select the affected cells, navigate to the Data tab, and click Data Validation. Go to the Input Message tab, and either uncheck 'Show input message when cell is selected' or delete the text in the message box.
Can a corrupted Excel add-in cause display glitches?
Yes, third-party add-ins can sometimes misinterpret cell data, cache old tooltips, or conflict with Excel's rendering engine, leading to persistent hover text across the sheet.
How do I clear the Office document cache?
You can clear the cache by going to File > Options > Save in Excel. Under the Cache Settings section, click 'Delete cached files', confirm the action, and then restart the application.
