The research tool in Excel is activated by Alt + left mouse button to display the interface on the right side of the interface. However, many people often click by mistake, causing the research interface to continuously display, affecting your data adjustment in Excel. If you do not need to use research in Excel, you can completely turn off this tool according to the instructions below.
What is the Research feature in Excel?
The Research tool in Excel is a data and content search tool and is activated by the Alt key and the left mouse button. The Research interface in Excel is displayed on the right side of the screen for you to enter the content you want to search for. To turn off this interface, just click on the X icon in the corner.
But many people want to completely turn off the Research tool in Excel, so they need to set it up differently.
Instructions to turn off Research in Excel
Step 1:
You press Alt + F11 to open Microsoft Visual Basic on Excel. Next, the user clicks View and selects Immediate Windows (Ctrl + G) to open the command input window.
Step 2:
When the command input interface is displayed below, enter the command line below and press Enter . Then press the Alt + Q key combination to save this change. As a result, when returning to the Excel interface, pressing the Alt + mouse click key combination will not display the Research tool .
Application.CommandBars(“Research”).Enabled = False
Step 3:
In case you need to reuse this Research tool in Excel, we enter the command below into the Microsoft Visual Basic interface. Then press Enter and Alt + Q to save.
Application.CommandBars(“Research”).Enabled = TrueThe result when you press Alt + click will display the Research tool again on the right side of the Excel interface screen.
How to turn Research back on in Excel
In case you want to re-enable the Research tool in Excel, we need to reopen the VBA interface, then press Ctrl + G to open the command input window.
Below you enter the command below and press Enter.
Application.CommandBars(“Research”).Enabled = FalseThen we press the key combination Alt + Q to save and exit editing mode. Then you reopen the Research interface in Excel as usual.
Using a laptop with an external monitor is a great combination for productivity and getting work done. But over time, you may find that your laptop suddenly runs out of battery quickly and the battery life starts to decrease.
There’s no denying that foldable phones are pretty cool. But after using them for a while, there are a few quirks to them. Here are 5 major downsides to foldable phones that you might not expect!
Adobe has brought AI video creation technology to the masses in a new way, although it has yet to create a finished movie using the technology.
Genshin Impact 5.5 Code helps you exchange for Primordial Stones, Magic Minerals, experience and many other rewards.
macOS Catalina and iPadOS include support for a new feature called Sidecar, designed to let you use your iPad as a secondary display for your Mac.
This is a set of Nokia 1280 wallpapers, if you have ever texted to get 1280 wallpapers, brick phone wallpapers, then try looking at these wallpapers.
Venus Aerospace has revealed the first images of its new hypersonic aircraft called the Stargazer, which can reach a top speed of 11,115 km/h, equivalent to Mach 9.
Bloating can happen to anyone. The good news is that breakfast is a great time to add a few ingredients to your meal that can help reduce bloating. That ingredient is bananas.
OpenAI has just officially introduced a remarkable upgrade to the AI image generation capability in ChatGPT, an important step forward instead of using a separate image generation model like the previous DALL-E.
Chinese AI startup DeepSeek has just officially released its latest large language model (LLM), DeepSeek-V3-0324.
Gboard has long been the go-to keyboard on Android phones. However, many people have recently switched to Samsung Keyboard and haven't looked back.
Send sweet and romantic weekend wishes to your lover. Although they are just words or messages, they will be meaningful spiritual gifts, helping to strengthen your relationship.
HBO's Harry Potter remake is expected to premiere in 2026. Here's what makes the TV Harry Potter a success.
Beautiful moon pictures are not rare on the Internet. This article will summarize for you the most beautiful moon pictures in the world.
Now, AMD has responded to the issues with its underperforming flagship CPU line with a new update that could deliver a few more frames per second.
