Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to disable the research task pane in Excel?

doc-disable-research-pane-1

In Excel, when you press Alt key and then click one cell in worksheet, a Research pane will appear at right of the sheet at the same time as following screenshot shown. This will be annoying. If you want to disable this pane, and make it no longer displayed when you apply Alt + Click in Excel. From this article, I will introduce you an easy way to solve it.

Disable the research task pane in Excel with VBA code


Quickly toggle workbook and worksheet settings in Excel:

With Kutools for Excel's View Option feature, you can quickly toggle any of the following settings: gridlines, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, and so on...

doc-disable-research-pane-3

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


arrow blue right bubble Disable the research task pane in Excel with VBA code


Do with the following operations to disable the research task pane in Excel:

1. Launch your workbook, and then hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

2. In the opened VB Editor, press Ctrl + G to open the Immediate Window, and then copy and paste this code Application.CommandBars("Research").Enabled = False into the Immediate box, and press Enter key on the keyboard, see screenshot:

doc disable research pane 02

3. Then save and close this VB Editor, and now, when you press Alt key and click the cell in the worksheet, the research task pane will not display any more.

Note:

If you need to make the research task pane appear again in your workbook, please copy and paste this code Application.CommandBars("Research").Enabled = True into the Immediate box to replace the original code, and remember to press Enter key.


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Crystal · 11 days ago
    thank you! thank you! thank you! this was driving me insane.
  • To post as a guest, your comment is unpublished.
    Raihan · 5 months ago
    Microsoft Excel Help pan Automatically popping up and I can not close it. If I close it excel program automatically minimized
  • To post as a guest, your comment is unpublished.
    Zoe · 7 months ago
    Thankyou so much for this fix.
  • To post as a guest, your comment is unpublished.
    Akshay · 1 years ago
    Thanks man.
  • To post as a guest, your comment is unpublished.
    Douglas · 1 years ago
    In the screen shot you have false spelled incorrectly. Application.CommandBars("Research").Enabled = Fasle
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hi, Douglas,
      Thank you for your comment, I have updated the screenshot.
      Best regards.
      • To post as a guest, your comment is unpublished.
        nick · 3 months ago
        I'm more of a flase kind of guy.
  • To post as a guest, your comment is unpublished.
    Priya chandra · 1 years ago
    Thanks a lot
  • To post as a guest, your comment is unpublished.
    Goodnhan · 1 years ago
    Very useful. Thanks!
  • To post as a guest, your comment is unpublished.
    Yanda · 1 years ago
    The research panel will disable when you perform 'Alt+Click' again
  • To post as a guest, your comment is unpublished.
    MKM · 1 years ago
    Thank you for uploading this.
    It was veryyyyyyyyyyyyy annoying.
    Thanks once again.
  • To post as a guest, your comment is unpublished.
    jitender kumar · 1 years ago
    thank you very much , i suffer a lot due to this bing search. thanks.
  • To post as a guest, your comment is unpublished.
    Ashirvad Patnaik · 2 years ago
    Thanks a lot!!!
  • To post as a guest, your comment is unpublished.
    Swati · 2 years ago
    Thanks so much for this very well explained solution. You rock!
  • To post as a guest, your comment is unpublished.
    JJ · 2 years ago
    Click on the drop-down arrow at the top right corner of the research panel.
    Select 'Close'.

    The research panel will appear when you perform 'Alt+Click'
  • To post as a guest, your comment is unpublished.
    Kulranjan · 2 years ago
    Working. Thanks so much.
  • To post as a guest, your comment is unpublished.
    Colette · 2 years ago
    Thank you so much! This was such a pain!
  • To post as a guest, your comment is unpublished.
    zack · 2 years ago
    I have a problem with the task pane opening asking whether I want to save old backup copies with the default "no". Start Rant: This is the dumbest thing excel should do...if they were not user hostile and totally inept, they would not bother the user with this option very time they open a file but rather give it as an "important" option or indicator that their are such files. Having to click to acknowlege that is a waste of time, but to add insult to injury, the default click is to "delete the files"!!! this is stupidity at its worst...so you are constantly annoyed and then you have a large number of chances to accidentally click no when you might need those backups...stupid just stupid. Does anyone know how to disable this task pane in excel?
  • To post as a guest, your comment is unpublished.
    kunal · 3 years ago
    rocking..solution man....
  • To post as a guest, your comment is unpublished.
    Cat · 3 years ago
    THANK you! You are right, that was SO annoying.
  • To post as a guest, your comment is unpublished.
    Krishna · 3 years ago
    Dear this is working....:) thanks a lot.