Remove a Black Tooltip After Entering Excel Formulas
Question details
The user wants to remove a black tooltip that appears after entering formulas in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering formulas in an Excel worksheet.
- Observed behavior
- A black tooltip appears after formula entry and disappears when the user switches worksheets or windows.
Note whether the tooltip appears in one workbook or several, and check your Excel version under File > Account. The Safe Mode and add-in steps below apply to Excel for Windows.
Update Office and restart Excel
Check for an Office update that may resolve a display issue.
In Excel for Windows, select File > Account > Update Options > Update Now. Install any available updates.
Close all Excel windows, reopen the workbook, and enter a formula to see whether the tooltip still appears.

Test Excel in Safe Mode and check add-ins
Use Safe Mode on Windows to determine whether an add-in may be causing the tooltip.
Test the formula in a new Excel workbook
Determine whether the behavior is limited to the original workbook.
Work with Excel formulas in WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheets for a straightforward transition, though it does not fix the tooltip in Microsoft Excel itself.

Frequently Asked Questions
Why does the black tooltip disappear when I switch worksheets?
Switching worksheets or windows may refresh Excel's display and temporarily clear the tooltip. It does not identify the cause, so test an Office update, Safe Mode, and a new workbook.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Then open the workbook and test the formula again.
What should I do if the tooltip disappears in Safe Mode?
Restart Excel normally and go to File > Options > Add-ins. Use the Manage list and Go button to disable add-ins one at a time, restarting and testing Excel after each change.
Does the issue affect every workbook?
Not necessarily. Select File > New > Blank workbook and enter a formula to compare its behavior with the original file.




