How to Remove Tooltip in Excel (3 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

A tooltip is a small window in Excel, which usually provide a short explanation about the capability of that tool. However, sometimes the presence of this toolbar causes disturbance for the users while they work on a large data table. In this article, we are going to demonstrate three quick ways to remove the tooltip in Excel. If you are also curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Quick Ways to Remove Tooltip in Excel

To demonstrate the approaches, we 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.

Note

All the operations of this article are accomplished by using Microsoft Office 365 application.


1. Modification in General Tab to Remove Tooltip

In the last process, we are going to do some modifications to the General tab. We will keep our previous dataset to demonstrate the approach. The procedure is explained below step-by-step:

๐Ÿ“Œ Steps:

  • First of all, click on the File > Options option.

  • The Excel Options dialog box will appear.
  • Afterward, 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.
  • At last, click OK.

Modification in General Tab to Remove Tooltip

  • You will figure out that the tooltip is not showing anymore.

How to remove tooltip in Excel

๐Ÿ‘‰ Thus, we can say that our process works perfectly, and we are able to remove the tooltip in Excel.

Read More: How to Add Cell Tooltip in Excel (3 Easy Methods)


2. Changing Advanced Tab from Excel Options

In this approach, we are going to change the option of the Advanced tab from the Excel Options option. The steps of this procedure are shown as follows:

๐Ÿ“Œ Steps:

  • At first, click on the File > Options option.

  • Hence, a small dialog box called Excel Options will appear.
  • After that, in the Advanced tab, scroll down with your mouse to find the Display section.
  • Then, clear the Show function ScreenTips option.
  • Finally, click OK.

Changing Advanced Tab from Excel Options to Remove Tooltip

  • You will notice that the tooltip will not show anymore.

Disappearance of function completing tooltip in Excel

๐Ÿ‘‰ Hence, we can say that our procedure works effectively, and we are able to remove the tooltip from the Excel worksheet.

Read More: How to Display Tooltip on Mouseover Using VBA in Excel


3. Modify Formula Tab in Excel Options

In the first method, we will modify the feature of the Formula tab from the Excel Options option. The steps of this process are given below:

๐Ÿ“Œ Steps:

  • First of all, click on the File > Options option.

  • As a result, a small dialog box called Excel Options will appear.
  • Now, in the Formulas tab, uncheck the Formula AutoComplete option from the Working with formulas section.
  • Then, click OK.

Modify Formula Tab in Excel Options to Remove Tooltip

  • You will show that the tooltip will not show anymore.

๐Ÿ‘‰ Finally, we can say that our approach works successfully, and we are able to remove the tooltip from the Excel spreadsheet.

Read More: How to Edit Tooltip in Excel (2 Easy Methods)


Conclusion

Thatโ€™s the end of this article. I hope that this article will be helpful for you and you will be able to remove the tooltip in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Donโ€™t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo