How to turn off Research in Excel
The research tool in Excel is activated with the Alt key + left mouse button to display the interface on the right side of the interface. However, many people often click mistakenly, causing the research interface to continuously display, affecting the adjustment of data in your 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 with the Alt key and left mouse button. The Research interface in Excel is displayed on the right edge of the screen for you to enter the content you want to search for. To turn off this interface, you just need to click on the X icon in the corner.
How to turn off Research in Excel Picture 1
But many people who want to completely turn off the Research tool in Excel need different settings.
Instructions for turning off Research in Excel
Step 1:
You press the key combination Alt + F11 to open Microsoft Visual Basic in Excel. Next, the user clicks View and select Immediate Windows (Ctrl + G) to open the command entry window.
How to turn off Research in Excel Picture 2
Step 2:
When displaying the command input interface below, enter the command line below and press Enter . Then press the key combination Alt + Q to save this change. As a result, when you return to the Excel interface, pressing Alt + mouse click will not display the Research tool .
Application.CommandBars('Research').Enabled = False
How to turn off Research in Excel Picture 3
Step 3:
In case you need to use this Research tool again in Excel, we enter the command below into the Microsoft Visual Basic interface. Then also press Enter and Alt + Q to save
Application.CommandBars('Research').Enabled = True
The result when you press the Alt key + click the mouse will display the Research tool again on the right edge of the Excel interface screen.
How to turn off Research in Excel Picture 4
How to turn Research back on in Excel
In case you want to reactivate the Research tool in Excel, we need to reopen the VBA interface, then press the key combination Ctrl + G to open the command entry window.
Below, enter the command below and press Enter.
Application.CommandBars('Research').Enabled = False
Then we press the key combination Alt + Q to save and exit editing mode. Then you reopen the Research interface in Excel as usual.
How to turn off Research in Excel Picture 5
You should read it
- How to Research a Topic
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- How to keep Excel and Excel columns fixed?
- What is ### error in Excel? how to fix ### error in Excel
- How to display 0 in front of a number in Excel
- Instructions for searching and replacing in Excel tables
- MS Excel 2007 - Lesson 2: Customizing in Excel
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- Shortcut guide, abbreviated in Excel
May be interested
How to unlock Excel files from editing
Instructions for dividing 1 cell into multiple cells in Excel
3 ways to convert time to decimal numbers in Excel and how to convert it back
How to draw straight lines and arrows in Excel - Draw shapes in Excel
Simple tips to help optimize your job search resume
4 Free spreadsheet software that can replace Micorsoft Excel