How to Remove Tooltip in Excel (3 Quick Ways)

Consider a dataset of 10 employees of a company and their income for the first two months of a year. We are going to change the feature of the General, Formula, and Advanced tabs of the Excel Options.


Method 1 – Using the General Settings to Remove a Tooltip

Steps:

  • Click on File and select Options.

  • The Excel Options dialog box will appear.
  • In the General tab, click on the drop-down arrow of the ScreenTip style option and change the option from Show feature descriptions in ScreenTips to Don’t show ScreenTips from the User Interface options section.
  • Click OK.

Modification in General Tab to Remove Tooltip

  • The tooltip is not showing anymore.

How to remove tooltip in Excel


Method 2 – Changing Advanced Settings from Excel Options

Steps:

  • Go to Excel Options.

  • In the Advanced tab, scroll to the Display section.
  • Clear the Show function ScreenTips option.
  • Click OK.

Changing Advanced Tab from Excel Options to Remove Tooltip

  • The tooltip will not show anymore.

Disappearance of function completing tooltip in Excel


Method 3 – Modify the Formula Settings in Excel Options

Steps:

  • Go to File and then to Options.

  • A small dialog box called Excel Options will appear.
  • In the Formulas tab, uncheck the Formula AutoComplete option from the Working with formulas section.
  • Click OK.

Modify Formula Tab in Excel Options to Remove Tooltip

  • The tooltip will not show anymore.

Read More: How to Edit Tooltip in Excel


Download the Practice Workbook


Related Articles


<< Go Back to Excel Tooltip | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo