Office Settings & Configuration

Remove a Black Tooltip After Entering Excel Formulas

Huda QurayshiHuda Qurayshi Nov 18, 2026 870 views

Question details

The user wants to remove a black tooltip that appears after entering formulas in Excel.

Remove a Black Tooltip After Entering Excel Formulas
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.
Before you start

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.

Solution 1Recommended

Update Office and restart Excel

Check for an Office update that may resolve a display issue.

1
Check for updates

In Excel for Windows, select File > Account > Update Options > Update Now. Install any available updates.

2
Restart Excel

Close all Excel windows, reopen the workbook, and enter a formula to see whether the tooltip still appears.

Update Office and restart Excel
Update options may differ: If Update Options is unavailable, Office updates may be managed by your organization. Contact your administrator or check the update method used for your installation.
Free Microsoft Office alternative

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.

Enter and edit spreadsheet formulas in WPS SpreadsheetsOpen and save compatible Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceMove existing workbooks to a lightweight office suite
microsoft office alternative - wps office

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.