Buzz
The Research tool in Excel is designed to quickly search for data within Excel and it automatically opens when you hold Alt + Click mouse. However, fret not! In this article, Software Tricks will guide you on how to disable Research in Excel.
1. Disabling the Research Tool in Excel
The Research tool pops up when you hold the Alt key and left-click a few times on the screen. Typically, we close it using the X icon in the top right corner, but that's just a temporary fix!
To permanently disable the Research tool, follow these steps:
Step 1: First, press the Alt + F11 key combination to open Microsoft Visual Basic in Excel.
Step 2: Then, select View and choose Immediate Windows (Ctrl + G) to open the command window.
Step 3: When the Immediate window appears, enter the command below and press Enter.
| Application.CommandBars(“Research”).Enabled = False |
Step 4: After entering the command, press the Alt + Q combination to save and exit the edit mode.
At this point, the Research window on your computer will automatically disappear. Even if you hold the Alt key and left-click multiple times, Research won't appear anymore!
2. How to enable the Research tool in Excel
To re-enable the Research tool after we have permanently turned it off, follow these steps:
Step 1: Repeat the steps from Step 1 to Step 2 of Part 1 - How to disable the Research tool in Excel.
Step 2: Next, enter the command below and press Enter to execute it.
| Application.CommandBars(“Research”).Enabled = True |
Step 3: After entering the command, press the Alt + Q combination to save and exit the edit mode.
In this article, Software Tricks has guided you on how to quickly and effectively disable the Research tool in Excel. Wishing you success!
