提示:其他語言是Google翻譯的。 你可以訪問 English 版本。
登入
x
or
x
x
註冊
x

or

如何禁用Excel中的研究任務窗格?

DOC-禁用的研究窗格中,1

在Excel中,當你按下 其他 鍵,然後單擊工作表中的一個單元格 研究窗格 將在下面的屏幕截圖所示的同時出現在表單右側。 這會很煩人。 如果您想禁用此窗格,並在應用時使其不再顯示 Alt + Click 在Excel中。 從這篇文章中,我將向您介紹解決這個問題的簡單方法。

使用VBA代碼禁用Excel中的研究任務窗格


在Excel中快速切換工作簿和工作表設置:

Kutools for Excel's 查看選項 功能,您可以快速切換以下任何設置:網格線,垂直滾動條,行和列標題,分頁符,公式視圖,工作表標籤,狀態欄,公式欄等等...

DOC-禁用的研究窗格中,3

Kutools for Excel:比200方便的Excel加載項,可以在60天免費試用。 下載並免費試用現在!


箭頭藍色右泡 使用VBA代碼禁用Excel中的研究任務窗格


使用以下操作來禁用Excel中的研究任務窗格:

1。 啟動您的工作簿,然後按住 Alt + F11鍵 在Excel中的鍵,它打開 Microsoft Visual Basic for Applications窗口.

2。 在打開的VB編輯器中,按 Ctrl + G 打開 即時窗口,然後復制並粘貼此代碼 Application.CommandBars(“Research”)。Enabled = False 即時 框,然後按 輸入 鍵盤上的按鍵,看截圖:

doc禁用研究窗格02

3。 然後保存並關閉這個VB編輯器,現在,當你按下 其他 鍵並單擊工作表中的單元格,研究任務窗格將不再顯示。

備註:

如果您需要使研究任務窗格再次出現在工作簿中,請複制並粘貼此代碼 Application.CommandBars(“Research”)。Enabled = True 即時 框來替換原始代碼,並記得按下 輸入 鍵。


Kutools for Excel解決了您的大多數問題,並使您的生產率提高了80%

  • 重用: 快速插入 複雜的公式,圖表 以及你以前用過的任何東西; 加密單元格 密碼; 創建郵件列表 並發送電子郵件...
  • 超級方程式酒吧 (輕鬆編輯多行文字和公式); 閱讀佈局 (輕鬆讀取和編輯大量單元格); 粘貼到過濾範圍...
  • 合併單元格/行/列 不丟失數據; 分裂細胞含量; 組合重複的行/列...防止重複的細胞; 比較範圍...
  • 選擇複製或唯一 行; 選擇空行 (所有細胞都是空的); 超級查找和模糊查找 在許多工作簿中; 隨機選擇......
  • 精確複製 多個單元格而不更改公式參考; 自動創建參考 多張表; 插入項目符號,複選框等等......
  • 提取文本,添加文本,按位置刪除, 刪除空間; 創建和打印分頁小計; 在單元格內容和註釋之間轉換...
  • 超級過濾器 (將過濾方案保存並應用到其他工作表); 高級排序 按月/週/日,頻率等; 特殊過濾器 用粗體,斜體......
  • 結合工作簿和工作表; 根據鍵列合併表; 將數據拆分為多個表格; 批量轉換xls,xlsx和PDF...
  • 超過300強大的功能。 支持Office / Excel 2007-2019和365。 支持所有語言。 在您的企業或組織中輕鬆部署。 全功能30天免費試用。
kte tab 201905

Office選項卡為Office提供選項卡式界面,使您的工作更輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,Publisher,Access,Visio和Project。
  • 在同一窗口的新選項卡中打開並創建多個文檔,而不是在新窗口中。
  • 通過50%提高您的工作效率,每天為您減少數百次鼠標點擊!
官方底部
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 · 10 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.