Forum Discussion

jslabarge's avatar
jslabarge
Copper Contributor
Dec 07, 2018

Excel Help Task Pane - Hotkey to close

Quite frequently, I press F1 instead of F2.

 

How can I close the Excel Help Task Pane without my hands leaving the keyboard?

 

Thanks.

excel

6 Replies

  • snth's avatar
    snth
    Copper Contributor
    Mar 08, 2024

    Hi jslabarge ,

     

    I had the same problem and posted my solution here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_unknown-mso_subother/keyboard-shortcuts-for-moving-between-application/11dd8df2-ff0a-4a05-95f5-4ebe181661ad?messageId=8e404492-4d86-49bd-b064-ef04d675d33b

     

    tl;dr CTRL+SPACE

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 07, 2018

    Hi,

     

    The only effective way I found to do so is to use this macro:

    Sub CloseHelpPane()
        Application.CommandBars("Help").Visible = False
    End Sub

    It's recommended to insert this macro into the https://trumpexcel.com/personal-macro-workbook/.

     

    Then add this macro to the Quick Access Toolbar so you can fire it using an Alt key shortcut.

     

    Hope that helps

     

Resources