Computer >> Computer tutorials >  >> Software >> Office

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

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.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

Method 1 – Using the General Settings to Remove a Tooltip

Steps:

  • Click on File and select Options.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

  • 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.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

  • The tooltip is not showing anymore.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

Method 2 – Changing Advanced Settings from Excel Options

Steps:

  • Go to Excel Options.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

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

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

  • The tooltip will not show anymore.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

Method 3 – Modify the Formula Settings in Excel Options

Steps:

  • Go to File and then to Options.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

  • 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.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

  • The tooltip will not show anymore.

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

Read More: How to Edit Tooltip in Excel

Download the Practice Workbook

Related Articles

  • How to Create Dynamic Tooltip in Excel
  • How to Create Tooltip in Excel Chart
  • How to Show Full Cell Contents on Hover in Excel
  • Excel Button Tooltip
  • How to Display Tooltip on Mouseover Using VBA in Excel
  • How to Insert Excel Tooltip on Hover

<< Go Back to Excel Tooltip | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Eliminate Excel Tooltips Quickly: 3 Proven Techniques

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