To turn off Research in Excel for Windows, close the Research pane with the X in its top-right corner. To stop it from opening again when you hold Alt and click a cell, press Alt+F11, press Ctrl+G, type Application.CommandBars(“Research”).Enabled = False in the Immediate window, and press Enter.
Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows. Checked against Microsoft Support and Microsoft Learn on October 7, 2026.
What the Research pane is and why it keeps opening
Research is an older Office lookup tool. It opens as a task pane (a panel docked to the side of the worksheet) and searches reference services such as dictionaries and translation tools for the text you give it. Microsoft’s current documentation still lists it for Excel: you open it on purpose from the Review tab by selecting Research.
The accidental route is the one that annoys people. Microsoft’s Research instructions for Excel say that pressing Alt and clicking a cell looks up that cell’s contents. If you hold Alt for another reason and click a cell at the same moment, the pane can appear even though you never asked for it. Closing the pane does not change that behavior, which is why it returns.
You have three levels of control, from lightest to strongest:
- Close the pane. Good enough if it appeared once.
- Turn off the Research command with one line of VBA. This is the method that stops the Alt+click pop-up.
- Switch off the lookup services in Research Options. The pane can still open, but it has nothing to search with. This is the choice if your concern is cell text being sent to online reference services.
Before you start
- Save your workbook. None of these steps change cell data or formulas, but saving first is a sensible habit before you open the Visual Basic Editor.
- You need the desktop version of Excel for Windows. The VBA method relies on the Visual Basic Editor, which is part of the desktop app.
- On a work or school computer, your organization may block the Visual Basic Editor or lock Trust Center settings. If a step is unavailable, skip to the troubleshooting section.
Close the Research pane
- Find the Research pane at the side of the Excel window.
- Click the X in the top-right corner of the pane. The pane closes and the worksheet widens to fill the space.
If you prefer the keyboard, Microsoft’s Excel shortcut list says F6 switches between the worksheet, the ribbon, the task pane and the Zoom controls, so you can press it until the pane is selected. Closing the pane is temporary: the next Alt+click on a cell can open it again.
Turn off the Research pane with one line of VBA
This method comes from the accepted answer to this exact question on Microsoft Q&A, Microsoft’s own support forum, written by a volunteer moderator. It uses the Immediate window, a box in the Visual Basic Editor where you type a single line of code and run it by pressing Enter. You do not need to create or save a macro.
- Open Excel. Any workbook will do, including a blank one.
- Press Alt+F11. The Microsoft Visual Basic for Applications editor opens in its own window.
- Press Ctrl+G. The Immediate window appears, usually along the bottom of the editor. If the shortcut does nothing, open the editor’s View menu and choose Immediate window.
- Click inside the Immediate window and type or paste this line exactly, including the quotation marks: Application.CommandBars(“Research”).Enabled = False
- With the cursor anywhere on that line, press Enter. Nothing visible happens and no message appears; that is normal.
- Press Alt+F4 to close the Visual Basic Editor and return to your worksheet.
Why this works: the line sets the Enabled property of the command bar named Research. Microsoft’s VBA reference says that setting this property to False forces the item to be disabled, while setting it to True hands control back to the application.
For a wider look at what Research is for and how its services are managed, see Microsoft’s page on how to add or change research services, and the Microsoft Learn page on how to use the Immediate window.
Confirm it worked, or turn Research back on
To check the result, go back to a worksheet, hold Alt and click a cell that contains text. The Research pane should stay closed.
To undo the change, repeat the steps above with the opposite value: Application.CommandBars(“Research”).Enabled = True. After you press Enter, the Research command on the Review tab and the Alt+click lookup are available again.
If the pane comes back after you restart Excel
Several people in the same Microsoft Q&A thread reported that the pane returned after they closed and reopened Excel. If that happens to you, there are two legitimate options.
The simple option is to run the line again. Once you have done it a couple of times it takes a few seconds: Alt+F11, Ctrl+G, paste, Enter, Alt+F4.
The automatic option is for readers who are comfortable with macros. Excel has a Personal Macro Workbook, a hidden file named Personal.xlsb that Microsoft says opens automatically whenever Excel starts because it is stored in the XLStart folder. Excel creates it the first time you record a macro from the Developer tab with Record Macro and choose Personal Macro Workbook in the Store macro in list. Microsoft’s VBA reference also documents a Workbook_Open event that runs “when the workbook is opened.” Placing the Research line inside a Workbook_Open procedure in your Personal Macro Workbook makes Excel apply it at every start. Microsoft does not publish this as a Research fix, so treat it as a workaround, and skip it if your organization restricts macros.
Switch off Research services instead
If you would rather not touch VBA, or your main worry is that cell contents are being sent to online lookup services, turn the services off. The pane may still open, but it will have fewer services, or none, to search.
- Select File, then Options. The Excel Options window opens.
- Select Trust Center, then click Trust Center Settings.
- Open the Privacy Options tab and click Research Options. A list of research services appears, each with a check box.
- Clear the check box next to each service you do not want Excel to use.
- Click OK, then close the remaining windows.
You can reach the same list from the pane itself: select Review, then Research, and click Research Options near the bottom of the Research task pane. In that window, Update/Remove lets you select a provider and click Remove, and Parental Control offers settings that help filter potentially offensive results. To reverse any of this, return to Research Options and tick the services again.
Troubleshooting
Alt+F11 does nothing
Some laptops need the Fn key held with the function keys, so try Fn+Alt+F11. If the editor still does not open on a work or school computer, the Visual Basic Editor may be restricted by your IT department. Use the Research Options method instead, or ask your administrator.
You get an error after pressing Enter
The line must be typed exactly, with straight quotation marks around the word Research and a period between each part. Text copied from an email or a word processor often contains curly quotation marks, which can cause an error. Delete the line, type it by hand and press Enter again.
There is no Research Options button or the list is locked
Trust Center settings can be managed centrally in organizations. If the button is missing or the check boxes cannot be changed, the setting is controlled by your administrator.
A different pane keeps opening
Check the title at the top of the pane. If it does not say Research, the steps here will not affect it. Panes added by third-party tools come from add-ins. Microsoft’s instructions for those are to select File > Options > Add-Ins, choose COM Add-ins in the Manage box, click Go, and clear the check box for the add-in you suspect. Clear one at a time so you can tell which one was responsible.
You looked for a check box in Excel Options and could not find one
Some guides describe a single option under the Advanced settings that hides the Research pane. Microsoft’s Research documentation does not list such a switch for Excel; the controls it documents are the service list in Research Options. Hiding the Research button on the ribbon only hides the button; Microsoft documents Alt+click as a separate way to start a lookup.
Excel is misbehaving in other ways too
If keys and clicks are doing unexpected things beyond the Research pane, our guide on how to unlock the cursor in Excel covers Scroll Lock, add-ins and other common causes.
Frequently asked questions
Why does the Research pane open when I click a cell?
Because the Alt key was down when you clicked. In Excel, Alt plus a click on a cell is the built-in gesture for looking up that cell’s contents in Research.
Will turning off Research delete anything or break my formulas?
No. Research is a lookup tool that sits beside the worksheet. Closing it, disabling its command or clearing its services does not edit cells, formulas or formatting.
Does the VBA line affect only the open workbook?
No. The line begins with Application, which refers to Excel itself, so it is not saved inside the workbook and does not travel with the file when you send it to someone else. Other people who open your workbook keep their own Research behavior.
Is it safe to type code into the Immediate window?
This particular line only changes whether one built-in command is available, and you can reverse it by running the same line with True. As a general rule, only run code when you understand what it does and it comes from a source you trust.
Can I still use Research after turning it off?
Not until you turn it back on with the True version of the line. If you want Research available on demand but never by accident, leave it enabled and simply avoid holding Alt while clicking cells.
Does this work in Word or PowerPoint?
Research exists in those apps too, and Microsoft’s services page covers them. The same volunteer moderator gave the identical VBA line for Word on Microsoft Q&A. The steps in this article were checked for Excel only.
If the pane appeared just once, closing it is all you need. If it keeps interrupting your work, run the one-line command, then Alt+click a cell to confirm that Research stays closed.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.